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