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