columnValue_float.sim 17.9 KB
Newer Older
S
slguan 已提交
1
####
H
Haojun Liao 已提交
2
sleep 500
S
slguan 已提交
3 4 5 6 7 8 9 10 11 12 13
sql connect
sql create database if not exists db
sql use db

#### test the value of all data types in four cases: static create table, insert column value, synamic create table, alter tag value

######## case 0: float
print ========== float 
sql create table mt_float (ts timestamp, c float) tags (tagname float)

## case 00: static create table for test tag values
H
hjxilinx 已提交
14 15 16
sql create table st_float_0  using mt_float tags (NULL)
sql select tagname from  st_float_0
if $data00 != NULL then
S
slguan 已提交
17 18 19
  return -1
endi
sql create table st_float_1  using mt_float tags (NULL)
H
hjxilinx 已提交
20 21
sql select tagname from  st_float_1
if $data00 != NULL then
S
slguan 已提交
22 23
  return -1
endi
H
hjxilinx 已提交
24 25 26
sql create table st_float_2  using mt_float tags ('NULL')
sql select tagname from  st_float_2
if $data00 != NULL then
S
slguan 已提交
27 28 29
  return -1
endi
sql create table st_float_3  using mt_float tags ('NULL')
H
hjxilinx 已提交
30 31
sql select tagname from  st_float_3
if $data00 != NULL then
S
slguan 已提交
32 33
  return -1
endi
H
hjxilinx 已提交
34 35 36
sql create table st_float_4  using mt_float tags ("NULL")
sql select tagname from  st_float_4
if $data00 != NULL then
S
slguan 已提交
37 38 39
  return -1
endi
sql create table st_float_5  using mt_float tags ("NULL")
H
hjxilinx 已提交
40 41
sql select tagname from  st_float_5
if $data00 != NULL then
S
slguan 已提交
42 43 44
  return -1
endi
sql create table st_float_6  using mt_float tags (-123.321)
H
hjxilinx 已提交
45 46 47
sql select tagname from  st_float_6
if $data00 != -123.32100 then
  print expect -123.32100, actual: $data00
S
slguan 已提交
48 49 50
  return -1
endi
sql create table st_float_7  using mt_float tags (+1.567)
H
hjxilinx 已提交
51 52 53
sql select tagname from  st_float_7
if $data00 != 1.56700 then
  print expect 1.56700, actual: $data00
S
slguan 已提交
54 55 56
  return -1
endi
sql create table st_float_8  using mt_float tags (379.001)
H
hjxilinx 已提交
57 58 59
sql select tagname from  st_float_8
if $data00 != 379.00101 then
  print expect 379.00101, actual: $data00
S
slguan 已提交
60 61 62
  return -1
endi
sql create table st_float_9  using mt_float tags (1.5e+3)
H
hjxilinx 已提交
63 64 65
sql select tagname from  st_float_9
if $data00 != 1500.00000 then
  print expect 1500.00000, actual: $data00
S
slguan 已提交
66 67 68
  return -1
endi
sql create table st_float_10 using mt_float tags (-1.5e-3)
H
hjxilinx 已提交
69 70 71
sql select tagname from  st_float_10
if $data00 != -0.00150 then
  print expect -0.00150, actual: $data00
S
slguan 已提交
72 73 74
  return -1
endi
sql create table st_float_11 using mt_float tags (+1.5e+3)
H
hjxilinx 已提交
75 76 77
sql select tagname from  st_float_11
if $data00 != 1500.00000 then
  print expect 1500.00000, actual: $data00
S
slguan 已提交
78 79 80
  return -1
endi
sql create table st_float_12 using mt_float tags (-1.5e+3)
H
hjxilinx 已提交
81 82 83
sql select tagname from  st_float_12
if $data00 != -1500.00000 then
  print expect -1500.00000, actual: $data00
S
slguan 已提交
84 85 86
  return -1
endi
sql create table st_float_13 using mt_float tags (1.5e-3)
H
hjxilinx 已提交
87 88 89
sql select tagname from  st_float_13
if $data00 != 0.00150 then
  print expect 0.00150, actual: $data00
S
slguan 已提交
90 91 92
  return -1
endi
sql create table st_float_14 using mt_float tags (1.5E-3)
H
hjxilinx 已提交
93 94 95
sql select tagname from  st_float_14
if $data00 != 0.00150 then
  print expect 0.00150, actual: $data00
