Debian Codegraph @

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

raw
1 --disable_warnings
2 DROP TABLE IF EXISTS t1;
3 --enable_warnings
4 CREATE TABLE t1(c1 TINYINT NULL, c2 TINYINT NULL);
5 INSERT INTO t1 VALUES(1,2);
6 INSERT INTO t1 VALUES(3,4);
7 ANALYZE TABLE t1;
8 DROP TABLE t1;
9 CREATE TABLE t1(c1 SMALLINT NULL, c2 SMALLINT NULL);
10 INSERT INTO t1 VALUES(1,2);
11 INSERT INTO t1 VALUES(3,4);
12 ANALYZE TABLE t1;
13 DROP TABLE t1;
14 CREATE TABLE t1(c1 MEDIUMINT NULL, c2 MEDIUMINT NULL);
15 INSERT INTO t1 VALUES(1,2);
16 INSERT INTO t1 VALUES(3,4);
17 ANALYZE TABLE t1;
18 DROP TABLE t1;
19 CREATE TABLE t1(c1 INT NULL, c2 INT NULL);
20 INSERT INTO t1 VALUES(1,2);
21 INSERT INTO t1 VALUES(3,4);
22 ANALYZE TABLE t1;
23 DROP TABLE t1;
24 CREATE TABLE t1(c1 INTEGER NULL, c2 INTEGER NULL);
25 INSERT INTO t1 VALUES(1,2);
26 INSERT INTO t1 VALUES(3,4);
27 ANALYZE TABLE t1;
28 DROP TABLE t1;
29 CREATE TABLE t1(c1 BIGINT NULL, c2 BIGINT NULL);
30 INSERT INTO t1 VALUES(1,2);
31 INSERT INTO t1 VALUES(3,4);
32 ANALYZE TABLE t1;
33 DROP TABLE t1;
34 CREATE TABLE t1(c1 DECIMAL NULL, c2 DECIMAL NULL);
35 INSERT INTO t1 VALUES(1,2);
36 INSERT INTO t1 VALUES(3,4);
37 ANALYZE TABLE t1;
38 DROP TABLE t1;
39 CREATE TABLE t1(c1 DEC NULL, c2 DEC NULL);
40 INSERT INTO t1 VALUES(1,2);
41 INSERT INTO t1 VALUES(3,4);
42 ANALYZE TABLE t1;
43 DROP TABLE t1;
44 CREATE TABLE t1(c1 FIXED NULL, c2 FIXED NULL);
45 INSERT INTO t1 VALUES(1,2);
46 INSERT INTO t1 VALUES(3,4);
47 ANALYZE TABLE t1;
48 DROP TABLE t1;
49 CREATE TABLE t1(c1 NUMERIC NULL, c2 NUMERIC NULL);
50 INSERT INTO t1 VALUES(1,2);
51 INSERT INTO t1 VALUES(3,4);
52 ANALYZE TABLE t1;
53 DROP TABLE t1;
54 CREATE TABLE t1(c1 DOUBLE NULL, c2 DOUBLE NULL);
55 INSERT INTO t1 VALUES(1,2);
56 INSERT INTO t1 VALUES(3,4);
57 ANALYZE TABLE t1;
58 DROP TABLE t1;
59 CREATE TABLE t1(c1 REAL NULL, c2 REAL NULL);
60 INSERT INTO t1 VALUES(1,2);
61 INSERT INTO t1 VALUES(3,4);
62 ANALYZE TABLE t1;
63 DROP TABLE t1;
64 CREATE TABLE t1(c1 DOUBLE PRECISION NULL, c2 DOUBLE PRECISION NULL);
65 INSERT INTO t1 VALUES(1,2);
66 INSERT INTO t1 VALUES(3,4);
67 ANALYZE TABLE t1;
68 DROP TABLE t1;
69 CREATE TABLE t1(c1 FLOAT NULL, c2 FLOAT NULL);
70 INSERT INTO t1 VALUES(1,2);
71 INSERT INTO t1 VALUES(3,4);
72 ANALYZE TABLE t1;
73 DROP TABLE t1;
74