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