S
slguan 已提交
96 97 98 99
  return -1
endi

sql create table st_float_6_0  using mt_float tags ('-123.321')
H
hjxilinx 已提交
100 101 102
sql select tagname from  st_float_6_0
if $data00 != -123.32100 then
  print expect -123.32100, actual: $data00
S
slguan 已提交
103 104 105
  return -1
endi
sql create table st_float_7_0  using mt_float tags ('+1.567')
H
hjxilinx 已提交
106 107 108
sql select tagname from  st_float_7_0
if $data00 != 1.56700 then
  print expect 1.56700, actual: $data00
S
slguan 已提交
109 110 111
  return -1
endi
sql create table st_float_8_0  using mt_float tags ('379.001')
H
hjxilinx 已提交
112 113 114
sql select tagname from  st_float_8_0
if $data00 != 379.00101 then
  print expect 379.00101, actual: $data00
S
slguan 已提交
115 116 117
  return -1
endi
sql create table st_float_9_0  using mt_float tags ('1.5e+3')
H
hjxilinx 已提交
118 119 120
sql select tagname from  st_float_9_0
if $data00 != 1500.00000 then
  print expect 1500.00000, actual: $data00
S
slguan 已提交
121 122 123
  return -1
endi
sql create table st_float_10_0 using mt_float tags ('-1.5e-3')
H
hjxilinx 已提交
124 125 126
sql select tagname from  st_float_10_0
if $data00 != -0.00150 then
  print expect -0.00150, actual: $data00
S
slguan 已提交
127 128 129
  return -1
endi
sql create table st_float_11_0 using mt_float tags ('+1.5e+3')
H
hjxilinx 已提交
130 131 132
sql select tagname from  st_float_11_0
if $data00 != 1500.00000 then
  print expect 1500.00000, actual: $data00
S
slguan 已提交
133 134 135
  return -1
endi
sql create table st_float_12_0 using mt_float tags ('-1.5e+3')
H
hjxilinx 已提交
136 137 138
sql select tagname from  st_float_12_0
if $data00 != -1500.00000 then
  print expect -1500.00000, actual: $data00
S
slguan 已提交
139 140 141
  return -1
endi
sql create table st_float_13_0 using mt_float tags ('1.5e-3')
H
hjxilinx 已提交
142 143 144
sql select tagname from  st_float_13_0
if $data00 != 0.00150 then
  print expect 0.00150, actual: $data00
S
slguan 已提交
145 146 147
  return -1
endi
sql create table st_float_14_0 using mt_float tags ('1.5E-3')
H
hjxilinx 已提交
148 149 150
sql select tagname from  st_float_14_0
if $data00 != 0.00150 then
  print expect 0.00150, actual: $data00
S
slguan 已提交
151 152 153
  return -1
endi
sql create table st_float_15_0 using mt_float tags (3.40282347e+38)
H
hjxilinx 已提交
154 155
sql select tagname from  st_float_15_0
#if $data00 != 0.001500 then
S
slguan 已提交
156 157 158
#  return -1
#endi
sql create table st_float_16_0 using mt_float tags (-3.40282347e+38)
H
hjxilinx 已提交
159 160
sql select tagname from  st_float_16_0
#if $data00 != 0.001500 then
S
slguan 已提交
161 162 163 164
#  return -1
#endi

## case 01: insert values  for test column values
H
hjxilinx 已提交
165
sql insert into st_float_0  values (now, NULL)
S
slguan 已提交
166 167 168 169
sql select * from st_float_0
if $rows != 1 then
  return -1
endi
H
hjxilinx 已提交
170
if $data01 != NULL then
S
slguan 已提交
171 172 173 174 175 176 177
  return -1
endi 
sql insert into st_float_1  values (now, NULL)
sql select * from st_float_1
if $rows != 1 then
  return -1
endi
H
hjxilinx 已提交
178
if $data01 != NULL then
S
slguan 已提交
179 180
  return -1
endi  
H
hjxilinx 已提交
181
sql insert into st_float_2  values (now, 'NULL')
S
slguan 已提交
182 183 184 185
sql select * from st_float_2
if $rows != 1 then
  return -1
endi
H
hjxilinx 已提交
186
if $data01 != NULL then
S
slguan 已提交
187 188 189 190 191 192 193
  return -1
