null_char.sim 15.5 KB
Newer Older
S
slguan 已提交
1 2
#### TBASE-679
system sh/stop_dnodes.sh
S
slguan 已提交
3 4

system sh/deploy.sh -n dnode1 -i 1
H
hjxilinx 已提交
5
system sh/cfg.sh -n dnode1 -c walLevel -v 0
H
hjxilinx 已提交
6
system sh/cfg.sh -n dnode1 -c tableMetaKeepTimer -v 3
S
slguan 已提交
7 8
system sh/exec.sh -n dnode1 -s start

H
Haojun Liao 已提交
9
sleep 500
S
slguan 已提交
10 11
sql connect

12
print ========== NULL_char.sim
S
slguan 已提交
13 14 15 16 17 18

$db = db
sql drop database if exists $db
sql create database $db
sql use $db

19
#### case 0: field NULL, or 'NULL'
S
slguan 已提交
20
sql create table mt1 (ts timestamp, col1 int, col2 bigint, col3 float, col4 double, col5 binary(8), col6 bool, col7 smallint, col8 tinyint, col9 nchar(8)) tags (tag1 binary(8), tag2 nchar(8), tag3 int, tag4 bigint, tag5 bool, tag6 float)
21
sql create table st1 using mt1 tags (NULL, 'NULL', 100, 1000, 'false', 9.123)
S
slguan 已提交
22 23
sql insert into st1 values ('2019-01-01 09:00:00.000', 123, -123, 3.0, 4.0, 'binary', true, 1000, 121, 'nchar')
sql insert into st1 values ('2019-01-01 09:00:01.000', '456', '456', '3.33', '4.444', 'binary', 'true', '1001', '122', 'nchar')
24 25
sql insert into st1 values ('2019-01-01 09:00:02.000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
sql insert into st1 values ('2019-01-01 09:00:03.000', NULL, NULL, NULL, NULL, 'NULL', 'NULL', 2002, 127, 'NULL')
S
slguan 已提交
26 27 28 29 30

sql select * from mt1
if $rows != 4 then
  return -1
endi
31
if $data21 != NULL then
S
slguan 已提交
32 33
  return -1
endi
34
if $data22 != NULL then
S
slguan 已提交
35 36
  return -1
endi
37
if $data23 != NULL then
S
slguan 已提交
38 39
  return -1
endi
40
if $data24 != NULL then
S
slguan 已提交
41 42
  return -1
endi
43
if $data25 != NULL then
S
slguan 已提交
44 45
  return -1
endi
46
if $data26 != NULL then
S
slguan 已提交
47 48
  return -1
endi
49
if $data27 != NULL then
S
slguan 已提交
50 51
  return -1
endi
52
if $data28 != NULL then
S
slguan 已提交
53 54
  return -1
endi
55
if $data29 != NULL then
S
slguan 已提交
56 57 58
  return -1
endi

59
if $data31 != NULL then
S
slguan 已提交
60 61
  return -1
endi
62
if $data32 != NULL then
S
slguan 已提交
63 64 65 66 67 68 69 70 71 72
  return -1
endi
#if $data33 != 0.00000 then
#  print === expect 0.00000, actually $data33
#  return -1
#endi
#if $data34 != 0.000000000 then
#  print === expect 0.00000, actually $data34
#  return -1
#endi
73
if $data35 != NULL then
S
slguan 已提交
74 75
  return -1
endi
76
if $data36 != NULL then
S
slguan 已提交
77 78
  return -1
endi
79
if $data39 != NULL then
S
slguan 已提交
80 81 82 83
  return -1
endi


84
#### case 1: tag NULL, or 'NULL'
S
slguan 已提交
85
sql create table mt2 (ts timestamp, col1 int, col3 float, col5 binary(8), col6 bool, col9 nchar(8)) tags (tag1 binary(8), tag2 nchar(8), tag3 int, tag5 bool)
86
sql create table st2 using mt2 tags (NULL, 'NULL', 102, 'true')
H
Haojun Liao 已提交
87 88
sql select tag1, tag2, tag3, tag5 from st2
if $rows != 1 then
S
slguan 已提交
89 90
  return -1
endi
H
Haojun Liao 已提交
91 92
if $data00 != NULL then
  print ==1== expect: NULL, actually: $data00
S
slguan 已提交
93 94
  return -1
endi
H
Haojun Liao 已提交
95 96
if $data01 != NULL then
  print ==2== expect: NULL, actually: $data01
S
slguan 已提交
97 98
  return -1
endi
H
Haojun Liao 已提交
99 100
if $data02 != 102 then
  print ==3== expect: NULL, actually: $data02
S
slguan 已提交
101 102
  return -1
endi
H
Haojun Liao 已提交
103 104
if $data03 != 1 then
  print ==4== expect: 1, actually: $data03
S
slguan 已提交
105 106 107
  return -1
endi

108 109 110 111 112 113 114 115 116 117 118 119 120 121 122
sql select tag1 from st2 limit 20 offset 1
if $rows != 0 then
  return -1
endi

sql select tag1 from st2 limit 10 offset 2
if $rows != 0 then
  return -1
endi

sql select tag1 from st2 limit 0 offset 0
if $rows != 0 then
  return -1
endi

S
slguan 已提交
123
sql create table st3 using mt2 tags (NULL, 'ABC', 103, 'FALSE')
H
Haojun Liao 已提交
124 125
sql select tag1, tag2, tag3, tag5 from st3
if $rows != 1 then
S
slguan 已提交
126 127
  return -1
endi
H
Haojun Liao 已提交
128 129
if $data00 != NULL then
  print ==5== expect: NULL, actually: $data00
S
slguan 已提交
130 131
  return -1
endi
H
Haojun Liao 已提交
132
if $data01 != ABC then
S
slguan 已提交
133 134
  return -1
endi
H
Haojun Liao 已提交
135
if $data02 != 103 then
S
slguan 已提交
136 137
  return -1
endi
H
Haojun Liao 已提交
138
if $data03 != 0 then
S
slguan 已提交
139 140 141 142 143 144
  return -1
endi

### bool:
sql_error create table stx using mt2 tags ('NULL', '123aBc', 104, '123')
sql_error create table sty using mt2 tags ('NULL', '123aBc', 104, 'xtz')
145
sql create table st4 using mt2 tags ('NULL', '123aBc', 104, 'NULL')
H
Haojun Liao 已提交
146 147
sql select tag1,tag2,tag3,tag5 from st4
if $rows != 1 then
S
slguan 已提交
148 149
  return -1
endi
H
Haojun Liao 已提交
150
if $data00 != NULL then
S
slguan 已提交
151 152
  return -1
endi
H
Haojun Liao 已提交
153
if $data01 != 123aBc then
S
slguan 已提交
154 155
  return -1
endi
H
Haojun Liao 已提交
156
if $data02 != 104 then
S
slguan 已提交
157 158
  return -1
endi
H
Haojun Liao 已提交
159 160
if $data03 != NULL then
  print ==6== expect: NULL, actually: $data03
S
slguan 已提交
161 162 163 164
  return -1
endi

sql create table st5 using mt2 tags ('NULL', '123aBc', 105, NULL)
H
Haojun Liao 已提交
165 166
sql select tag1,tag2,tag3,tag5 from st5
if $rows != 1 then
S
slguan 已提交
167 168
  return -1
endi
H
Haojun Liao 已提交
169
if $data00 != NULL then
S
slguan 已提交
170 171
  return -1
endi
H
Haojun Liao 已提交
172
if $data01 != 123aBc then
S
slguan 已提交
173 174
  return -1
endi
H
Haojun Liao 已提交
175
if $data02 != 105 then
S
slguan 已提交
176 177
  return -1
endi
H
Haojun Liao 已提交
178
if $data03 != NULL then
S
slguan 已提交
179 180 181 182 183 184 185
  return -1
endi



#### case 2: dynamic create table using super table when insert into
sql create table mt3 (ts timestamp, col1 int, col3 float, col5 binary(8), col6 bool, col9 nchar(8)) tags (tag1 binary(8), tag2 nchar(8), tag3 int, tag5 bool)
186
sql_error insert into st31 using mt3 tags (NULL, 'NULL', 102, 'true')     values (now+1s, 31, 31, 'bin_31', '123', 'nchar_31')
S
slguan 已提交
187
sql_error insert into st32 using mt3 tags (NULL, 'ABC', 103, 'FALSE')     values (now+2s, 32, 32.12345, 'bin_32', 'abc', 'nchar_32')
188
sql_error insert into st33 using mt3 tags ('NULL', '123aBc', 104, 'NULL') values (now+3s, 33, 33, 'bin_33', 'false123', 'nchar_33')
S
slguan 已提交
189 190 191 192 193 194
sql_error insert into st34 using mt3 tags ('NULL', '123aBc', 105, NULL)   values (now+4s, 34, 34.12345, 'bin_34', 'true123', 'nchar_34')


#### case 3: set tag value
sql create table mt4 (ts timestamp, c1 int) tags (tag_binary binary(16), tag_nchar nchar(16), tag_int int, tag_bool bool, tag_float float, tag_double double)
sql create table st41 using mt4 tags ("beijing", 'nchar_tag', 100, false, 9.12345, 7.123456789)
H
Haojun Liao 已提交
195
sql select tag_binary, tag_nchar, tag_int, tag_bool, tag_float, tag_double from st41
H
Haojun Liao 已提交
196
if $rows != 1 then
S
slguan 已提交
197 198
  return -1
endi
H
Haojun Liao 已提交
199
if $data00 != beijing then
S
slguan 已提交
200 201
  return -1
endi
H
Haojun Liao 已提交
202
if $data01 != nchar_tag then
S
slguan 已提交
203 204
  return -1
endi
H
Haojun Liao 已提交
205
if $data02 != 100 then
S
slguan 已提交
206 207
  return -1
endi
H
Haojun Liao 已提交
208
if $data03 != 0 then
S
slguan 已提交
209 210
  return -1
endi
H
Haojun Liao 已提交
211 212 213

if $data04 != 9.12345 then
  print expect 9.12345 , actual: $data04
S
slguan 已提交
214 215
  return -1
endi
H
Haojun Liao 已提交
216 217 218

if $data05 != 7.123456789 then
  print expect 7.123456789 , actual: $data05
S
slguan 已提交
219 220
  return -1
endi
H
Haojun Liao 已提交
221

S
slguan 已提交
222 223
################# binary
sql alter table st41 set tag tag_binary = "shanghai"
H
Haojun Liao 已提交
224 225
sql select tag_binary, tag_nchar, tag_int, tag_bool, tag_float, tag_double from  st41
if $data00 != shanghai then
S
slguan 已提交
226 227
  return -1
endi
H
Haojun Liao 已提交
228

S
slguan 已提交
229
##### test 'space' case
230
system_content echo '   ' | sed 's/ //g' | tr -d '\n' # Construct an empty result for later result checking
S
slguan 已提交
231
sql alter table st41 set tag tag_binary = ""
H
Haojun Liao 已提交
232
sql select tag_binary, tag_nchar, tag_int, tag_bool, tag_float, tag_double from  st41
233 234
if $data00 != $system_content  then
  print expect [ $system_content ], actual [ $data00 ]
H
Haojun Liao 已提交
235 236 237
  return -1
endi

238
sql alter table st41 set tag tag_binary = "NULL"
H
Haojun Liao 已提交
239 240
sql select tag_binary, tag_nchar, tag_int, tag_bool, tag_float, tag_double from  st41
if $data00 != NULL then
S
slguan 已提交
241 242
  return -1
endi
H
Haojun Liao 已提交
243

S
slguan 已提交
244
sql alter table st41 set tag tag_binary = NULL
H
Haojun Liao 已提交
245 246
sql select tag_binary, tag_nchar, tag_int, tag_bool, tag_float, tag_double from  st41
if $data00 != NULL then
S
slguan 已提交
247 248 249 250 251 252
  print ==8== expect: NULL, actually: $data23
  return -1
endi

################### nchar
sql alter table st41 set tag tag_nchar = "��˼����"
H
Haojun Liao 已提交
253
sql select tag_binary, tag_nchar, tag_int, tag_bool, tag_float, tag_double from  st41
H
Haojun Liao 已提交
254
#sleep 500
H
Haojun Liao 已提交
255 256
#if $data01 != ��˼���� then
#  print ==== expect ��˼����, actually $data01
S
slguan 已提交
257 258 259 260 261 262
#  return -1
#endi
##### test 'space' case
#$tagvalue = '
#$tagvalue = $tagvalue '
sql alter table st41 set tag tag_nchar = ''
H
Haojun Liao 已提交
263 264
#sql select tag_binary, tag_nchar, tag_int, tag_bool, tag_float, tag_double from  st41
#if $data01 != $tagvalue then
S
slguan 已提交
265 266
#  return -1
#endi
267
sql alter table st41 set tag tag_nchar = "NULL"
H
Haojun Liao 已提交
268 269
sql select tag_binary, tag_nchar, tag_int, tag_bool, tag_float, tag_double from  st41
if $data01 != NULL then
S
slguan 已提交
270 271 272
  return -1
endi
sql alter table st41 set tag tag_nchar = NULL
H
Haojun Liao 已提交
273 274 275
#sql select tag_binary, tag_nchar, tag_int, tag_bool, tag_float, tag_double from  st41
#if $data01 !=   then
#  print ==9== expect  , actually $data01
S
slguan 已提交
276 277 278 279 280
#   return -1
#endi

################### int
sql alter table st41 set tag tag_int = -2147483647
H
Haojun Liao 已提交
281 282
sql select tag_binary, tag_nchar, tag_int, tag_bool, tag_float, tag_double from  st41
if $data02 != -2147483647 then
S
slguan 已提交
283 284 285
  return -1
endi
sql alter table st41 set tag tag_int = 2147483647
H
Haojun Liao 已提交
286 287
sql select tag_binary, tag_nchar, tag_int, tag_bool, tag_float, tag_double from  st41
if $data02 != 2147483647 then
S
slguan 已提交
288 289 290 291 292 293 294
  return -1
endi

sql_error alter table st41 set tag tag_int = -2147483648
sql_error alter table st41 set tag tag_int = 2147483648

sql alter table st41 set tag tag_int = '-379'
H
Haojun Liao 已提交
295 296
sql select tag_binary, tag_nchar, tag_int, tag_bool, tag_float, tag_double from  st41
if $data02 != -379 then
S
slguan 已提交
297 298 299
  return -1
endi
sql alter table st41 set tag tag_int = -2000
H
Haojun Liao 已提交
300 301
sql select tag_binary, tag_nchar, tag_int, tag_bool, tag_float, tag_double from  st41
if $data02 != -2000 then
S
slguan 已提交
302 303
  return -1
endi
304
sql alter table st41 set tag tag_int = NULL
H
Haojun Liao 已提交
305 306 307
sql select tag_binary, tag_nchar, tag_int, tag_bool, tag_float, tag_double from  st41
if $data02 != NULL then
  print ==10== expect: NULL, actually: $data02
S
slguan 已提交
308 309
  return -1
endi
310
sql alter table st41 set tag tag_int = 'NULL'
S
slguan 已提交
311 312 313 314 315
sql_error alter table st41 set tag tag_int = ''
sql_error alter table st41 set tag tag_int = abc379

################### bool
sql alter table st41 set tag tag_bool = 'true'
H
Haojun Liao 已提交
316 317
sql select tag_binary, tag_nchar, tag_int, tag_bool, tag_float, tag_double from  st41
if $data03 != 1 then
S
slguan 已提交
318 319 320
  return -1
endi
sql alter table st41 set tag tag_bool = 'false'
H
Haojun Liao 已提交
321 322
sql select tag_binary, tag_nchar, tag_int, tag_bool, tag_float, tag_double from  st41
if $data03 != 0 then
S
slguan 已提交
323 324 325
  return -1
endi
sql alter table st41 set tag tag_bool = 0
H
Haojun Liao 已提交
326 327
sql select tag_binary, tag_nchar, tag_int, tag_bool, tag_float, tag_double from  st41
if $data03 != 0 then
S
slguan 已提交
328 329 330
  return -1
endi
sql alter table st41 set tag tag_bool = 123
H
Haojun Liao 已提交
331 332
sql select tag_binary, tag_nchar, tag_int, tag_bool, tag_float, tag_double from  st41
if $data03 != 1 then
S
slguan 已提交
333 334
  return -1
endi
335
sql alter table st41 set tag tag_bool = 'NULL'
H
Haojun Liao 已提交
336 337 338
sql select tag_binary, tag_nchar, tag_int, tag_bool, tag_float, tag_double from  st41
if $data03 != NULL then
  print ==14== expect: NULL, actually: $data03
S
slguan 已提交
339 340
  return -1
endi
341
sql alter table st41 set tag tag_bool = NULL
H
Haojun Liao 已提交
342 343
sql select tag_binary, tag_nchar, tag_int, tag_bool, tag_float, tag_double from  st41
if $data03 != NULL then
S
slguan 已提交
344 345 346 347 348 349 350 351 352
  return -1
endi

sql_error alter table st41 set tag tag_bool = '123'
sql_error alter table st41 set tag tag_bool = ''
sql_error alter table st41 set tag tag_bool = abc379

################### float
sql alter table st41 set tag tag_float = -32
H
Haojun Liao 已提交
353 354 355
sql select tag_binary, tag_nchar, tag_int, tag_bool, tag_float, tag_double from  st41
if $data04 != -32.00000 then
  print expect -32.00000 actual $data04
S
slguan 已提交
356 357 358
  return -1
endi
sql alter table st41 set tag tag_float = 54.123456
H
Haojun Liao 已提交
359 360 361
sql select tag_binary, tag_nchar, tag_int, tag_bool, tag_float, tag_double from  st41
if $data04 != 54.123455 then
  print ==15== expect: 54.123455, actually: $data04
S
slguan 已提交
362 363 364
#  return -1
endi
sql alter table st41 set tag tag_float = 54.12345
H
Haojun Liao 已提交
365 366 367
sql select tag_binary, tag_nchar, tag_int, tag_bool, tag_float, tag_double from  st41
if $data04 != 54.12345 then
  print ==16== expect: 54.12345, actually: $data04
S
slguan 已提交
368 369 370
  return -1
endi
sql alter table st41 set tag tag_float = 54.12345678
H
Haojun Liao 已提交
371 372 373
sql select tag_binary, tag_nchar, tag_int, tag_bool, tag_float, tag_double from  st41
if $data04 != 54.12346 then
  print ==11== expect: 54.12346, actually : $data04
S
slguan 已提交
374 375
  return -1
endi
376
sql alter table st41 set tag tag_float = NULL
H
Haojun Liao 已提交
377 378 379
sql select tag_binary, tag_nchar, tag_int, tag_bool, tag_float, tag_double from  st41
if $data04 != NULL then
  print ==12== expect: NULL, actually : $data04
S
slguan 已提交
380 381
  return -1
endi
382
sql alter table st41 set tag tag_float = 'NULL'
H
Haojun Liao 已提交
383 384 385
sql select tag_binary, tag_nchar, tag_int, tag_bool, tag_float, tag_double from  st41
if $data04 != NULL then
  print ==17== expect: NULL, actually : $data04
S
slguan 已提交
386 387 388
  return -1
endi
sql alter table st41 set tag tag_float = '54.123456'
H
Haojun Liao 已提交
389 390 391
sql select tag_binary, tag_nchar, tag_int, tag_bool, tag_float, tag_double from  st41
if $data04 != 54.12346 then
  print ==18== expect: 54.12346, actually : $data04
S
slguan 已提交
392 393 394
  return -1
endi
sql alter table st41 set tag tag_float = '-54.123456'
H
Haojun Liao 已提交
395 396 397
sql select tag_binary, tag_nchar, tag_int, tag_bool, tag_float, tag_double from  st41
if $data04 != -54.12346 then
  print ==19== expect: -54.12346, actually : $data04
S
slguan 已提交
398 399 400 401 402 403 404 405 406 407
  return -1
endi
sql_error alter table st41 set tag tag_float = ''

sql_error alter table st41 set tag tag_float = 'abc'
sql_error alter table st41 set tag tag_float = '123abc'
sql_error alter table st41 set tag tag_float = abc

################### double
sql alter table st41 set tag tag_double = -92
H
Haojun Liao 已提交
408 409 410
sql select tag_binary, tag_nchar, tag_int, tag_bool, tag_float, tag_double from  st41
if $data05 != -92.000000000 then
  print expect -92.000000000 actual $data05
S
slguan 已提交
411 412 413
  return -1
endi
sql alter table st41 set tag tag_double = 184
H
Haojun Liao 已提交
414 415 416
sql select tag_binary, tag_nchar, tag_int, tag_bool, tag_float, tag_double from  st41
if $data05 != 184.000000000 then
  print expect 184.000000000 actual $data05
S
slguan 已提交
417 418 419
  return -1
endi
sql alter table st41 set tag tag_double = '-2456'
H
Haojun Liao 已提交
420 421
sql select tag_binary, tag_nchar, tag_int, tag_bool, tag_float, tag_double from  st41
if $data05 != -2456.000000000 then
S
slguan 已提交
422 423
  return -1
endi
424
sql alter table st41 set tag tag_double = NULL
H
Haojun Liao 已提交
425 426 427
sql select tag_binary, tag_nchar, tag_int, tag_bool, tag_float, tag_double from  st41
if $data05 != NULL then
  print ==13== expect: NULL, actually : $data05
S
slguan 已提交
428 429
  return -1
endi
430
sql alter table st41 set tag tag_double = 'NULL'
H
Haojun Liao 已提交
431 432 433
sql select tag_binary, tag_nchar, tag_int, tag_bool, tag_float, tag_double from  st41
if $data05 != NULL then
  print ==20== expect: NULL, actually : $data05
S
slguan 已提交
434 435 436 437 438 439 440 441 442 443 444 445 446 447
  return -1
endi
sql_error alter table st41 set tag tag_double = ''


sql_error alter table st41 set tag tag_double = 'abc'
sql_error alter table st41 set tag tag_double = '123abc' 
sql_error alter table st41 set tag tag_double = abc

################### bigint smallint tinyint
sql create table mt5 (ts timestamp, c1 int) tags (tag_bigint bigint, tag_smallint smallint, tag_tinyint tinyint)
sql create table st51 using mt5 tags (1, 2, 3)
sql alter table st51 set tag tag_bigint = '-379'
sql alter table st51 set tag tag_bigint = -2000
448
sql alter table st51 set tag tag_bigint = NULL
S
slguan 已提交
449
sql alter table st51 set tag tag_bigint = 9223372036854775807
H
Haojun Liao 已提交
450 451
sql select tag_bigint, tag_smallint, tag_tinyint from st51
if $data00 != 9223372036854775807 then
S
slguan 已提交
452 453 454
  return -1
endi
sql alter table st51 set tag tag_bigint = 9223372036854775808
H
Haojun Liao 已提交
455 456
sql select tag_bigint, tag_smallint, tag_tinyint from st51
if $data00 != 9223372036854775807 then
S
slguan 已提交
457 458 459
  return -1
endi
sql alter table st51 set tag tag_bigint = -9223372036854775807
H
Haojun Liao 已提交
460 461
sql select tag_bigint, tag_smallint, tag_tinyint from st51
if $data00 != -9223372036854775807 then
S
slguan 已提交
462 463 464 465
  return -1
endi
sql_error alter table st51 set tag tag_bigint = -9223372036854775808

466
sql alter table st51 set tag tag_bigint = 'NULL'
S
slguan 已提交
467 468 469 470 471
sql_error alter table st51 set tag tag_bigint = ''
sql_error alter table st51 set tag tag_bigint = abc379

####
sql alter table st51 set tag tag_smallint = -2000
472
sql alter table st51 set tag tag_smallint = NULL
S
slguan 已提交
473
sql alter table st51 set tag tag_smallint = 32767
H
Haojun Liao 已提交
474 475
sql select tag_bigint, tag_smallint, tag_tinyint from st51
if $data01 != 32767 then
S
slguan 已提交
476 477 478 479 480
  return -1
endi
sql_error alter table st51 set tag tag_smallint = 32768

sql alter table st51 set tag tag_smallint = -32767
H
Haojun Liao 已提交
481 482
sql select tag_bigint, tag_smallint, tag_tinyint from st51
if $data01 != -32767 then
S
slguan 已提交
483 484 485 486
  return -1
endi
sql_error alter table st51 set tag tag_smallint = -32768

487
sql alter table st51 set tag tag_smallint = 'NULL'
S
slguan 已提交
488 489 490 491 492
sql_error alter table st51 set tag tag_smallint = ''
sql_error alter table st51 set tag tag_smallint = abc379

####
sql alter table st51 set tag tag_tinyint = -127
493
sql alter table st51 set tag tag_tinyint = NULL
S
slguan 已提交
494
sql alter table st51 set tag tag_tinyint = 127
H
Haojun Liao 已提交
495 496
sql select tag_bigint, tag_smallint, tag_tinyint from st51
if $data02 != 127 then
S
slguan 已提交
497 498 499
  return -1
endi
sql alter table st51 set tag tag_tinyint = -127
H
Haojun Liao 已提交
500 501
sql select tag_bigint, tag_smallint, tag_tinyint from st51
if $data02 != -127 then
S
slguan 已提交
502 503 504 505
  return -1
endi
sql_error alter table st51 set tag tag_tinyint = '-128'
sql_error alter table st51 set tag tag_tinyint = 128
506
sql alter table st51 set tag tag_tinyint = 'NULL'
S
slguan 已提交
507 508 509 510 511 512 513 514
sql_error alter table st51 set tag tag_tinyint = ''
sql_error alter table st51 set tag tag_tinyint = abc379


# test end   
#sql drop database $db


515
system sh/exec.sh -n dnode1 -s stop -x SIGINT