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