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