endi
sql insert into st_float_3  values (now, 'NULL')
sql select * from st_float_3
if $rows != 1 then
  return -1
endi
H
hjxilinx 已提交
194
if $data01 != NULL then
S
slguan 已提交
195 196
  return -1
endi
H
hjxilinx 已提交
197
sql insert into st_float_4  values (now, "NULL")
S
slguan 已提交
198 199 200 201
sql select * from st_float_4
if $rows != 1 then
  return -1
endi
H
hjxilinx 已提交
202
if $data01 != NULL then
S
slguan 已提交
203 204 205 206 207 208 209
  return -1
endi
sql insert into st_float_5  values (now, "NULL")
sql select * from st_float_5
if $rows != 1 then
  return -1
endi
H
hjxilinx 已提交
210
if $data01 != NULL then
S
slguan 已提交
211 212 213
  return -1
endi

H
Haojun Liao 已提交
214 215 216 217
sql_error insert into st_float_6  values (now, 3.40282347e+38)
sql_error insert into st_float_6  values (now, -3.40282347e+38)

sql insert into st_float_6 values(now, 340282346638528859811704183484516925440.00000)
S
slguan 已提交
218 219 220 221
sql select * from st_float_6
if $rows != 1 then
  return -1
endi
H
Haojun Liao 已提交
222 223 224 225 226 227

if $data01 != 340282346638528859811704183484516925440.00000 then
  print ==== data01:$data01, expect:340282346638528859811704183484516925440.00000
  return -1
endi
sql insert into st_float_7  values (now, -340282346638528859811704183484516925440.00000)
S
slguan 已提交
228 229 230 231
sql select * from st_float_7
if $rows != 1 then
  return -1
endi
H
Haojun Liao 已提交
232 233 234 235
if $data01 != -340282346638528859811704183484516925440.00000 then
  return -1
endi

S
slguan 已提交
236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295
sql insert into st_float_8  values (now, +100.89) 
sql select * from st_float_8
if $rows != 1 then
  return -1
endi
#if $data01 != 100.89000 then
#  return -1
#endi   
sql insert into st_float_9  values (now, "-0.98")
sql select * from st_float_9
if $rows != 1 then
  return -1
endi
#if $data01 != -0.980000 then
#  return -1
#endi 
sql insert into st_float_10 values (now, '0')
sql select * from st_float_10
if $rows != 1 then
  return -1
endi
#if $data01 != 0.00000 then   # tsim only print 4 bits after dot
#  return -1
#endi 
sql insert into st_float_11 values (now, -0)  
sql select * from st_float_11
if $rows != 1 then
  return -1
endi
#if $data01 != 0.00000 then
#  return -1
#endi 
sql insert into st_float_12 values (now, "+056")
sql select * from st_float_12
if $rows != 1 then
  return -1
endi
#if $data01 != 56.000000 then
#  return -1
#endi 

sql insert into st_float_13 values (now, +056)
sql select * from st_float_13
if $rows != 1 then
  return -1
endi
#if $data01 != 56.000000 then
#  return -1
#endi 

sql insert into st_float_14 values (now, -056)
sql select * from st_float_14
if $rows != 1 then
  return -1
endi
#if $data01 != -56 then
#  return -1
#endi 

## case 02: dynamic create table for test tag values
H
hjxilinx 已提交
296 297 298
sql insert into st_float_16 using mt_float tags (NULL)   values (now, NULL)
sql select tagname from  st_float_16
if $data00 != NULL then
S
slguan 已提交
299 300 301
  return -1
endi
sql select * from st_float_16
H
hjxilinx 已提交
302
if $data01 != NULL then
S
slguan 已提交
303 304 305 306
  return -1
endi
    
sql insert into st_float_17 using mt_float tags (NULL)   values (now, NULL)
H
hjxilinx 已提交
307 308
sql select tagname from  st_float_17
if $data00 != NULL then
S
slguan 已提交
309 310 311
  return -1
endi
sql select * from st_float_17
H
hjxilinx 已提交
312
if $data01 != NULL then
S
slguan 已提交
313 314
  return -1
endi  
H
hjxilinx 已提交
315 316 317
sql insert into st_float_18 using mt_float tags ('NULL') values (now, 'NULL')
sql select tagname from  st_float_18
if $data00 != NULL then
S
slguan 已提交
318 319 320
  return -1
