sleep 3000 sql connect sql show databases sql drop database $data00 -x e1 e1: sql show databases sql drop database $data00 -x e2 e2: $dbPrefix = m_st_db $tbPrefix = m_st_tb $mtPrefix = m_st_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 stddev(tbcol) from $tb print ===> $data00 if $data00 != 5.766281297 then return -1 endi print =============== step3 sql select stddev(tbcol) from $tb where ts < now + 4m print ===> $data00 if $data00 != 1.414213562 then return -1 endi print =============== step4 sql select stddev(tbcol) as b from $tb print ===> $data00 if $data00 != 5.766281297 then return -1 endi print =============== step5 sql select stddev(tbcol) as b from $tb interval(1m) print ===> $data01 if $data01 != 0.000000000 then return -1 endi sql select stddev(tbcol) as b from $tb interval(1d) print ===> $data01 if $data01 != 5.766281297 then return -1 endi print =============== step6 sql select stddev(tbcol) as b from $tb where ts < now + 4m interval(1m) print ===> $data01 if $data01 != 0.000000000 then return -1 endi if $rows != 5 then return -1 endi print =============== clear sql drop database $db sql show databases if $rows != 0 then return -1 endi