Debian Codegraph @

mysql-test/suite/storage_engine/col_opt_zerofill.test

raw
1 #
2 # ZEROFILL column attribute
3 #
4
5 let $extra_type_opts = ZEROFILL;
6
7 --source have_engine.inc
8
9 --echo #
10 --echo # Fixed point columns (NUMERIC, DECIMAL)
11 --echo #
12
13 --source type_fixed.inc
14 let $create_definition =
15 a DECIMAL $col_opts,
16 b NUMERIC $col_opts
17 ;
18 --source create_table.inc
19 if ($mysql_errname)
20 {
21 --let $functionality = Fixed point types or ZEROFILL columns
22 --source unexpected_result.inc
23 }
24 if (!$mysql_errname)
25 {
26 --replace_column 3 # 4 # 5 # 6 #
27 SHOW COLUMNS IN t1;
28
29 INSERT INTO t1 (a,b) VALUES (1.1,1234);
30 SELECT a,b FROM t1;
31 DROP TABLE t1;
32 }
33
34 --echo #
35 --echo # Floating point columns (FLOAT, DOUBLE)
36 --echo #
37
38 --source type_float.inc
39 let $create_definition =
40 a DOUBLE $col_opts,
41 b FLOAT $col_opts
42 ;
43 --source create_table.inc
44 if ($mysql_errname)
45 {
46 --let $functionality = Floating point types or ZEROFILL columns
47 --source unexpected_result.inc
48 }
49 if (!$mysql_errname)
50 {
51 --replace_column 3 # 4 # 5 # 6 #
52 SHOW COLUMNS IN t1;
53
54 INSERT INTO t1 (a,b) VALUES (1,1234.5);
55 SELECT a,b FROM t1;
56 DROP TABLE t1;
57 }
58
59 --echo #
60 --echo # INT columns
61 --echo #
62
63 --source type_int.inc
64 let $create_definition =
65 t TINYINT $col_opts,
66 s SMALLINT $col_opts,
67 m MEDIUMINT $col_opts,
68 i INT $col_opts,
69 b BIGINT $col_opts
70 ;
71 --source create_table.inc
72 if ($mysql_errname)
73 {
74 --let $functionality = INT types or UNSIGNED columns
75 --source unexpected_result.inc
76 }
77 if (!$mysql_errname)
78 {
79 --replace_column 3 # 4 # 5 # 6 #
80 SHOW COLUMNS IN t1;
81
82 INSERT INTO t1 (t,s,m,i,b) VALUES (1,10,100,1000,0);
83 SELECT t,s,m,i,b FROM t1;
84 DROP TABLE t1;
85 }
86
87 --source cleanup_engine.inc
88