endi
sql select * from st_float_18
H
hjxilinx 已提交
321
if $data01 != NULL then
S
slguan 已提交
322 323 324
  return -1
endi
sql insert into st_float_19 using mt_float tags ('NULL') values (now, 'NULL')
H
hjxilinx 已提交
325 326
sql select tagname from  st_float_19
if $data00 != NULL then
S
slguan 已提交
327 328 329
  return -1
endi
sql select * from st_float_19
H
hjxilinx 已提交
330
if $data01 != NULL then
S
slguan 已提交
331 332
  return -1
endi
H
hjxilinx 已提交
333 334 335
sql insert into st_float_20 using mt_float tags ("NULL") values (now, "NULL")
sql select tagname from  st_float_20
if $data00 != NULL then
S
slguan 已提交
336 337 338
  return -1
endi
sql select * from st_float_20
H
hjxilinx 已提交
339
if $data01 != NULL then
S
slguan 已提交
340 341 342
  return -1
endi
sql insert into st_float_21 using mt_float tags ("NULL") values (now, "NULL")
H
hjxilinx 已提交
343 344
sql select tagname from  st_float_21
if $data00 != NULL then
S
slguan 已提交
345 346 347
  return -1
endi
sql select * from st_float_21
H
hjxilinx 已提交
348
if $data01 != NULL then
S
slguan 已提交
349 350
  return -1
endi
H
Haojun Liao 已提交
351 352 353 354

sql_error  insert into st_float_22 using mt_float tags (127)  values (now, 3.40282347e+38)

sql insert into st_float_22 using mt_float tags (127)  values (now, 340282346638528859811704183484516925440.00000)
H
hjxilinx 已提交
355
sql select tagname from  st_float_22
H
Haojun Liao 已提交
356 357 358 359 360 361 362 363 364 365 366
if $data00 != 127.00000 then
  print expect 127.00000, actual: $data00
  return -1
endi

sql select tbname, tagname from st_float_22
if $data01 != 127.00000 then
  return -1
endi

sql insert into st_float_23 using mt_float tags (-127)  values (now, -340282346638528859811704183484516925440.00000)
H
hjxilinx 已提交
367
sql select tagname from  st_float_23
H
Haojun Liao 已提交
368 369 370 371
if $data00 != -127.00000 then
  return -1
endi

S
slguan 已提交
372
sql insert into st_float_24 using mt_float tags (10)    values (now, 10)
H
hjxilinx 已提交
373
sql select tagname from  st_float_24
H
Haojun Liao 已提交
374 375 376
if $data00 != 10.00000 then
  return -1
endi
S
slguan 已提交
377
sql select * from st_float_24
H
Haojun Liao 已提交
378 379 380 381
if $data01 != 10.00000 then
  return -1
endi

S
slguan 已提交
382
sql insert into st_float_25 using mt_float tags ("-0") values (now, "-0")
H
hjxilinx 已提交
383
sql select tagname from  st_float_25
H
Haojun Liao 已提交
384 385 386 387
if $data00 != -0.00000 then
  print expect -0.00000, actual: $data00
  return -1
endi
S
slguan 已提交
388
sql select * from st_float_25
H
Haojun Liao 已提交
389 390 391
if $data01 != -0.00000 then
  return -1
endi
S
slguan 已提交
392
sql insert into st_float_26 using mt_float tags ('123') values (now, '12.3')
H
hjxilinx 已提交
393
sql select tagname from  st_float_26
H
Haojun Liao 已提交
394 395 396 397
if $data00 != 123.00000 then
  print expect 123.00000, actual: $data00
  return -1
endi
S
slguan 已提交
398
sql select * from st_float_26
H
Haojun Liao 已提交
399 400 401
if $data01 != 12.30000 then
  return -1
endi
S
slguan 已提交
402
sql insert into st_float_27 using mt_float tags (+056) values (now, +0005.6)
H
hjxilinx 已提交
403
sql select tagname from  st_float_27
H
Haojun Liao 已提交
404 405 406 407
if $data00 != 56.00000 then
  print expect 56.00000, actual:$data00
  return -1
endi
S
slguan 已提交
408
sql select * from st_float_27
H
Haojun Liao 已提交
409 410 411
if $data01 != 5.60000 then
  return -1
