1--source include/have_rocksdb.inc
2
3#
4# ZEROFILL column attribute
5#
6
7--let $extra_col_opts = ZEROFILL
8--let $extra_col_opts_ddl_err = 0
9--let $extra_col_opts_dml_err = 1
10
11--echo ########################
12--echo # Fixed point columns (NUMERIC, DECIMAL)
13--echo ########################
14
15--source suite/rocksdb/include/type_fixed.inc
16
17CREATE TABLE t1 (
18  a DECIMAL ZEROFILL,
19  b NUMERIC ZEROFILL,
20  PRIMARY KEY (a)
21) ENGINE=rocksdb;
22
23SHOW COLUMNS IN t1;
24
25INSERT INTO t1 (a,b) VALUES (1.1,1234);
26SELECT a,b FROM t1;
27DROP TABLE t1;
28
29--echo ########################
30--echo # Floating point columns (FLOAT, DOUBLE)
31--echo ########################
32
33--source suite/rocksdb/include/type_float.inc
34
35CREATE TABLE t1 (
36  a DOUBLE ZEROFILL,
37  b FLOAT ZEROFILL,
38  PRIMARY KEY (b)
39) ENGINE=rocksdb;
40
41SHOW COLUMNS IN t1;
42
43INSERT INTO t1 (a,b) VALUES (1,1234.5);
44SELECT a,b FROM t1;
45DROP TABLE t1;
46
47--echo ########################
48--echo # INT columns
49--echo ########################
50
51--source suite/rocksdb/include/type_int.inc
52
53CREATE TABLE t1 (
54  t TINYINT ZEROFILL,
55  s SMALLINT ZEROFILL,
56  m MEDIUMINT ZEROFILL,
57  i INT ZEROFILL,
58  b BIGINT ZEROFILL,
59  PRIMARY KEY (b)
60) ENGINE=rocksdb;
61
62SHOW COLUMNS IN t1;
63
64INSERT INTO t1 (t,s,m,i,b) VALUES (1,10,100,1000,0);
65SELECT t,s,m,i,b FROM t1;
66DROP TABLE t1;
67
68--let $extra_col_opts =
69--let $extra_col_opts_err =
70