Debian Codegraph @

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

raw
1 --disable_warnings
2 DROP TABLE IF EXISTS t12;
3 DROP TABLE IF EXISTS t13;
4 --enable_warnings
5 CREATE TABLE t12(c1 DECIMAL(5,0) NULL DEFAULT 2);
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 t12; DROP TABLE t12; SHOW TABLES;
10 CREATE TABLE t13(c1 DECIMAL(5,4) NULL DEFAULT 3.1234);
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 t13; DROP TABLE t13; SHOW TABLES;
15 CREATE TABLE t12(c1 DEC(5,0) NULL DEFAULT 2);
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 t12; DROP TABLE t12; SHOW TABLES;
20 CREATE TABLE t13(c1 DEC(5,4) NULL DEFAULT 3.1234);
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 t13; DROP TABLE t13; SHOW TABLES;
25 CREATE TABLE t12(c1 FIXED(5,0) NULL DEFAULT 2);
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 t12; DROP TABLE t12; SHOW TABLES;
30 CREATE TABLE t13(c1 FIXED(5,4) NULL DEFAULT 3.1234);
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 t13; DROP TABLE t13; SHOW TABLES;
35 CREATE TABLE t12(c1 NUMERIC(5,0) NULL DEFAULT 2);
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 t12; DROP TABLE t12; SHOW TABLES;
40 CREATE TABLE t13(c1 NUMERIC(5,4) NULL DEFAULT 3.1234);
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 t13; DROP TABLE t13; SHOW TABLES;
45 CREATE TABLE t12(c1 DECIMAL(5,0) NOT NULL DEFAULT 2);
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 t12; DROP TABLE t12; SHOW TABLES;
50 CREATE TABLE t13(c1 DECIMAL(5,4) NOT NULL DEFAULT 3.1234);
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 t13; DROP TABLE t13; SHOW TABLES;
55 CREATE TABLE t12(c1 DEC(5,0) NOT NULL DEFAULT 2);
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 t12; DROP TABLE t12; SHOW TABLES;
60 CREATE TABLE t13(c1 DEC(5,4) NOT NULL DEFAULT 3.1234);
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 t13; DROP TABLE t13; SHOW TABLES;
65 CREATE TABLE t12(c1 FIXED(5,0) NOT NULL DEFAULT 2);
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 t12; DROP TABLE t12; SHOW TABLES;
70 CREATE TABLE t13(c1 FIXED(5,4) NOT NULL DEFAULT 3.1234);
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 t13; DROP TABLE t13; SHOW TABLES;
75 CREATE TABLE t12(c1 NUMERIC(5,0) NOT NULL DEFAULT 2);
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 t12; DROP TABLE t12; SHOW TABLES;
80 CREATE TABLE t13(c1 NUMERIC(5,4) NOT NULL DEFAULT 3.1234);
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 t13; DROP TABLE t13; SHOW TABLES;
85