endi
S
slguan 已提交
412
sql insert into st_float_28 using mt_float tags (-056) values (now, -005.6)
H
hjxilinx 已提交
413
sql select tagname from  st_float_28
H
Haojun Liao 已提交
414 415 416
if $data00 != -56.00000 then
  return -1
endi
S
slguan 已提交
417
sql select * from st_float_28
H
Haojun Liao 已提交
418 419 420
if $data01 != -5.60000 then
  return -1
endi
S
slguan 已提交
421

H
hjxilinx 已提交
422
### case 03: alter tag values
H
Haojun Liao 已提交
423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 459 460 461 462 463
sql alter table st_float_0 set tag tagname=340282346638528859811704183484516925440.00000
sql select tagname from st_float_0
if $data00 != 340282346638528859811704183484516925440.00000 then
  return -1
endi

sql alter table st_float_0 set tag tagname=-340282346638528859811704183484516925440.00000
sql select tagname from  st_float_0
if $data00 != -340282346638528859811704183484516925440.00000 then
  return -1
endi
sql alter table st_float_0 set tag tagname=+10.340
sql select tagname from  st_float_0
if $data00 != 10.34000 then
  return -1
endi
sql alter table st_float_0 set tag tagname=-33.87
sql select tagname from  st_float_0
if $data00 != -33.87000 then
  return -1
endi
sql alter table st_float_0 set tag tagname='+9.8'
sql select tagname from  st_float_0
if $data00 != 9.80000 then
  return -1
endi
sql alter table st_float_0 set tag tagname='-07.6'
sql select tagname from  st_float_0
if $data00 != -7.60000 then
  return -1
endi
sql alter table st_float_0 set tag tagname=+0012.871
sql select tagname from  st_float_0
if $data00 != 12.87100 then
  return -1
endi
sql alter table st_float_0 set tag tagname=-00063.582
sql select tagname from  st_float_0
if $data00 != -63.58200 then
  return -1
endi
S
slguan 已提交
464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499 500 501 502 503 504 505 506 507 508 509 510 511 512 513 514 515 516 517 518 519 520 521 522 523 524 525 526 527 528 529 530 531 532 533 534 535 536 537 538 539 540 541 542 543 544 545 546 547 548 549 550 551 552 553 554 555

## case 04: illegal input
sql_error create table st_float_e0 using mt_float tags (3.50282347e+38)
sql_error create table st_float_e0 using mt_float tags (-3.50282347e+38)
sql_error create table st_float_e0 using mt_float tags (333.40282347e+38)
sql_error create table st_float_e0 using mt_float tags (-333.40282347e+38)
#sql_error create table st_float_e0 using mt_float tags (12.80)   truncate integer part
#sql_error create table st_float_e0 using mt_float tags (-11.80)
sql_error create table st_float_e0 using mt_float tags (123abc)  
sql_error create table st_float_e0 using mt_float tags ("123abc")
sql_error create table st_float_e0 using mt_float tags (abc)     
sql_error create table st_float_e0 using mt_float tags ("abc")   
sql_error create table st_float_e0 using mt_float tags (" ")     
sql_error create table st_float_e0 using mt_float tags ('')      

sql create table st_float_e0  using mt_float tags (123)
sql create table st_float_e1  using mt_float tags (123)
sql create table st_float_e2  using mt_float tags (123)
sql create table st_float_e3  using mt_float tags (123)
sql create table st_float_e4  using mt_float tags (123)
sql create table st_float_e5  using mt_float tags (123)
sql create table st_float_e6  using mt_float tags (123)
sql create table st_float_e7  using mt_float tags (123)
sql create table st_float_e8  using mt_float tags (123)
sql create table st_float_e9  using mt_float tags (123)
sql create table st_float_e10 using mt_float tags (123)
sql create table st_float_e11 using mt_float tags (123)
sql create table st_float_e12 using mt_float tags (123)

