Debian Codegraph @

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

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