system sh/stop_dnodes.sh system sh/deploy.sh -n dnode1 -i 1 system sh/exec.sh -n dnode1 -s start sql connect $dbPrefix = m_me_db $tbPrefix = m_me_tb $mtPrefix = m_me_mt print =============== step1 $i = 0 $db = $dbPrefix . $i $tb = $tbPrefix . $i $mt = $mtPrefix . $i sql drop database $db -x step1 step1: sql create database $db sql use $db sql create table $mt (ts timestamp, speed int) TAGS(sp int) sql show stables if $rows != 1 then return -1 endi #TODO OPEN THIS WHEN STABLE DELETE WORKS #print =============== step2 #sql drop table $mt #sql show stables #if $rows != 0 then # return -1 #endi #print =============== step3 #sql create table $mt (ts timestamp, speed int) TAGS(sp int) #TODO OPEN THIS WHEN STABLE DELETE WORKS sql show stables if $rows != 1 then return -1 endi if $data00 != $mt then return -1 endi if $data04 != 1 then return -1 endi # TODO : select * from stable # sql select * from $mt # if $rows != 0 then # return -1 # endi print =============== step4 $i = 0 $tb = $tbPrefix . $i sql create table $tb using $mt tags(1) $i = 1 $tb = $tbPrefix . $i sql create table $tb using $mt tags(2) $i = 2 $tb = $tbPrefix . $i sql create table $tb using $mt tags(3) sql show tables if $rows != 3 then return -1 endi # if $data03 != $mt then # return -1 # endi sql show stables if $rows != 1 then return -1 endi if $data00 != $mt then return -1 endi # if $data04 != 3 then # return -1 # endi print =============== step5 $i = 0 $tb = $tbPrefix . $i sql insert into $tb values (now + 1m , 1 ) $i = 1 $tb = $tbPrefix . $i sql insert into $tb values (now + 1m , 1 ) $i = 2 $tb = $tbPrefix . $i sql insert into $tb values (now + 1m , 1 ) print =============== step6 # sql select * from $mt # print select * from $mt ==> $rows $data00 # if $rows != 3 then # return -1 # endi print =============== step7 # sql select * from $mt where sp = 1 # print select * from $mt where sp = 1 ==> $rows $data00 # if $rows != 1 then # return -1 # endi print =============== step8 sql drop table $mt print =============== step9 #sql show tables #if $rows != 0 then # return -1 #endi sql show stables if $rows != 0 then return -1 endi sql drop database $db sql show databases if $rows != 2 then return -1 endi system sh/exec.sh -n dnode1 -s stop -x SIGINT