1--source include/have_rocksdb.inc
2
3#
4# NOT NULL column attribute
5#
6
7#########################################
8# TODO:
9# Currently the test produces incorrect (?) result
10# due to bug MySQL:68472. If the bug is ever fixed,
11# the test and result files will need to be updated.
12#########################################
13
14
15--let $extra_col_opts = NOT NULL
16--let $extra_col_opts_ddl_err = 0
17--let $extra_col_opts_dml_err = 0
18
19--echo ########################
20--echo # BINARY columns
21--echo ########################
22
23--source suite/rocksdb/include/type_binary.inc
24--let $col_type = BINARY
25--let $col_default = 0
26--let $col_default_err = 0
27--source suite/rocksdb/include/col_not_null.inc
28
29--echo ########################
30--echo # VARBINARY columns
31--echo ########################
32
33--source suite/rocksdb/include/type_varbinary.inc
34--let $col_type = VARBINARY(64)
35--let $col_default = 'test'
36--let $col_default_err = 0
37--source suite/rocksdb/include/col_not_null.inc
38
39--echo ########################
40--echo # BIT columns
41--echo ########################
42
43--source suite/rocksdb/include/type_bit.inc
44--let $col_type = BIT
45--let $col_default = 1
46--let $col_default_err = 0
47--source suite/rocksdb/include/col_not_null.inc
48
49--echo ########################
50--echo # BLOB columns
51--echo ########################
52
53--source suite/rocksdb/include/type_blob.inc
54--let $col_default = ''
55--let $col_type = BLOB
56--let $col_default_err = 1
57--source suite/rocksdb/include/col_not_null.inc
58
59--let $col_type = TINYBLOB
60--source suite/rocksdb/include/col_not_null.inc
61
62--let $col_type = MEDIUMBLOB
63--source suite/rocksdb/include/col_not_null.inc
64
65--let $col_type = LONGBLOB
66--source suite/rocksdb/include/col_not_null.inc
67
68--echo ########################
69--echo # BOOL columns
70--echo ########################
71
72--source suite/rocksdb/include/type_bool.inc
73--let $col_type = BOOL
74--let $col_default = '0'
75--let $col_default_err = 0
76--source suite/rocksdb/include/col_not_null.inc
77
78--echo ########################
79--echo # CHAR columns
80--echo ########################
81
82--source suite/rocksdb/include/type_char.inc
83--let $col_type = CHAR
84--let $col_default = '_'
85--let $col_default_err = 0
86--source suite/rocksdb/include/col_not_null.inc
87
88--echo ########################
89--echo # VARCHAR columns
90--echo ########################
91
92--source suite/rocksdb/include/type_varchar.inc
93--let $col_type = VARCHAR(64)
94--let $col_default = 'test default'
95--let $col_default_err = 0
96--source suite/rocksdb/include/col_not_null.inc
97
98--echo ########################
99--echo # date and time columns
100--echo ########################
101
102--source suite/rocksdb/include/type_date_time.inc
103
104SET TIMESTAMP=UNIX_TIMESTAMP('2013-12-12 12:12:12');
105
106--let $col_type = DATE
107--let $col_default = '2012-12-21'
108--let $col_default_err = 0
109--source suite/rocksdb/include/col_not_null.inc
110
111--let $col_type = DATETIME
112--let $col_default = '2012-12-21 12:21:12'
113--let $col_default_err = 0
114--source suite/rocksdb/include/col_not_null.inc
115
116# Even with explicit-defaults-for-timestamps, we still can't use
117# the standard include file, due to bug MySQL:68472
118
119--let $col_type = TIMESTAMP
120--let $col_default = '2012-12-21 12:21:12'
121--let $col_default_err = 0
122--source suite/rocksdb/include/col_not_null_timestamp.inc
123
124--let $col_type = TIME
125--let $col_default = '12:21:12'
126--let $col_default_err = 0
127--source suite/rocksdb/include/col_not_null.inc
128
129--let $col_type = YEAR
130--let $col_default = '2012'
131--let $col_default_err = 0
132--source suite/rocksdb/include/col_not_null.inc
133# removed YEAR(2) test for 5.7 as it is not a valid column type anymore and
134# tested elsewhere
135--let $col_type = YEAR(4)
136--let $col_default = '12'
137--let $col_default_err = 0
138--source suite/rocksdb/include/col_not_null.inc
139
140--echo ########################
141--echo # ENUM columns
142--echo ########################
143
144--source suite/rocksdb/include/type_enum.inc
145
146--let $col_type = ENUM('test1','test2','test3')
147--let $col_default = 'test2'
148--let $col_default_err = 0
149--source suite/rocksdb/include/col_not_null.inc
150
151--echo ########################
152--echo # Fixed point columns (NUMERIC, DECIMAL)
153--echo ########################
154
155--source suite/rocksdb/include/type_fixed.inc
156
157--let $col_type = DECIMAL
158--let $col_default = 1.1
159--let $col_default_err = 0
160--source suite/rocksdb/include/col_not_null.inc
161
162--let $col_type = NUMERIC
163--let $col_default = 0
164--let $col_default_err = 0
165--source suite/rocksdb/include/col_not_null.inc
166
167--echo ########################
168--echo # Floating point columns (FLOAT, DOUBLE)
169--echo ########################
170
171--source suite/rocksdb/include/type_float.inc
172
173--let $col_type = FLOAT
174--let $col_default = 1.1
175--let $col_default_err = 0
176--source suite/rocksdb/include/col_not_null.inc
177
178--let $col_type = DOUBLE
179--let $col_default = 0
180--let $col_default_err = 0
181--source suite/rocksdb/include/col_not_null.inc
182
183--echo ########################
184--echo # INT columns
185--echo ########################
186
187--source suite/rocksdb/include/type_int.inc
188
189--let $col_type = INT
190--let $col_default = 2147483647
191--let $col_default_err = 0
192--source suite/rocksdb/include/col_not_null.inc
193
194--let $col_type = TINYINT
195--let $col_default = 127
196--let $col_default_err = 0
197--source suite/rocksdb/include/col_not_null.inc
198
199--let $col_type = SMALLINT
200--let $col_default = 0
201--let $col_default_err = 0
202--source suite/rocksdb/include/col_not_null.inc
203
204--let $col_type = MEDIUMINT
205--let $col_default = 1
206--let $col_default_err = 0
207--source suite/rocksdb/include/col_not_null.inc
208
209--let $col_type = BIGINT
210--let $col_default = 9223372036854775807
211--let $col_default_err = 0
212--source suite/rocksdb/include/col_not_null.inc
213
214--echo ########################
215--echo # SET columns
216--echo ########################
217
218--source suite/rocksdb/include/type_set.inc
219--let $col_type = SET('test1','test2','test3')
220--let $col_default = 'test2,test3'
221--let $col_default_err = 0
222--source suite/rocksdb/include/col_not_null.inc
223
224--echo ########################
225--echo # TEXT columns
226--echo ########################
227
228--source suite/rocksdb/include/type_text.inc
229
230--let $col_default = ''
231--let $col_type = TEXT
232--let $col_default_err = 1
233--source suite/rocksdb/include/col_not_null.inc
234
235--let $col_type = TINYTEXT
236--source suite/rocksdb/include/col_not_null.inc
237
238--let $col_type = MEDIUMTEXT
239--source suite/rocksdb/include/col_not_null.inc
240
241--let $col_type = LONGTEXT
242--source suite/rocksdb/include/col_not_null.inc
243
244
245--let $col_type =
246--let $col_default =
247--let $col_default_err =
248--let $extra_col_opts =
249