system sh/stop_dnodes.sh system sh/ip.sh -i 1 -s up system sh/deploy.sh -n dnode1 -m 192.168.0.1 -i 192.168.0.1 system sh/cfg.sh -n dnode1 -c commitLog -v 0 system sh/exec.sh -n dnode1 -s start sleep 3000 sql connect $dbPrefix = m_co_db $tbPrefix = m_co_tb $mtPrefix = m_co_mt $tbNum = 10 $rowNum = 20 $totalNum = 200 print =============== step1 $i = 0 $db = $dbPrefix . $i $mt = $mtPrefix . $i sql drop database $db -x step1 step1: sql create database $db sql use $db sql create table $mt (ts timestamp, tbcol int) TAGS(tgcol int) $i = 0 while $i < $tbNum $tb = $tbPrefix . $i sql create table $tb using $mt tags( $i ) $x = 0 while $x < $rowNum $ms = $x . m sql insert into $tb values (now + $ms , $x ) $x = $x + 1 endw $i = $i + 1 endw sleep 100 print =============== step2 $i = 1 $tb = $tbPrefix . $i sql select count(*) from $tb print ===> select count(*) from $tb => $data00 if $data00 != $rowNum then return -1 endi sql select count(tbcol) from $tb print ===> $data00 if $data00 != $rowNum then return -1 endi print =============== step3 sql select count(tbcol) from $tb where ts < now + 4m print ===> $data00 if $data00 != 5 then return -1 endi print =============== step4 sql select count(tbcol) as b from $tb print ===> $data00 if $data00 != $rowNum then return -1 endi print =============== step5 sql select count(tbcol) as b from $tb interval(1m) print ===> $data01 if $data01 != 1 then return -1 endi sql select count(tbcol) as b from $tb interval(1d) print ===> $data01 if $data01 != $rowNum then return -1 endi print =============== step6 sql select count(tbcol) as b from $tb where ts < now + 4m interval(1m) print ===> $data01 if $data01 != 1 then return -1 endi if $rows != 5 then return -1 endi print =============== step7 sql select count(*) from $mt print ===> $data00 if $data00 != $totalNum then return -1 endi sql select count(tbcol) from $mt print ===> $data00 if $data00 != $totalNum then return -1 endi print =============== step8 sql select count(tbcol) as c from $mt where ts < now + 4m print ===> $data00 if $data00 != 50 then return -1 endi sql select count(tbcol) as c from $mt where tgcol < 5 print ===> $data00 if $data00 != 100 then return -1 endi sql select count(tbcol) as c from $mt where tgcol < 5 and ts < now + 4m print ===> $data00 if $data00 != 25 then return -1 endi print =============== step9 sql select count(tbcol) as b from $mt interval(1m) print ===> $data01 if $data01 != 10 then return -1 endi if $data11 != 10 then return -1 endi sql select count(tbcol) as b from $mt interval(1d) print ===> $data01 if $data01 != 200 then return -1 endi print =============== step10 sql select count(tbcol) as b from $mt group by tgcol print ===> $data00 if $data00 != $rowNum then return -1 endi if $rows != $tbNum then return -1 endi print =============== step11 sql select count(tbcol) as b from $mt where ts < now + 4m interval(1m) group by tgcol print ===> $data01 if $data01 != 1 then return -1 endi if $rows != 50 then return -1 endi print =============== clear sql drop database $db sql show databases if $rows != 0 then return -1 endi