Debian Codegraph @

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

raw
1 --disable_warnings
2 let $ENGINE=`select variable_value from performance_schema.global_variables where variable_name='DEFAULT_STORAGE_ENGINE'`;
3 --enable_warnings
4
5 --disable_warnings
6 DROP TABLE IF EXISTS t6;
7 DROP TABLE IF EXISTS t7;
8 --enable_warnings
9 CREATE TABLE t6(c1 DECIMAL(1,0) NULL);
10 SHOW TABLES;
11 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
12 SHOW CREATE TABLE t6; DROP TABLE t6; SHOW TABLES;
13 CREATE TABLE t7(c1 DECIMAL(5,4) NULL);
14 SHOW TABLES;
15 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
16 SHOW CREATE TABLE t7; DROP TABLE t7; SHOW TABLES;
17 CREATE TABLE t6(c1 DEC(1,0) NULL);
18 SHOW TABLES;
19 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
20 SHOW CREATE TABLE t6; DROP TABLE t6; SHOW TABLES;
21 CREATE TABLE t7(c1 DEC(5,4) NULL);
22 SHOW TABLES;
23 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
24 SHOW CREATE TABLE t7; DROP TABLE t7; SHOW TABLES;
25 CREATE TABLE t6(c1 FIXED(1,0) NULL);
26 SHOW TABLES;
27 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
28 SHOW CREATE TABLE t6; DROP TABLE t6; SHOW TABLES;
29 CREATE TABLE t7(c1 FIXED(5,4) NULL);
30 SHOW TABLES;
31 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
32 SHOW CREATE TABLE t7; DROP TABLE t7; SHOW TABLES;
33 CREATE TABLE t6(c1 NUMERIC(1,0) NULL);
34 SHOW TABLES;
35 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
36 SHOW CREATE TABLE t6; DROP TABLE t6; SHOW TABLES;
37 CREATE TABLE t7(c1 NUMERIC(5,4) NULL);
38 SHOW TABLES;
39 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
40 SHOW CREATE TABLE t7; DROP TABLE t7; SHOW TABLES;
41 CREATE TABLE t6(c1 DECIMAL(1,0) NOT NULL);
42 SHOW TABLES;
43 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
44 SHOW CREATE TABLE t6; DROP TABLE t6; SHOW TABLES;
45 CREATE TABLE t7(c1 DECIMAL(5,4) NOT NULL);
46 SHOW TABLES;
47 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
48 SHOW CREATE TABLE t7; DROP TABLE t7; SHOW TABLES;
49 CREATE TABLE t6(c1 DEC(1,0) NOT NULL);
50 SHOW TABLES;
51 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
52 SHOW CREATE TABLE t6; DROP TABLE t6; SHOW TABLES;
53 CREATE TABLE t7(c1 DEC(5,4) NOT NULL);
54 SHOW TABLES;
55 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
56 SHOW CREATE TABLE t7; DROP TABLE t7; SHOW TABLES;
57 CREATE TABLE t6(c1 FIXED(1,0) NOT NULL);
58 SHOW TABLES;
59 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
60 SHOW CREATE TABLE t6; DROP TABLE t6; SHOW TABLES;
61 CREATE TABLE t7(c1 FIXED(5,4) NOT NULL);
62 SHOW TABLES;
63 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
64 SHOW CREATE TABLE t7; DROP TABLE t7; SHOW TABLES;
65 CREATE TABLE t6(c1 NUMERIC(1,0) NOT NULL);
66 SHOW TABLES;
67 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
68 SHOW CREATE TABLE t6; DROP TABLE t6; SHOW TABLES;
69 CREATE TABLE t7(c1 NUMERIC(5,4) NOT NULL);
70 SHOW TABLES;
71 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
72 SHOW CREATE TABLE t7; DROP TABLE t7; SHOW TABLES;