set.sim

sql connect
sleep 3000
print ======================== dnode1 start

sql show databases
sql drop database $data00 -x e1
e1:
sql show databases
sql drop database $data00 -x e2
e2:

$dbPrefix = ta_se_db
$tbPrefix = ta_se_tb
$mtPrefix = ta_se_mt
$tbNum = 10
$rowNum = 20
$totalNum = 200

print =============== step1
$i = 0
$db = $dbPrefix . $i

sql create database $db
sql use $db

print =============== step2
$i = 2
$mt = $mtPrefix . $i
$tb = $tbPrefix . $i
sql create table $mt (ts timestamp, tbcol int) TAGS(tgcol1 bool, tgcol2 int)
sql create table $tb using $mt tags( 1, 2 )
sql insert into $tb values(now, 1)  
sql select * from $mt where tgcol1 = 1
if $rows != 1 then 
  return -1
endi
if $data01 != 1 then 
  return -1
endi
if $data02 != 1 then
  return -1
endi
if $data03 != 2 then 
  return -1
endi

sql alter table $tb set tag tagcx 1 -x step21
  return -1
step21:
sql alter table $tb set tag tgcol1=false
sql alter table $tb set tag tgcol2=4

sql reset query cache

sql select * from $mt where tgcol1 = false
print $data01 $data02 $data03
if $rows != 1 then 
  return -1
endi
if $data01 != 1 then 
  return -1
endi
if $data02 != 0 then
  return -1
endi
if $data03 != 4 then 
  return -1
endi

sql select * from $mt where tgcol2 = 4
print $data01 $data02 $data03
if $rows != 1 then 
  return -1
endi
if $data01 != 1 then 
  return -1
endi
if $data02 != 0 then
  return -1
endi
if $data03 != 4 then 
  return -1
endi

sql describe $tb
print $data21 $data23 $data32 $data33
if $data21 != BOOL then 
  return -1
endi
if $data31 != INT then 
  return -1
endi
if $data23 != TAG then
  return -1
endi
if $data33 != TAG then 
  return -1
endi

print =============== step3
$i = 3
$mt = $mtPrefix . $i
$tb = $tbPrefix . $i
sql create table $mt (ts timestamp, tbcol int) TAGS(tgcol1 smallint, tgcol2 tinyint)
sql create table $tb using $mt tags( 1, 2 )
sql insert into $tb values(now, 1)  
sql select * from $mt where tgcol1 = 1
if $rows != 1 then 
  return -1
endi
if $data01 != 1 then 
  return -1
endi
if $data02 != 1 then 
  return -1
endi
if $data03 != 2 then 
  return -1
endi

sql alter table $tb set tag tgcol1=3
sql alter table $tb set tag tgcol2=4

sql reset query cache

sql select * from $mt where tgcol1 = 3
print $data01 $data02 $data03
if $rows != 1 then 
  return -1
endi
if $data01 != 1 then 
  return -1
endi
if $data02 != 3 then 
  return -1
endi
if $data03 != 4 then 
  return -1
endi

sql select * from $mt where tgcol2 = 4
print $data01 $data02 $data03
if $rows != 1 then 
  return -1
endi
if $data01 != 1 then 
  return -1
endi
if $data02 != 3 then 
  return -1
endi
if $data03 != 4 then 
  return -1
endi

sql select * from $mt where tgcol2 = 2
if $rows != 0 then 
  return -1
endi
  
  
print =============== step4
$i = 4
$mt = $mtPrefix . $i
$tb = $tbPrefix . $i
sql create table $mt (ts timestamp, tbcol int) TAGS(tgcol1 bigint, tgcol2 float)
sql create table $tb using $mt tags( 1, 2 )
sql insert into $tb values(now, 1)  
sql select * from $mt where tgcol1 = 1
if $rows != 1 then 
  return -1
endi
if $data01 != 1 then 
  return -1
endi
if $data02 != 1 then 
  return -1
endi
if $data03 != 2.00000 then 
  return -1
endi

sql alter table $tb set tag tgcol1=3
sql alter table $tb set tag tgcol2=4

sql reset query cache

sql select * from $mt where tgcol1 = 3
print $data01 $data02 $data03
if $rows != 1 then 
  return -1
endi
if $data01 != 1 then 
  return -1
endi
if $data02 != 3 then 
  return -1
endi
if $data03 != 4.00000 then 
  return -1
endi

sql select * from $mt where tgcol2 = 4
print $data01 $data02 $data03
if $rows != 1 then 
  return -1
endi
if $data01 != 1 then 
  return -1
endi
if $data02 != 3 then 
  return -1
endi
if $data03 != 4.00000 then 
  return -1
