Debian Codegraph @

mysql-test/suite/engines/funcs/t/in_number_boundary_error.test

raw
1 SET SQL_MODE="TRADITIONAL,ANSI";
2 --disable_warnings
3 DROP TABLE IF EXISTS t4;
4 --enable_warnings
5 CREATE TABLE t4(c1 TINYINT UNSIGNED NOT NULL);
6 --error 1048
7 INSERT INTO t4 (c1) VALUES(NULL);
8 INSERT INTO t4 (c1) VALUES(0);
9 --error 1264
10 INSERT INTO t4 (c1) VALUES(-1);
11 --error 1366
12 INSERT INTO t4 (c1) VALUES('x');
13 INSERT INTO t4 (c1) VALUES('9');
14 SELECT COUNT(c1) AS total_rows FROM t4;
15 SELECT COUNT(c1) AS null_rows FROM t4 WHERE c1 IS NULL;
16 SELECT COUNT(c1) AS not_null_rows FROM t4 WHERE c1 IS NOT NULL;
17 DROP TABLE t4;
18 CREATE TABLE t4(c1 SMALLINT UNSIGNED NOT NULL);
19 --error 1048
20 INSERT INTO t4 (c1) VALUES(NULL);
21 INSERT INTO t4 (c1) VALUES(0);
22 --error 1264
23 INSERT INTO t4 (c1) VALUES(-1);
24 --error 1366
25 INSERT INTO t4 (c1) VALUES('x');
26 INSERT INTO t4 (c1) VALUES('9');
27 SELECT COUNT(c1) AS total_rows FROM t4;
28 SELECT COUNT(c1) AS null_rows FROM t4 WHERE c1 IS NULL;
29 SELECT COUNT(c1) AS not_null_rows FROM t4 WHERE c1 IS NOT NULL;
30 DROP TABLE t4;
31 CREATE TABLE t4(c1 MEDIUMINT UNSIGNED NOT NULL);
32 --error 1048
33 INSERT INTO t4 (c1) VALUES(NULL);
34 INSERT INTO t4 (c1) VALUES(0);
35 --error 1264
36 INSERT INTO t4 (c1) VALUES(-1);
37 --error 1366
38 INSERT INTO t4 (c1) VALUES('x');
39 INSERT INTO t4 (c1) VALUES('9');
40 SELECT COUNT(c1) AS total_rows FROM t4;
41 SELECT COUNT(c1) AS null_rows FROM t4 WHERE c1 IS NULL;
42 SELECT COUNT(c1) AS not_null_rows FROM t4 WHERE c1 IS NOT NULL;
43 DROP TABLE t4;
44 CREATE TABLE t4(c1 INT UNSIGNED NOT NULL);
45 --error 1048
46 INSERT INTO t4 (c1) VALUES(NULL);
47 INSERT INTO t4 (c1) VALUES(0);
48 --error 1264
49 INSERT INTO t4 (c1) VALUES(-1);
50 --error 1366
51 INSERT INTO t4 (c1) VALUES('x');
52 INSERT INTO t4 (c1) VALUES('9');
53 SELECT COUNT(c1) AS total_rows FROM t4;
54 SELECT COUNT(c1) AS null_rows FROM t4 WHERE c1 IS NULL;
55 SELECT COUNT(c1) AS not_null_rows FROM t4 WHERE c1 IS NOT NULL;
56 DROP TABLE t4;
57 CREATE TABLE t4(c1 INTEGER UNSIGNED NOT NULL);
58 --error 1048
59 INSERT INTO t4 (c1) VALUES(NULL);
60 INSERT INTO t4 (c1) VALUES(0);
61 --error 1264
62 INSERT INTO t4 (c1) VALUES(-1);
63 --error 1366
64 INSERT INTO t4 (c1) VALUES('x');
65 INSERT INTO t4 (c1) VALUES('9');
66 SELECT COUNT(c1) AS total_rows FROM t4;
67 SELECT COUNT(c1) AS null_rows FROM t4 WHERE c1 IS NULL;
68 SELECT COUNT(c1) AS not_null_rows FROM t4 WHERE c1 IS NOT NULL;
69 DROP TABLE t4;
70 CREATE TABLE t4(c1 BIGINT UNSIGNED NOT NULL);
71 --error 1048
72 INSERT INTO t4 (c1) VALUES(NULL);
73 INSERT INTO t4 (c1) VALUES(0);
74 --error 1264
75 INSERT INTO t4 (c1) VALUES(-1);
76 --error 1366
77 INSERT INTO t4 (c1) VALUES('x');
78 INSERT INTO t4 (c1) VALUES('9');
79 SELECT COUNT(c1) AS total_rows FROM t4;
80 SELECT COUNT(c1) AS null_rows FROM t4 WHERE c1 IS NULL;
81 SELECT COUNT(c1) AS not_null_rows FROM t4 WHERE c1 IS NOT NULL;
82 DROP TABLE t4;
83