sql_error insert into st_float_e0  values (now, 3.50282347e+38)     
sql_error insert into st_float_e1  values (now, -3.50282347e+38)    
sql_error insert into st_float_e2  values (now, 13.40282347e+38)    
sql_error insert into st_float_e3  values (now, -13.40282347e+38)   
#sql_error insert into st_float_e4  values (now, 12.80)   
#sql_error insert into st_float_e5  values (now, -11.80)  
sql_error insert into st_float_e6  values (now, 123abc)  
sql_error insert into st_float_e7  values (now, "123abc")
sql_error insert into st_float_e9  values (now, abc)     
sql_error insert into st_float_e10 values (now, "abc")   
sql_error insert into st_float_e11 values (now, " ")     
sql_error insert into st_float_e12 values (now, '')      

sql_error insert into st_float_e13 using mt_float tags (033) values (now, 3.50282347e+38)     
sql_error insert into st_float_e14 using mt_float tags (033) values (now, -3.50282347e+38)    
sql_error insert into st_float_e15 using mt_float tags (033) values (now, 13.40282347e+38)    
sql_error insert into st_float_e16 using mt_float tags (033) values (now, -13.40282347e+38)   
#sql_error insert into st_float_e17 using mt_float tags (033) values (now, 12.80)   
#sql_error insert into st_float_e18 using mt_float tags (033) values (now, -11.80)  
sql_error insert into st_float_e19 using mt_float tags (033) values (now, 123abc)  
sql_error insert into st_float_e20 using mt_float tags (033) values (now, "123abc")
sql_error insert into st_float_e22 using mt_float tags (033) values (now, abc)     
sql_error insert into st_float_e23 using mt_float tags (033) values (now, "abc")   
sql_error insert into st_float_e24 using mt_float tags (033) values (now, " ")     
sql_error insert into st_float_e25 using mt_float tags (033) values (now, '')  

sql_error insert into st_float_e13 using mt_float tags (3.50282347e+38)      values (now, -033)
sql_error insert into st_float_e14 using mt_float tags (-3.50282347e+38)     values (now, -033)
sql_error insert into st_float_e15 using mt_float tags (13.40282347e+38)     values (now, -033)
sql_error insert into st_float_e16 using mt_float tags (-13.40282347e+38)    values (now, -033)
#sql_error insert into st_float_e17 using mt_float tags (12.80)    values (now, -033)
#sql_error insert into st_float_e18 using mt_float tags (-11.80)   values (now, -033)
sql_error insert into st_float_e19 using mt_float tags (123abc)   values (now, -033)
sql_error insert into st_float_e20 using mt_float tags ("123abc") values (now, -033)
sql_error insert into st_float_e22 using mt_float tags (abc)      values (now, -033)
sql_error insert into st_float_e23 using mt_float tags ("abc")    values (now, -033)
sql_error insert into st_float_e24 using mt_float tags (" ")      values (now, -033)
sql_error insert into st_float_e25 using mt_float tags ('')       values (now, -033)

sql insert into st_float_e13 using mt_float tags (033) values (now, 00062)
sql insert into st_float_e14 using mt_float tags (033) values (now, 00062)
sql insert into st_float_e15 using mt_float tags (033) values (now, 00062)
sql insert into st_float_e16 using mt_float tags (033) values (now, 00062)
sql insert into st_float_e17 using mt_float tags (033) values (now, 00062)
sql insert into st_float_e18 using mt_float tags (033) values (now, 00062)
sql insert into st_float_e19 using mt_float tags (033) values (now, 00062)
sql insert into st_float_e20 using mt_float tags (033) values (now, 00062)
sql insert into st_float_e21 using mt_float tags (033) values (now, 00062)
sql insert into st_float_e22 using mt_float tags (033) values (now, 00062)
sql insert into st_float_e23 using mt_float tags (033) values (now, 00062)
sql insert into st_float_e24 using mt_float tags (033) values (now, 00062)
sql insert into st_float_e25 using mt_float tags (033) values (now, 00062)

sql_error alter table st_float_e13 set tag tagname=3.50282347e+38     
sql_error alter table st_float_e14 set tag tagname=-3.50282347e+38    
sql_error alter table st_float_e15 set tag tagname=13.40282347e+38   
sql_error alter table st_float_e16 set tag tagname=-13.40282347e+38   
sql_error alter table st_float_e19 set tag tagname=123abc  
sql_error alter table st_float_e20 set tag tagname="123abc" 
sql_error alter table st_float_e22 set tag tagname=abc     
sql_error alter table st_float_e23 set tag tagname="abc"   
sql_error alter table st_float_e24 set tag tagname=" "     
sql_error alter table st_float_e25 set tag tagname=''