endi
  
  
print =============== step5
$i = 5
$mt = $mtPrefix . $i
$tb = $tbPrefix . $i
sql create table $mt (ts timestamp, tbcol int) TAGS(tgcol1 double, tgcol2 binary(10))
sql create table $tb using $mt tags( 1, '2' )
sql insert into $tb values(now, 1)  
sql select * from $mt where tgcol2 = '2'
if $rows != 1 then 
  return -1
endi
if $data01 != 1 then 
  return -1
endi
if $data02 != 1.000000000 then 
  return -1
endi
if $data03 != 2 then 
  return -1
endi

sql alter table $tb set tag tgcol1=3
sql alter table $tb set tag tgcol2='4'

sql reset query cache

sql select * from $mt where tgcol1 = 3
print $data01 $data02 $data03
if $rows != 1 then 
  return -1
endi
if $data01 != 1 then 
  return -1
endi
if $data02 != 3.000000000 then 
  return -1
endi
if $data03 != 4 then 
  return -1
endi

sql select * from $mt where tgcol2 = '4'
print $data01 $data02 $data03
if $rows != 1 then 
  return -1
endi
if $data01 != 1 then 
  return -1
endi
if $data02 != 3.000000000 then 
  return -1
endi
if $data03 != 4 then 
  return -1
endi
  
print =============== step6
$i = 6
$mt = $mtPrefix . $i
$tb = $tbPrefix . $i
sql create table $mt (ts timestamp, tbcol int) TAGS(tgcol1 binary(10), tgcol2 int, tgcol3 smallint, tgcol4 binary(11), tgcol5 double, tgcol6 binary(20))
sql create table $tb using $mt tags( '1', 2, 3, '4', 5, '6' )
sql insert into $tb values(now, 1)  
sql select * from $mt where tgcol1 = '1'
if $rows != 1 then 
  return -1
endi
if $data01 != 1 then 
  return -1
endi
if $data02 != 1 then 
  return -1
endi
if $data03 != 2 then 
  return -1
endi
if $data04 != 3 then 
  return -1
endi
if $data05 != 4 then 
  return -1
endi
if $data06 != 5.000000000 then 
  return -1
endi
if $data07 != 6 then 
  return -1
endi

sql alter table $mt drop tag tgcol3
sql alter table $tb set tag tgcol1='7'
sql alter table $tb set tag tgcol2=8
sql alter table $tb set tag tgcol4='9'
sql alter table $tb set tag tgcol5=10
sql alter table $tb set tag tgcol6='11'

sql reset query cache
  
sql select * from $mt where tgcol1 = '7'
print $data01 $data02 $data03
if $rows != 1 then 
  return -1
endi
if $data01 != 1 then 
  return -1
endi
if $data02 != 7 then 
  return -1
endi
if $data03 != 8 then 
  return -1
endi
if $data04 != 9 then 
  return -1
endi
if $data05 != 10.000000000 then 
  return -1
endi
if $data06 != 11 then 
  return -1
endi
if $data07 != null then 
  return -1
endi

sql select * from $mt where tgcol2 = 8
print $data01 $data02 $data03
if $rows != 1 then 
  return -1
endi
if $data01 != 1 then 
  return -1
endi
if $data02 != 7 then 
  return -1
endi
if $data03 != 8 then 
  return -1
endi
if $data04 != 9 then 
  return -1
endi
if $data05 != 10.000000000 then 
  return -1
endi
if $data06 != 11 then 
  return -1
endi
if $data07 != null then 
  return -1
endi

sql select * from $mt where tgcol4 = '9'
print $data01 $data02 $data03
if $rows != 1 then 
  return -1
endi
if $data01 != 1 then 
  return -1
endi
if $data02 != 7 then 
  return -1
endi
if $data03 != 8 then 
  return -1
endi
if $data04 != 9 then 
  return -1
endi
if $data05 != 10.000000000 then 
  return -1
endi
if $data06 != 11 then 
  return -1
endi
if $data07 != null then 
  return -1
endi

sql select * from $mt where tgcol5 = 10
print $data01 $data02 $data03
if $rows != 1 then 
  return -1
endi
if $data01 != 1 then 
  return -1
endi
if $data02 != 7 then 
  return -1
endi
if $data03 != 8 then 
  return -1
endi
if $data04 != 9 then 
  return -1
endi
if $data05 != 10.000000000 then 
  return -1
endi
if $data06 != 11 then 
  return -1
endi
if $data07 != null then 
  return -1
endi

sql select * from $mt where tgcol6 = '11'
print $data01 $data02 $data03
if $rows != 1 then 
  return -1
endi
if $data01 != 1 then 
  return -1
endi
if $data02 != 7 then 
  return -1
endi
if $data03 != 8 then 
  return -1
endi
if $data04 != 9 then 
  return -1
endi
if $data05 != 10.000000000 then 
  return -1
endi
if $data06 != 11 then 
  return -1
endi
if $data07 != null then 
  return -1
endi

print =============== clear
sql drop database $db
sql show databases
if $rows != 0 then 
  return -1
endi