Debian Codegraph @

mysql-test/suite/engines/funcs/r/in_string_boundary_error.result

raw
1 SET SQL_MODE="TRADITIONAL,ANSI";
2 DROP TABLE IF EXISTS t3;
3 CREATE TABLE t3(c1 CHAR(100) NOT NULL);
4 INSERT INTO t3 (c1) VALUES(NULL);
5 ERROR 23000: Column 'c1' cannot be null
6 INSERT INTO t3 (c1) VALUES('x');
7 INSERT INTO t3 (c1) VALUES('');
8 INSERT INTO t3 (c1) VALUES('123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.x');
9 ERROR 22001: Data too long for column 'c1' at row 1
10 SELECT COUNT(c1) AS total_rows FROM t3;
11 total_rows
12 2
13 SELECT COUNT(c1) AS null_rows FROM t3 WHERE c1 IS NULL;
14 null_rows
15 0
16 SELECT COUNT(c1) AS not_null_rows FROM t3 WHERE c1 IS NOT NULL;
17 not_null_rows
18 2
19 DROP TABLE t3;
20 CREATE TABLE t3(c1 VARCHAR(100) NOT NULL);
21 INSERT INTO t3 (c1) VALUES(NULL);
22 ERROR 23000: Column 'c1' cannot be null
23 INSERT INTO t3 (c1) VALUES('x');
24 INSERT INTO t3 (c1) VALUES('');
25 INSERT INTO t3 (c1) VALUES('123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.x');
26 ERROR 22001: Data too long for column 'c1' at row 1
27 SELECT COUNT(c1) AS total_rows FROM t3;
28 total_rows
29 2
30 SELECT COUNT(c1) AS null_rows FROM t3 WHERE c1 IS NULL;
31 null_rows
32 0
33 SELECT COUNT(c1) AS not_null_rows FROM t3 WHERE c1 IS NOT NULL;
34 not_null_rows
35 2
36 DROP TABLE t3;
37 CREATE TABLE t3(c1 BINARY(100) NOT NULL);
38 INSERT INTO t3 (c1) VALUES(NULL);
39 ERROR 23000: Column 'c1' cannot be null
40 INSERT INTO t3 (c1) VALUES('x');
41 INSERT INTO t3 (c1) VALUES('');
42 INSERT INTO t3 (c1) VALUES('123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.x');
43 ERROR 22001: Data too long for column 'c1' at row 1
44 SELECT COUNT(c1) AS total_rows FROM t3;
45 total_rows
46 2
47 SELECT COUNT(c1) AS null_rows FROM t3 WHERE c1 IS NULL;
48 null_rows
49 0
50 SELECT COUNT(c1) AS not_null_rows FROM t3 WHERE c1 IS NOT NULL;
51 not_null_rows
52 2
53 DROP TABLE t3;
54 CREATE TABLE t3(c1 VARBINARY(100) NOT NULL);
55 INSERT INTO t3 (c1) VALUES(NULL);
56 ERROR 23000: Column 'c1' cannot be null
57 INSERT INTO t3 (c1) VALUES('x');
58 INSERT INTO t3 (c1) VALUES('');
59 INSERT INTO t3 (c1) VALUES('123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.123456789.x');
60 ERROR 22001: Data too long for column 'c1' at row 1
61 SELECT COUNT(c1) AS total_rows FROM t3;
62 total_rows
63 2
64 SELECT COUNT(c1) AS null_rows FROM t3 WHERE c1 IS NULL;
65 null_rows
66 0
67 SELECT COUNT(c1) AS not_null_rows FROM t3 WHERE c1 IS NOT NULL;
68 not_null_rows
69 2
70 DROP TABLE t3;