Debian Codegraph @

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

raw
1 SET SQL_MODE="TRADITIONAL,ANSI";
2 --disable_warnings
3 DROP TABLE IF EXISTS t5;
4 --enable_warnings
5 CREATE TABLE t5(c1 DECIMAL(5,4) UNSIGNED NOT NULL);
6 --error 1048
7 INSERT INTO t5 (c1) VALUES(NULL);
8 INSERT INTO t5 (c1) VALUES(0);
9 --error 1264
10 INSERT INTO t5 (c1) VALUES(-1);
11 --error 1366
12 INSERT INTO t5 (c1) VALUES('x');
13 --error 1264
14 INSERT INTO t5 (c1) VALUES(999999);
15 SELECT COUNT(c1) AS total_rows FROM t5;
16 SELECT COUNT(c1) AS null_rows FROM t5 WHERE c1 IS NULL;
17 SELECT COUNT(c1) AS not_null_rows FROM t5 WHERE c1 IS NOT NULL;
18 DROP TABLE t5;
19 CREATE TABLE t5(c1 DEC(5,4) UNSIGNED NOT NULL);
20 --error 1048
21 INSERT INTO t5 (c1) VALUES(NULL);
22 INSERT INTO t5 (c1) VALUES(0);
23 --error 1264
24 INSERT INTO t5 (c1) VALUES(-1);
25 --error 1366
26 INSERT INTO t5 (c1) VALUES('x');
27 --error 1264
28 INSERT INTO t5 (c1) VALUES(999999);
29 SELECT COUNT(c1) AS total_rows FROM t5;
30 SELECT COUNT(c1) AS null_rows FROM t5 WHERE c1 IS NULL;
31 SELECT COUNT(c1) AS not_null_rows FROM t5 WHERE c1 IS NOT NULL;
32 DROP TABLE t5;
33 CREATE TABLE t5(c1 FIXED(5,4) UNSIGNED NOT NULL);
34 --error 1048
35 INSERT INTO t5 (c1) VALUES(NULL);
36 INSERT INTO t5 (c1) VALUES(0);
37 --error 1264
38 INSERT INTO t5 (c1) VALUES(-1);
39 --error 1366
40 INSERT INTO t5 (c1) VALUES('x');
41 --error 1264
42 INSERT INTO t5 (c1) VALUES(999999);
43 SELECT COUNT(c1) AS total_rows FROM t5;
44 SELECT COUNT(c1) AS null_rows FROM t5 WHERE c1 IS NULL;
45 SELECT COUNT(c1) AS not_null_rows FROM t5 WHERE c1 IS NOT NULL;
46 DROP TABLE t5;
47 CREATE TABLE t5(c1 NUMERIC(5,4) UNSIGNED NOT NULL);
48 --error 1048
49 INSERT INTO t5 (c1) VALUES(NULL);
50 INSERT INTO t5 (c1) VALUES(0);
51 --error 1264
52 INSERT INTO t5 (c1) VALUES(-1);
53 --error 1366
54 INSERT INTO t5 (c1) VALUES('x');
55 --error 1264
56 INSERT INTO t5 (c1) VALUES(999999);
57 SELECT COUNT(c1) AS total_rows FROM t5;
58 SELECT COUNT(c1) AS null_rows FROM t5 WHERE c1 IS NULL;
59 SELECT COUNT(c1) AS not_null_rows FROM t5 WHERE c1 IS NOT NULL;
60 DROP TABLE t5;
61