mirror of
https://github.com/taosdata/TDengine
synced 2026-05-24 10:09:01 +00:00
d69c5977db
* restore .gitmodules
* Revert "[TD-13408]<test>: move tests directory out"
This reverts commit 7db7bd9337.
* revert to make tests back
* immigrate file change in stand-alone repo to TDengine
* remove tests repository checkout
Co-authored-by: tangfangzhi <fztang@taosdata.com>
2485 lines
40 KiB
Text
2485 lines
40 KiB
Text
system sh/stop_dnodes.sh
|
|
|
|
system sh/deploy.sh -n dnode1 -i 1
|
|
system sh/cfg.sh -n dnode1 -c walLevel -v 1
|
|
system sh/cfg.sh -n dnode1 -c minRows -v 10
|
|
system sh/exec.sh -n dnode1 -s start
|
|
sleep 200
|
|
sql connect
|
|
|
|
$db = m_db_tbg_limit
|
|
$tb = ct
|
|
$mt = st
|
|
|
|
sql drop database $db -x step1
|
|
step1:
|
|
sql create database $db
|
|
sql use $db
|
|
sql create table $mt ( ts timestamp, f1 int, f2 int ) tags(t int)
|
|
|
|
$tb1 = ct1
|
|
$tb2 = ct2
|
|
$tb3 = ct3
|
|
$tbnum = 3
|
|
$rownum = 10
|
|
|
|
$x = 0
|
|
while $x < $rownum
|
|
$i = 1
|
|
while $i <= $tbnum
|
|
$tbi = $tb . $i
|
|
$inc = $x * 60
|
|
$inc1 = $inc + $i
|
|
$ms = 1601481600000 + $inc1
|
|
$v1 = $x * 10
|
|
$v = $v1 + $i
|
|
sql insert into $tbi using $mt tags( $i ) values ( $ms , $v , $v )
|
|
$i = $i + 1
|
|
endw
|
|
$x = $x + 1
|
|
endw
|
|
|
|
system sh/exec.sh -n dnode1 -s stop -x SIGINT
|
|
sleep 500
|
|
system sh/exec.sh -n dnode1 -s start
|
|
sleep 200
|
|
sql connect
|
|
sql use $db
|
|
|
|
$x = 0
|
|
while $x < $rownum
|
|
$i = 1
|
|
while $i <= $tbnum
|
|
$tbi = $tb . $i
|
|
$inc = $x * 60
|
|
$inc1 = $inc + $i
|
|
$ms = 1601481700000 + $inc1
|
|
$v1 = $x * 10
|
|
$temp = $rownum * 10
|
|
$v1 = $v1 + $temp
|
|
$v = $v1 + $i
|
|
sql insert into $tbi using $mt tags( $i ) values ( $ms , $v , $v )
|
|
$i = $i + 1
|
|
endw
|
|
$x = $x + 1
|
|
endw
|
|
|
|
system sh/exec.sh -n dnode1 -s stop -x SIGINT
|
|
sleep 500
|
|
system sh/exec.sh -n dnode1 -s start
|
|
sql connect
|
|
sql use $db
|
|
|
|
print execute sql select csum(f1) from st group by tbname
|
|
|
|
sql select csum(f1) from st group by tbname
|
|
|
|
if $rows != 60 then
|
|
return -1
|
|
endi
|
|
if $data00 != @20-10-01 00:00:00.001@ then
|
|
return -1
|
|
endi
|
|
if $data01 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data02 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data10 != @20-10-01 00:00:00.061@ then
|
|
return -1
|
|
endi
|
|
if $data11 != @12@ then
|
|
return -1
|
|
endi
|
|
if $data12 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data20 != @20-10-01 00:00:00.121@ then
|
|
return -1
|
|
endi
|
|
if $data21 != @33@ then
|
|
return -1
|
|
endi
|
|
if $data22 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data30 != @20-10-01 00:00:00.181@ then
|
|
return -1
|
|
endi
|
|
if $data31 != @64@ then
|
|
return -1
|
|
endi
|
|
if $data32 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data40 != @20-10-01 00:00:00.241@ then
|
|
return -1
|
|
endi
|
|
if $data41 != @105@ then
|
|
return -1
|
|
endi
|
|
if $data42 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data50 != @20-10-01 00:00:00.301@ then
|
|
return -1
|
|
endi
|
|
if $data51 != @156@ then
|
|
return -1
|
|
endi
|
|
if $data52 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data60 != @20-10-01 00:00:00.361@ then
|
|
return -1
|
|
endi
|
|
if $data61 != @217@ then
|
|
return -1
|
|
endi
|
|
if $data62 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data70 != @20-10-01 00:00:00.421@ then
|
|
return -1
|
|
endi
|
|
if $data71 != @288@ then
|
|
return -1
|
|
endi
|
|
if $data72 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data80 != @20-10-01 00:00:00.481@ then
|
|
return -1
|
|
endi
|
|
if $data81 != @369@ then
|
|
return -1
|
|
endi
|
|
if $data82 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data90 != @20-10-01 00:00:00.541@ then
|
|
return -1
|
|
endi
|
|
if $data91 != @460@ then
|
|
return -1
|
|
endi
|
|
if $data92 != @ct1@ then
|
|
return -1
|
|
endi
|
|
print execute sql select diff(f1) from st group by tbname
|
|
|
|
sql select diff(f1) from st group by tbname
|
|
|
|
if $rows != 57 then
|
|
return -1
|
|
endi
|
|
if $data00 != @20-10-01 00:00:00.061@ then
|
|
return -1
|
|
endi
|
|
if $data01 != @10@ then
|
|
return -1
|
|
endi
|
|
if $data02 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data10 != @20-10-01 00:00:00.121@ then
|
|
return -1
|
|
endi
|
|
if $data11 != @10@ then
|
|
return -1
|
|
endi
|
|
if $data12 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data20 != @20-10-01 00:00:00.181@ then
|
|
return -1
|
|
endi
|
|
if $data21 != @10@ then
|
|
return -1
|
|
endi
|
|
if $data22 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data30 != @20-10-01 00:00:00.241@ then
|
|
return -1
|
|
endi
|
|
if $data31 != @10@ then
|
|
return -1
|
|
endi
|
|
if $data32 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data40 != @20-10-01 00:00:00.301@ then
|
|
return -1
|
|
endi
|
|
if $data41 != @10@ then
|
|
return -1
|
|
endi
|
|
if $data42 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data50 != @20-10-01 00:00:00.361@ then
|
|
return -1
|
|
endi
|
|
if $data51 != @10@ then
|
|
return -1
|
|
endi
|
|
if $data52 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data60 != @20-10-01 00:00:00.421@ then
|
|
return -1
|
|
endi
|
|
if $data61 != @10@ then
|
|
return -1
|
|
endi
|
|
if $data62 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data70 != @20-10-01 00:00:00.481@ then
|
|
return -1
|
|
endi
|
|
if $data71 != @10@ then
|
|
return -1
|
|
endi
|
|
if $data72 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data80 != @20-10-01 00:00:00.541@ then
|
|
return -1
|
|
endi
|
|
if $data81 != @10@ then
|
|
return -1
|
|
endi
|
|
if $data82 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data90 != @20-10-01 00:01:40.001@ then
|
|
return -1
|
|
endi
|
|
if $data91 != @10@ then
|
|
return -1
|
|
endi
|
|
if $data92 != @ct1@ then
|
|
return -1
|
|
endi
|
|
print execute sql select derivative(f1, 1s, 0) from st group by tbname
|
|
|
|
sql select derivative(f1, 1s, 0) from st group by tbname
|
|
|
|
if $rows != 57 then
|
|
return -1
|
|
endi
|
|
if $data00 != @20-10-01 00:00:00.061@ then
|
|
return -1
|
|
endi
|
|
if $data01 != @166.666666667@ then
|
|
return -1
|
|
endi
|
|
if $data02 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data10 != @20-10-01 00:00:00.121@ then
|
|
return -1
|
|
endi
|
|
if $data11 != @166.666666667@ then
|
|
return -1
|
|
endi
|
|
if $data12 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data20 != @20-10-01 00:00:00.181@ then
|
|
return -1
|
|
endi
|
|
if $data21 != @166.666666667@ then
|
|
return -1
|
|
endi
|
|
if $data22 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data30 != @20-10-01 00:00:00.241@ then
|
|
return -1
|
|
endi
|
|
if $data31 != @166.666666667@ then
|
|
return -1
|
|
endi
|
|
if $data32 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data40 != @20-10-01 00:00:00.301@ then
|
|
return -1
|
|
endi
|
|
if $data41 != @166.666666667@ then
|
|
return -1
|
|
endi
|
|
if $data42 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data50 != @20-10-01 00:00:00.361@ then
|
|
return -1
|
|
endi
|
|
if $data51 != @166.666666667@ then
|
|
return -1
|
|
endi
|
|
if $data52 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data60 != @20-10-01 00:00:00.421@ then
|
|
return -1
|
|
endi
|
|
if $data61 != @166.666666667@ then
|
|
return -1
|
|
endi
|
|
if $data62 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data70 != @20-10-01 00:00:00.481@ then
|
|
return -1
|
|
endi
|
|
if $data71 != @166.666666667@ then
|
|
return -1
|
|
endi
|
|
if $data72 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data80 != @20-10-01 00:00:00.541@ then
|
|
return -1
|
|
endi
|
|
if $data81 != @166.666666667@ then
|
|
return -1
|
|
endi
|
|
if $data82 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data90 != @20-10-01 00:01:40.001@ then
|
|
return -1
|
|
endi
|
|
if $data91 != @0.100542932@ then
|
|
return -1
|
|
endi
|
|
if $data92 != @ct1@ then
|
|
return -1
|
|
endi
|
|
print execute sql select mavg(f1,2) from st group by tbname
|
|
|
|
sql select mavg(f1,2) from st group by tbname
|
|
|
|
if $rows != 57 then
|
|
return -1
|
|
endi
|
|
if $data00 != @20-10-01 00:00:00.061@ then
|
|
return -1
|
|
endi
|
|
if $data01 != @6.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data02 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data10 != @20-10-01 00:00:00.121@ then
|
|
return -1
|
|
endi
|
|
if $data11 != @16.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data12 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data20 != @20-10-01 00:00:00.181@ then
|
|
return -1
|
|
endi
|
|
if $data21 != @26.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data22 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data30 != @20-10-01 00:00:00.241@ then
|
|
return -1
|
|
endi
|
|
if $data31 != @36.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data32 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data40 != @20-10-01 00:00:00.301@ then
|
|
return -1
|
|
endi
|
|
if $data41 != @46.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data42 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data50 != @20-10-01 00:00:00.361@ then
|
|
return -1
|
|
endi
|
|
if $data51 != @56.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data52 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data60 != @20-10-01 00:00:00.421@ then
|
|
return -1
|
|
endi
|
|
if $data61 != @66.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data62 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data70 != @20-10-01 00:00:00.481@ then
|
|
return -1
|
|
endi
|
|
if $data71 != @76.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data72 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data80 != @20-10-01 00:00:00.541@ then
|
|
return -1
|
|
endi
|
|
if $data81 != @86.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data82 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data90 != @20-10-01 00:01:40.001@ then
|
|
return -1
|
|
endi
|
|
if $data91 != @96.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data92 != @ct1@ then
|
|
return -1
|
|
endi
|
|
print execute sql select csum(f1),t from st group by tbname
|
|
|
|
sql select csum(f1),t from st group by tbname
|
|
|
|
if $rows != 60 then
|
|
return -1
|
|
endi
|
|
if $data00 != @20-10-01 00:00:00.001@ then
|
|
return -1
|
|
endi
|
|
if $data01 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data02 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data03 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data10 != @20-10-01 00:00:00.061@ then
|
|
return -1
|
|
endi
|
|
if $data11 != @12@ then
|
|
return -1
|
|
endi
|
|
if $data12 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data13 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data20 != @20-10-01 00:00:00.121@ then
|
|
return -1
|
|
endi
|
|
if $data21 != @33@ then
|
|
return -1
|
|
endi
|
|
if $data22 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data23 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data30 != @20-10-01 00:00:00.181@ then
|
|
return -1
|
|
endi
|
|
if $data31 != @64@ then
|
|
return -1
|
|
endi
|
|
if $data32 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data33 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data40 != @20-10-01 00:00:00.241@ then
|
|
return -1
|
|
endi
|
|
if $data41 != @105@ then
|
|
return -1
|
|
endi
|
|
if $data42 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data43 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data50 != @20-10-01 00:00:00.301@ then
|
|
return -1
|
|
endi
|
|
if $data51 != @156@ then
|
|
return -1
|
|
endi
|
|
if $data52 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data53 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data60 != @20-10-01 00:00:00.361@ then
|
|
return -1
|
|
endi
|
|
if $data61 != @217@ then
|
|
return -1
|
|
endi
|
|
if $data62 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data63 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data70 != @20-10-01 00:00:00.421@ then
|
|
return -1
|
|
endi
|
|
if $data71 != @288@ then
|
|
return -1
|
|
endi
|
|
if $data72 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data73 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data80 != @20-10-01 00:00:00.481@ then
|
|
return -1
|
|
endi
|
|
if $data81 != @369@ then
|
|
return -1
|
|
endi
|
|
if $data82 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data83 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data90 != @20-10-01 00:00:00.541@ then
|
|
return -1
|
|
endi
|
|
if $data91 != @460@ then
|
|
return -1
|
|
endi
|
|
if $data92 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data93 != @ct1@ then
|
|
return -1
|
|
endi
|
|
print execute sql select diff(f1),t from st group by tbname
|
|
|
|
sql select diff(f1),t from st group by tbname
|
|
|
|
if $rows != 57 then
|
|
return -1
|
|
endi
|
|
if $data00 != @20-10-01 00:00:00.061@ then
|
|
return -1
|
|
endi
|
|
if $data01 != @10@ then
|
|
return -1
|
|
endi
|
|
if $data02 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data03 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data10 != @20-10-01 00:00:00.121@ then
|
|
return -1
|
|
endi
|
|
if $data11 != @10@ then
|
|
return -1
|
|
endi
|
|
if $data12 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data13 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data20 != @20-10-01 00:00:00.181@ then
|
|
return -1
|
|
endi
|
|
if $data21 != @10@ then
|
|
return -1
|
|
endi
|
|
if $data22 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data23 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data30 != @20-10-01 00:00:00.241@ then
|
|
return -1
|
|
endi
|
|
if $data31 != @10@ then
|
|
return -1
|
|
endi
|
|
if $data32 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data33 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data40 != @20-10-01 00:00:00.301@ then
|
|
return -1
|
|
endi
|
|
if $data41 != @10@ then
|
|
return -1
|
|
endi
|
|
if $data42 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data43 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data50 != @20-10-01 00:00:00.361@ then
|
|
return -1
|
|
endi
|
|
if $data51 != @10@ then
|
|
return -1
|
|
endi
|
|
if $data52 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data53 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data60 != @20-10-01 00:00:00.421@ then
|
|
return -1
|
|
endi
|
|
if $data61 != @10@ then
|
|
return -1
|
|
endi
|
|
if $data62 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data63 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data70 != @20-10-01 00:00:00.481@ then
|
|
return -1
|
|
endi
|
|
if $data71 != @10@ then
|
|
return -1
|
|
endi
|
|
if $data72 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data73 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data80 != @20-10-01 00:00:00.541@ then
|
|
return -1
|
|
endi
|
|
if $data81 != @10@ then
|
|
return -1
|
|
endi
|
|
if $data82 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data83 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data90 != @20-10-01 00:01:40.001@ then
|
|
return -1
|
|
endi
|
|
if $data91 != @10@ then
|
|
return -1
|
|
endi
|
|
if $data92 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data93 != @ct1@ then
|
|
return -1
|
|
endi
|
|
print execute sql select derivative(f1, 1s, 0),t from st group by tbname
|
|
|
|
sql select derivative(f1, 1s, 0),t from st group by tbname
|
|
|
|
if $rows != 57 then
|
|
return -1
|
|
endi
|
|
if $data00 != @20-10-01 00:00:00.061@ then
|
|
return -1
|
|
endi
|
|
if $data01 != @166.666666667@ then
|
|
return -1
|
|
endi
|
|
if $data02 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data03 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data10 != @20-10-01 00:00:00.121@ then
|
|
return -1
|
|
endi
|
|
if $data11 != @166.666666667@ then
|
|
return -1
|
|
endi
|
|
if $data12 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data13 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data20 != @20-10-01 00:00:00.181@ then
|
|
return -1
|
|
endi
|
|
if $data21 != @166.666666667@ then
|
|
return -1
|
|
endi
|
|
if $data22 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data23 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data30 != @20-10-01 00:00:00.241@ then
|
|
return -1
|
|
endi
|
|
if $data31 != @166.666666667@ then
|
|
return -1
|
|
endi
|
|
if $data32 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data33 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data40 != @20-10-01 00:00:00.301@ then
|
|
return -1
|
|
endi
|
|
if $data41 != @166.666666667@ then
|
|
return -1
|
|
endi
|
|
if $data42 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data43 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data50 != @20-10-01 00:00:00.361@ then
|
|
return -1
|
|
endi
|
|
if $data51 != @166.666666667@ then
|
|
return -1
|
|
endi
|
|
if $data52 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data53 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data60 != @20-10-01 00:00:00.421@ then
|
|
return -1
|
|
endi
|
|
if $data61 != @166.666666667@ then
|
|
return -1
|
|
endi
|
|
if $data62 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data63 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data70 != @20-10-01 00:00:00.481@ then
|
|
return -1
|
|
endi
|
|
if $data71 != @166.666666667@ then
|
|
return -1
|
|
endi
|
|
if $data72 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data73 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data80 != @20-10-01 00:00:00.541@ then
|
|
return -1
|
|
endi
|
|
if $data81 != @166.666666667@ then
|
|
return -1
|
|
endi
|
|
if $data82 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data83 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data90 != @20-10-01 00:01:40.001@ then
|
|
return -1
|
|
endi
|
|
if $data91 != @0.100542932@ then
|
|
return -1
|
|
endi
|
|
if $data92 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data93 != @ct1@ then
|
|
return -1
|
|
endi
|
|
print execute sql select mavg(f1,2),t from st group by tbname
|
|
|
|
sql select mavg(f1,2),t from st group by tbname
|
|
|
|
if $rows != 57 then
|
|
return -1
|
|
endi
|
|
if $data00 != @20-10-01 00:00:00.061@ then
|
|
return -1
|
|
endi
|
|
if $data01 != @6.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data02 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data03 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data10 != @20-10-01 00:00:00.121@ then
|
|
return -1
|
|
endi
|
|
if $data11 != @16.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data12 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data13 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data20 != @20-10-01 00:00:00.181@ then
|
|
return -1
|
|
endi
|
|
if $data21 != @26.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data22 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data23 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data30 != @20-10-01 00:00:00.241@ then
|
|
return -1
|
|
endi
|
|
if $data31 != @36.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data32 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data33 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data40 != @20-10-01 00:00:00.301@ then
|
|
return -1
|
|
endi
|
|
if $data41 != @46.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data42 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data43 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data50 != @20-10-01 00:00:00.361@ then
|
|
return -1
|
|
endi
|
|
if $data51 != @56.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data52 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data53 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data60 != @20-10-01 00:00:00.421@ then
|
|
return -1
|
|
endi
|
|
if $data61 != @66.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data62 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data63 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data70 != @20-10-01 00:00:00.481@ then
|
|
return -1
|
|
endi
|
|
if $data71 != @76.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data72 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data73 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data80 != @20-10-01 00:00:00.541@ then
|
|
return -1
|
|
endi
|
|
if $data81 != @86.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data82 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data83 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data90 != @20-10-01 00:01:40.001@ then
|
|
return -1
|
|
endi
|
|
if $data91 != @96.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data92 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data93 != @ct1@ then
|
|
return -1
|
|
endi
|
|
print execute sql select csum(f1) from st group by tbname limit 2
|
|
|
|
sql select csum(f1) from st group by tbname limit 2
|
|
|
|
if $rows != 6 then
|
|
return -1
|
|
endi
|
|
if $data00 != @20-10-01 00:00:00.001@ then
|
|
return -1
|
|
endi
|
|
if $data01 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data02 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data10 != @20-10-01 00:00:00.061@ then
|
|
return -1
|
|
endi
|
|
if $data11 != @12@ then
|
|
return -1
|
|
endi
|
|
if $data12 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data20 != @20-10-01 00:00:00.002@ then
|
|
return -1
|
|
endi
|
|
if $data21 != @2@ then
|
|
return -1
|
|
endi
|
|
if $data22 != @ct2@ then
|
|
return -1
|
|
endi
|
|
if $data30 != @20-10-01 00:00:00.062@ then
|
|
return -1
|
|
endi
|
|
if $data31 != @14@ then
|
|
return -1
|
|
endi
|
|
if $data32 != @ct2@ then
|
|
return -1
|
|
endi
|
|
if $data40 != @20-10-01 00:00:00.003@ then
|
|
return -1
|
|
endi
|
|
if $data41 != @3@ then
|
|
return -1
|
|
endi
|
|
if $data42 != @ct3@ then
|
|
return -1
|
|
endi
|
|
if $data50 != @20-10-01 00:00:00.063@ then
|
|
return -1
|
|
endi
|
|
if $data51 != @16@ then
|
|
return -1
|
|
endi
|
|
if $data52 != @ct3@ then
|
|
return -1
|
|
endi
|
|
print execute sql select diff(f1) from st group by tbname limit 2
|
|
|
|
sql select diff(f1) from st group by tbname limit 2
|
|
|
|
if $rows != 6 then
|
|
return -1
|
|
endi
|
|
if $data00 != @20-10-01 00:00:00.061@ then
|
|
return -1
|
|
endi
|
|
if $data01 != @10@ then
|
|
return -1
|
|
endi
|
|
if $data02 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data10 != @20-10-01 00:00:00.121@ then
|
|
return -1
|
|
endi
|
|
if $data11 != @10@ then
|
|
return -1
|
|
endi
|
|
if $data12 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data20 != @20-10-01 00:00:00.062@ then
|
|
return -1
|
|
endi
|
|
if $data21 != @10@ then
|
|
return -1
|
|
endi
|
|
if $data22 != @ct2@ then
|
|
return -1
|
|
endi
|
|
if $data30 != @20-10-01 00:00:00.122@ then
|
|
return -1
|
|
endi
|
|
if $data31 != @10@ then
|
|
return -1
|
|
endi
|
|
if $data32 != @ct2@ then
|
|
return -1
|
|
endi
|
|
if $data40 != @20-10-01 00:00:00.063@ then
|
|
return -1
|
|
endi
|
|
if $data41 != @10@ then
|
|
return -1
|
|
endi
|
|
if $data42 != @ct3@ then
|
|
return -1
|
|
endi
|
|
if $data50 != @20-10-01 00:00:00.123@ then
|
|
return -1
|
|
endi
|
|
if $data51 != @10@ then
|
|
return -1
|
|
endi
|
|
if $data52 != @ct3@ then
|
|
return -1
|
|
endi
|
|
print execute sql select derivative(f1, 1s, 0) from st group by tbname limit 2
|
|
|
|
sql select derivative(f1, 1s, 0) from st group by tbname limit 2
|
|
|
|
if $rows != 6 then
|
|
return -1
|
|
endi
|
|
if $data00 != @20-10-01 00:00:00.061@ then
|
|
return -1
|
|
endi
|
|
if $data01 != @166.666666667@ then
|
|
return -1
|
|
endi
|
|
if $data02 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data10 != @20-10-01 00:00:00.121@ then
|
|
return -1
|
|
endi
|
|
if $data11 != @166.666666667@ then
|
|
return -1
|
|
endi
|
|
if $data12 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data20 != @20-10-01 00:00:00.062@ then
|
|
return -1
|
|
endi
|
|
if $data21 != @166.666666667@ then
|
|
return -1
|
|
endi
|
|
if $data22 != @ct2@ then
|
|
return -1
|
|
endi
|
|
if $data30 != @20-10-01 00:00:00.122@ then
|
|
return -1
|
|
endi
|
|
if $data31 != @166.666666667@ then
|
|
return -1
|
|
endi
|
|
if $data32 != @ct2@ then
|
|
return -1
|
|
endi
|
|
if $data40 != @20-10-01 00:00:00.063@ then
|
|
return -1
|
|
endi
|
|
if $data41 != @166.666666667@ then
|
|
return -1
|
|
endi
|
|
if $data42 != @ct3@ then
|
|
return -1
|
|
endi
|
|
if $data50 != @20-10-01 00:00:00.123@ then
|
|
return -1
|
|
endi
|
|
if $data51 != @166.666666667@ then
|
|
return -1
|
|
endi
|
|
if $data52 != @ct3@ then
|
|
return -1
|
|
endi
|
|
print execute sql select mavg(f1,2) from st group by tbname limit 2
|
|
|
|
sql select mavg(f1,2) from st group by tbname limit 2
|
|
|
|
if $rows != 6 then
|
|
return -1
|
|
endi
|
|
if $data00 != @20-10-01 00:00:00.061@ then
|
|
return -1
|
|
endi
|
|
if $data01 != @6.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data02 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data10 != @20-10-01 00:00:00.121@ then
|
|
return -1
|
|
endi
|
|
if $data11 != @16.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data12 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data20 != @20-10-01 00:00:00.062@ then
|
|
return -1
|
|
endi
|
|
if $data21 != @7.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data22 != @ct2@ then
|
|
return -1
|
|
endi
|
|
if $data30 != @20-10-01 00:00:00.122@ then
|
|
return -1
|
|
endi
|
|
if $data31 != @17.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data32 != @ct2@ then
|
|
return -1
|
|
endi
|
|
if $data40 != @20-10-01 00:00:00.063@ then
|
|
return -1
|
|
endi
|
|
if $data41 != @8.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data42 != @ct3@ then
|
|
return -1
|
|
endi
|
|
if $data50 != @20-10-01 00:00:00.123@ then
|
|
return -1
|
|
endi
|
|
if $data51 != @18.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data52 != @ct3@ then
|
|
return -1
|
|
endi
|
|
print execute sql select csum(f1),t from st group by tbname limit 2
|
|
|
|
sql select csum(f1),t from st group by tbname limit 2
|
|
|
|
if $rows != 6 then
|
|
return -1
|
|
endi
|
|
if $data00 != @20-10-01 00:00:00.001@ then
|
|
return -1
|
|
endi
|
|
if $data01 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data02 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data03 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data10 != @20-10-01 00:00:00.061@ then
|
|
return -1
|
|
endi
|
|
if $data11 != @12@ then
|
|
return -1
|
|
endi
|
|
if $data12 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data13 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data20 != @20-10-01 00:00:00.002@ then
|
|
return -1
|
|
endi
|
|
if $data21 != @2@ then
|
|
return -1
|
|
endi
|
|
if $data22 != @2@ then
|
|
return -1
|
|
endi
|
|
if $data23 != @ct2@ then
|
|
return -1
|
|
endi
|
|
if $data30 != @20-10-01 00:00:00.062@ then
|
|
return -1
|
|
endi
|
|
if $data31 != @14@ then
|
|
return -1
|
|
endi
|
|
if $data32 != @2@ then
|
|
return -1
|
|
endi
|
|
if $data33 != @ct2@ then
|
|
return -1
|
|
endi
|
|
if $data40 != @20-10-01 00:00:00.003@ then
|
|
return -1
|
|
endi
|
|
if $data41 != @3@ then
|
|
return -1
|
|
endi
|
|
if $data42 != @3@ then
|
|
return -1
|
|
endi
|
|
if $data43 != @ct3@ then
|
|
return -1
|
|
endi
|
|
if $data50 != @20-10-01 00:00:00.063@ then
|
|
return -1
|
|
endi
|
|
if $data51 != @16@ then
|
|
return -1
|
|
endi
|
|
if $data52 != @3@ then
|
|
return -1
|
|
endi
|
|
if $data53 != @ct3@ then
|
|
return -1
|
|
endi
|
|
print execute sql select diff(f1),t from st group by tbname limit 2
|
|
|
|
sql select diff(f1),t from st group by tbname limit 2
|
|
|
|
if $rows != 6 then
|
|
return -1
|
|
endi
|
|
if $data00 != @20-10-01 00:00:00.061@ then
|
|
return -1
|
|
endi
|
|
if $data01 != @10@ then
|
|
return -1
|
|
endi
|
|
if $data02 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data03 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data10 != @20-10-01 00:00:00.121@ then
|
|
return -1
|
|
endi
|
|
if $data11 != @10@ then
|
|
return -1
|
|
endi
|
|
if $data12 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data13 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data20 != @20-10-01 00:00:00.062@ then
|
|
return -1
|
|
endi
|
|
if $data21 != @10@ then
|
|
return -1
|
|
endi
|
|
if $data22 != @2@ then
|
|
return -1
|
|
endi
|
|
if $data23 != @ct2@ then
|
|
return -1
|
|
endi
|
|
if $data30 != @20-10-01 00:00:00.122@ then
|
|
return -1
|
|
endi
|
|
if $data31 != @10@ then
|
|
return -1
|
|
endi
|
|
if $data32 != @2@ then
|
|
return -1
|
|
endi
|
|
if $data33 != @ct2@ then
|
|
return -1
|
|
endi
|
|
if $data40 != @20-10-01 00:00:00.063@ then
|
|
return -1
|
|
endi
|
|
if $data41 != @10@ then
|
|
return -1
|
|
endi
|
|
if $data42 != @3@ then
|
|
return -1
|
|
endi
|
|
if $data43 != @ct3@ then
|
|
return -1
|
|
endi
|
|
if $data50 != @20-10-01 00:00:00.123@ then
|
|
return -1
|
|
endi
|
|
if $data51 != @10@ then
|
|
return -1
|
|
endi
|
|
if $data52 != @3@ then
|
|
return -1
|
|
endi
|
|
if $data53 != @ct3@ then
|
|
return -1
|
|
endi
|
|
print execute sql select derivative(f1, 1s, 0),t from st group by tbname limit 2
|
|
|
|
sql select derivative(f1, 1s, 0),t from st group by tbname limit 2
|
|
|
|
if $rows != 6 then
|
|
return -1
|
|
endi
|
|
if $data00 != @20-10-01 00:00:00.061@ then
|
|
return -1
|
|
endi
|
|
if $data01 != @166.666666667@ then
|
|
return -1
|
|
endi
|
|
if $data02 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data03 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data10 != @20-10-01 00:00:00.121@ then
|
|
return -1
|
|
endi
|
|
if $data11 != @166.666666667@ then
|
|
return -1
|
|
endi
|
|
if $data12 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data13 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data20 != @20-10-01 00:00:00.062@ then
|
|
return -1
|
|
endi
|
|
if $data21 != @166.666666667@ then
|
|
return -1
|
|
endi
|
|
if $data22 != @2@ then
|
|
return -1
|
|
endi
|
|
if $data23 != @ct2@ then
|
|
return -1
|
|
endi
|
|
if $data30 != @20-10-01 00:00:00.122@ then
|
|
return -1
|
|
endi
|
|
if $data31 != @166.666666667@ then
|
|
return -1
|
|
endi
|
|
if $data32 != @2@ then
|
|
return -1
|
|
endi
|
|
if $data33 != @ct2@ then
|
|
return -1
|
|
endi
|
|
if $data40 != @20-10-01 00:00:00.063@ then
|
|
return -1
|
|
endi
|
|
if $data41 != @166.666666667@ then
|
|
return -1
|
|
endi
|
|
if $data42 != @3@ then
|
|
return -1
|
|
endi
|
|
if $data43 != @ct3@ then
|
|
return -1
|
|
endi
|
|
if $data50 != @20-10-01 00:00:00.123@ then
|
|
return -1
|
|
endi
|
|
if $data51 != @166.666666667@ then
|
|
return -1
|
|
endi
|
|
if $data52 != @3@ then
|
|
return -1
|
|
endi
|
|
if $data53 != @ct3@ then
|
|
return -1
|
|
endi
|
|
print execute sql select mavg(f1,2),t from st group by tbname limit 2
|
|
|
|
sql select mavg(f1,2),t from st group by tbname limit 2
|
|
|
|
if $rows != 6 then
|
|
return -1
|
|
endi
|
|
if $data00 != @20-10-01 00:00:00.061@ then
|
|
return -1
|
|
endi
|
|
if $data01 != @6.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data02 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data03 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data10 != @20-10-01 00:00:00.121@ then
|
|
return -1
|
|
endi
|
|
if $data11 != @16.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data12 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data13 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data20 != @20-10-01 00:00:00.062@ then
|
|
return -1
|
|
endi
|
|
if $data21 != @7.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data22 != @2@ then
|
|
return -1
|
|
endi
|
|
if $data23 != @ct2@ then
|
|
return -1
|
|
endi
|
|
if $data30 != @20-10-01 00:00:00.122@ then
|
|
return -1
|
|
endi
|
|
if $data31 != @17.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data32 != @2@ then
|
|
return -1
|
|
endi
|
|
if $data33 != @ct2@ then
|
|
return -1
|
|
endi
|
|
if $data40 != @20-10-01 00:00:00.063@ then
|
|
return -1
|
|
endi
|
|
if $data41 != @8.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data42 != @3@ then
|
|
return -1
|
|
endi
|
|
if $data43 != @ct3@ then
|
|
return -1
|
|
endi
|
|
if $data50 != @20-10-01 00:00:00.123@ then
|
|
return -1
|
|
endi
|
|
if $data51 != @18.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data52 != @3@ then
|
|
return -1
|
|
endi
|
|
if $data53 != @ct3@ then
|
|
return -1
|
|
endi
|
|
print execute sql select csum(f1) from st group by tbname limit 2 offset 9
|
|
|
|
sql select csum(f1) from st group by tbname limit 2 offset 9
|
|
|
|
if $rows != 6 then
|
|
return -1
|
|
endi
|
|
if $data00 != @20-10-01 00:00:00.541@ then
|
|
return -1
|
|
endi
|
|
if $data01 != @460@ then
|
|
return -1
|
|
endi
|
|
if $data02 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data10 != @20-10-01 00:01:40.001@ then
|
|
return -1
|
|
endi
|
|
if $data11 != @561@ then
|
|
return -1
|
|
endi
|
|
if $data12 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data20 != @20-10-01 00:00:00.542@ then
|
|
return -1
|
|
endi
|
|
if $data21 != @470@ then
|
|
return -1
|
|
endi
|
|
if $data22 != @ct2@ then
|
|
return -1
|
|
endi
|
|
if $data30 != @20-10-01 00:01:40.002@ then
|
|
return -1
|
|
endi
|
|
if $data31 != @572@ then
|
|
return -1
|
|
endi
|
|
if $data32 != @ct2@ then
|
|
return -1
|
|
endi
|
|
if $data40 != @20-10-01 00:00:00.543@ then
|
|
return -1
|
|
endi
|
|
if $data41 != @480@ then
|
|
return -1
|
|
endi
|
|
if $data42 != @ct3@ then
|
|
return -1
|
|
endi
|
|
if $data50 != @20-10-01 00:01:40.003@ then
|
|
return -1
|
|
endi
|
|
if $data51 != @583@ then
|
|
return -1
|
|
endi
|
|
if $data52 != @ct3@ then
|
|
return -1
|
|
endi
|
|
print execute sql select diff(f1) from st group by tbname limit 2 offset 9
|
|
|
|
sql select diff(f1) from st group by tbname limit 2 offset 9
|
|
|
|
if $rows != 6 then
|
|
return -1
|
|
endi
|
|
if $data00 != @20-10-01 00:01:40.001@ then
|
|
return -1
|
|
endi
|
|
if $data01 != @10@ then
|
|
return -1
|
|
endi
|
|
if $data02 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data10 != @20-10-01 00:01:40.061@ then
|
|
return -1
|
|
endi
|
|
if $data11 != @10@ then
|
|
return -1
|
|
endi
|
|
if $data12 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data20 != @20-10-01 00:01:40.002@ then
|
|
return -1
|
|
endi
|
|
if $data21 != @10@ then
|
|
return -1
|
|
endi
|
|
if $data22 != @ct2@ then
|
|
return -1
|
|
endi
|
|
if $data30 != @20-10-01 00:01:40.062@ then
|
|
return -1
|
|
endi
|
|
if $data31 != @10@ then
|
|
return -1
|
|
endi
|
|
if $data32 != @ct2@ then
|
|
return -1
|
|
endi
|
|
if $data40 != @20-10-01 00:01:40.003@ then
|
|
return -1
|
|
endi
|
|
if $data41 != @10@ then
|
|
return -1
|
|
endi
|
|
if $data42 != @ct3@ then
|
|
return -1
|
|
endi
|
|
if $data50 != @20-10-01 00:01:40.063@ then
|
|
return -1
|
|
endi
|
|
if $data51 != @10@ then
|
|
return -1
|
|
endi
|
|
if $data52 != @ct3@ then
|
|
return -1
|
|
endi
|
|
print execute sql select derivative(f1, 1s, 0) from st group by tbname limit 2 offset 9
|
|
|
|
sql select derivative(f1, 1s, 0) from st group by tbname limit 2 offset 9
|
|
|
|
if $rows != 6 then
|
|
return -1
|
|
endi
|
|
if $data00 != @20-10-01 00:01:40.001@ then
|
|
return -1
|
|
endi
|
|
if $data01 != @0.100542932@ then
|
|
return -1
|
|
endi
|
|
if $data02 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data10 != @20-10-01 00:01:40.061@ then
|
|
return -1
|
|
endi
|
|
if $data11 != @166.666666667@ then
|
|
return -1
|
|
endi
|
|
if $data12 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data20 != @20-10-01 00:01:40.002@ then
|
|
return -1
|
|
endi
|
|
if $data21 != @0.100542932@ then
|
|
return -1
|
|
endi
|
|
if $data22 != @ct2@ then
|
|
return -1
|
|
endi
|
|
if $data30 != @20-10-01 00:01:40.062@ then
|
|
return -1
|
|
endi
|
|
if $data31 != @166.666666667@ then
|
|
return -1
|
|
endi
|
|
if $data32 != @ct2@ then
|
|
return -1
|
|
endi
|
|
if $data40 != @20-10-01 00:01:40.003@ then
|
|
return -1
|
|
endi
|
|
if $data41 != @0.100542932@ then
|
|
return -1
|
|
endi
|
|
if $data42 != @ct3@ then
|
|
return -1
|
|
endi
|
|
if $data50 != @20-10-01 00:01:40.063@ then
|
|
return -1
|
|
endi
|
|
if $data51 != @166.666666667@ then
|
|
return -1
|
|
endi
|
|
if $data52 != @ct3@ then
|
|
return -1
|
|
endi
|
|
print execute sql select mavg(f1,2) from st group by tbname limit 2 offset 9
|
|
|
|
sql select mavg(f1,2) from st group by tbname limit 2 offset 9
|
|
|
|
if $rows != 6 then
|
|
return -1
|
|
endi
|
|
if $data00 != @20-10-01 00:01:40.001@ then
|
|
return -1
|
|
endi
|
|
if $data01 != @96.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data02 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data10 != @20-10-01 00:01:40.061@ then
|
|
return -1
|
|
endi
|
|
if $data11 != @106.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data12 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data20 != @20-10-01 00:01:40.002@ then
|
|
return -1
|
|
endi
|
|
if $data21 != @97.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data22 != @ct2@ then
|
|
return -1
|
|
endi
|
|
if $data30 != @20-10-01 00:01:40.062@ then
|
|
return -1
|
|
endi
|
|
if $data31 != @107.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data32 != @ct2@ then
|
|
return -1
|
|
endi
|
|
if $data40 != @20-10-01 00:01:40.003@ then
|
|
return -1
|
|
endi
|
|
if $data41 != @98.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data42 != @ct3@ then
|
|
return -1
|
|
endi
|
|
if $data50 != @20-10-01 00:01:40.063@ then
|
|
return -1
|
|
endi
|
|
if $data51 != @108.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data52 != @ct3@ then
|
|
return -1
|
|
endi
|
|
print execute sql select csum(f1),t from st group by tbname limit 2 offset 9
|
|
|
|
sql select csum(f1),t from st group by tbname limit 2 offset 9
|
|
|
|
if $rows != 6 then
|
|
return -1
|
|
endi
|
|
if $data00 != @20-10-01 00:00:00.541@ then
|
|
return -1
|
|
endi
|
|
if $data01 != @460@ then
|
|
return -1
|
|
endi
|
|
if $data02 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data03 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data10 != @20-10-01 00:01:40.001@ then
|
|
return -1
|
|
endi
|
|
if $data11 != @561@ then
|
|
return -1
|
|
endi
|
|
if $data12 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data13 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data20 != @20-10-01 00:00:00.542@ then
|
|
return -1
|
|
endi
|
|
if $data21 != @470@ then
|
|
return -1
|
|
endi
|
|
if $data22 != @2@ then
|
|
return -1
|
|
endi
|
|
if $data23 != @ct2@ then
|
|
return -1
|
|
endi
|
|
if $data30 != @20-10-01 00:01:40.002@ then
|
|
return -1
|
|
endi
|
|
if $data31 != @572@ then
|
|
return -1
|
|
endi
|
|
if $data32 != @2@ then
|
|
return -1
|
|
endi
|
|
if $data33 != @ct2@ then
|
|
return -1
|
|
endi
|
|
if $data40 != @20-10-01 00:00:00.543@ then
|
|
return -1
|
|
endi
|
|
if $data41 != @480@ then
|
|
return -1
|
|
endi
|
|
if $data42 != @3@ then
|
|
return -1
|
|
endi
|
|
if $data43 != @ct3@ then
|
|
return -1
|
|
endi
|
|
if $data50 != @20-10-01 00:01:40.003@ then
|
|
return -1
|
|
endi
|
|
if $data51 != @583@ then
|
|
return -1
|
|
endi
|
|
if $data52 != @3@ then
|
|
return -1
|
|
endi
|
|
if $data53 != @ct3@ then
|
|
return -1
|
|
endi
|
|
print execute sql select diff(f1),t from st group by tbname limit 2 offset 9
|
|
|
|
sql select diff(f1),t from st group by tbname limit 2 offset 9
|
|
|
|
if $rows != 6 then
|
|
return -1
|
|
endi
|
|
if $data00 != @20-10-01 00:01:40.001@ then
|
|
return -1
|
|
endi
|
|
if $data01 != @10@ then
|
|
return -1
|
|
endi
|
|
if $data02 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data03 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data10 != @20-10-01 00:01:40.061@ then
|
|
return -1
|
|
endi
|
|
if $data11 != @10@ then
|
|
return -1
|
|
endi
|
|
if $data12 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data13 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data20 != @20-10-01 00:01:40.002@ then
|
|
return -1
|
|
endi
|
|
if $data21 != @10@ then
|
|
return -1
|
|
endi
|
|
if $data22 != @2@ then
|
|
return -1
|
|
endi
|
|
if $data23 != @ct2@ then
|
|
return -1
|
|
endi
|
|
if $data30 != @20-10-01 00:01:40.062@ then
|
|
return -1
|
|
endi
|
|
if $data31 != @10@ then
|
|
return -1
|
|
endi
|
|
if $data32 != @2@ then
|
|
return -1
|
|
endi
|
|
if $data33 != @ct2@ then
|
|
return -1
|
|
endi
|
|
if $data40 != @20-10-01 00:01:40.003@ then
|
|
return -1
|
|
endi
|
|
if $data41 != @10@ then
|
|
return -1
|
|
endi
|
|
if $data42 != @3@ then
|
|
return -1
|
|
endi
|
|
if $data43 != @ct3@ then
|
|
return -1
|
|
endi
|
|
if $data50 != @20-10-01 00:01:40.063@ then
|
|
return -1
|
|
endi
|
|
if $data51 != @10@ then
|
|
return -1
|
|
endi
|
|
if $data52 != @3@ then
|
|
return -1
|
|
endi
|
|
if $data53 != @ct3@ then
|
|
return -1
|
|
endi
|
|
print execute sql select derivative(f1, 1s, 0),t from st group by tbname limit 2 offset 9
|
|
|
|
sql select derivative(f1, 1s, 0),t from st group by tbname limit 2 offset 9
|
|
|
|
if $rows != 6 then
|
|
return -1
|
|
endi
|
|
if $data00 != @20-10-01 00:01:40.001@ then
|
|
return -1
|
|
endi
|
|
if $data01 != @0.100542932@ then
|
|
return -1
|
|
endi
|
|
if $data02 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data03 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data10 != @20-10-01 00:01:40.061@ then
|
|
return -1
|
|
endi
|
|
if $data11 != @166.666666667@ then
|
|
return -1
|
|
endi
|
|
if $data12 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data13 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data20 != @20-10-01 00:01:40.002@ then
|
|
return -1
|
|
endi
|
|
if $data21 != @0.100542932@ then
|
|
return -1
|
|
endi
|
|
if $data22 != @2@ then
|
|
return -1
|
|
endi
|
|
if $data23 != @ct2@ then
|
|
return -1
|
|
endi
|
|
if $data30 != @20-10-01 00:01:40.062@ then
|
|
return -1
|
|
endi
|
|
if $data31 != @166.666666667@ then
|
|
return -1
|
|
endi
|
|
if $data32 != @2@ then
|
|
return -1
|
|
endi
|
|
if $data33 != @ct2@ then
|
|
return -1
|
|
endi
|
|
if $data40 != @20-10-01 00:01:40.003@ then
|
|
return -1
|
|
endi
|
|
if $data41 != @0.100542932@ then
|
|
return -1
|
|
endi
|
|
if $data42 != @3@ then
|
|
return -1
|
|
endi
|
|
if $data43 != @ct3@ then
|
|
return -1
|
|
endi
|
|
if $data50 != @20-10-01 00:01:40.063@ then
|
|
return -1
|
|
endi
|
|
if $data51 != @166.666666667@ then
|
|
return -1
|
|
endi
|
|
if $data52 != @3@ then
|
|
return -1
|
|
endi
|
|
if $data53 != @ct3@ then
|
|
return -1
|
|
endi
|
|
print execute sql select mavg(f1,2),t from st group by tbname limit 2 offset 9
|
|
|
|
sql select mavg(f1,2),t from st group by tbname limit 2 offset 9
|
|
|
|
if $rows != 6 then
|
|
return -1
|
|
endi
|
|
if $data00 != @20-10-01 00:01:40.001@ then
|
|
return -1
|
|
endi
|
|
if $data01 != @96.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data02 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data03 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data10 != @20-10-01 00:01:40.061@ then
|
|
return -1
|
|
endi
|
|
if $data11 != @106.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data12 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data13 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data20 != @20-10-01 00:01:40.002@ then
|
|
return -1
|
|
endi
|
|
if $data21 != @97.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data22 != @2@ then
|
|
return -1
|
|
endi
|
|
if $data23 != @ct2@ then
|
|
return -1
|
|
endi
|
|
if $data30 != @20-10-01 00:01:40.062@ then
|
|
return -1
|
|
endi
|
|
if $data31 != @107.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data32 != @2@ then
|
|
return -1
|
|
endi
|
|
if $data33 != @ct2@ then
|
|
return -1
|
|
endi
|
|
if $data40 != @20-10-01 00:01:40.003@ then
|
|
return -1
|
|
endi
|
|
if $data41 != @98.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data42 != @3@ then
|
|
return -1
|
|
endi
|
|
if $data43 != @ct3@ then
|
|
return -1
|
|
endi
|
|
if $data50 != @20-10-01 00:01:40.063@ then
|
|
return -1
|
|
endi
|
|
if $data51 != @108.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data52 != @3@ then
|
|
return -1
|
|
endi
|
|
if $data53 != @ct3@ then
|
|
return -1
|
|
endi
|
|
print execute sql select csum(f1),t,tbname from st group by tbname limit 2 offset 9
|
|
|
|
sql select csum(f1),t,tbname from st group by tbname limit 2 offset 9
|
|
|
|
if $rows != 6 then
|
|
return -1
|
|
endi
|
|
if $data00 != @20-10-01 00:00:00.541@ then
|
|
return -1
|
|
endi
|
|
if $data01 != @460@ then
|
|
return -1
|
|
endi
|
|
if $data02 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data03 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data04 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data10 != @20-10-01 00:01:40.001@ then
|
|
return -1
|
|
endi
|
|
if $data11 != @561@ then
|
|
return -1
|
|
endi
|
|
if $data12 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data13 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data14 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data20 != @20-10-01 00:00:00.542@ then
|
|
return -1
|
|
endi
|
|
if $data21 != @470@ then
|
|
return -1
|
|
endi
|
|
if $data22 != @2@ then
|
|
return -1
|
|
endi
|
|
if $data23 != @ct2@ then
|
|
return -1
|
|
endi
|
|
if $data24 != @ct2@ then
|
|
return -1
|
|
endi
|
|
if $data30 != @20-10-01 00:01:40.002@ then
|
|
return -1
|
|
endi
|
|
if $data31 != @572@ then
|
|
return -1
|
|
endi
|
|
if $data32 != @2@ then
|
|
return -1
|
|
endi
|
|
if $data33 != @ct2@ then
|
|
return -1
|
|
endi
|
|
if $data34 != @ct2@ then
|
|
return -1
|
|
endi
|
|
if $data40 != @20-10-01 00:00:00.543@ then
|
|
return -1
|
|
endi
|
|
if $data41 != @480@ then
|
|
return -1
|
|
endi
|
|
if $data42 != @3@ then
|
|
return -1
|
|
endi
|
|
if $data43 != @ct3@ then
|
|
return -1
|
|
endi
|
|
if $data44 != @ct3@ then
|
|
return -1
|
|
endi
|
|
if $data50 != @20-10-01 00:01:40.003@ then
|
|
return -1
|
|
endi
|
|
if $data51 != @583@ then
|
|
return -1
|
|
endi
|
|
if $data52 != @3@ then
|
|
return -1
|
|
endi
|
|
if $data53 != @ct3@ then
|
|
return -1
|
|
endi
|
|
if $data54 != @ct3@ then
|
|
return -1
|
|
endi
|
|
print execute sql select diff(f1),t,tbname from st group by tbname limit 2 offset 9
|
|
|
|
sql select diff(f1),t,tbname from st group by tbname limit 2 offset 9
|
|
|
|
if $rows != 6 then
|
|
return -1
|
|
endi
|
|
if $data00 != @20-10-01 00:01:40.001@ then
|
|
return -1
|
|
endi
|
|
if $data01 != @10@ then
|
|
return -1
|
|
endi
|
|
if $data02 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data03 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data04 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data10 != @20-10-01 00:01:40.061@ then
|
|
return -1
|
|
endi
|
|
if $data11 != @10@ then
|
|
return -1
|
|
endi
|
|
if $data12 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data13 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data14 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data20 != @20-10-01 00:01:40.002@ then
|
|
return -1
|
|
endi
|
|
if $data21 != @10@ then
|
|
return -1
|
|
endi
|
|
if $data22 != @2@ then
|
|
return -1
|
|
endi
|
|
if $data23 != @ct2@ then
|
|
return -1
|
|
endi
|
|
if $data24 != @ct2@ then
|
|
return -1
|
|
endi
|
|
if $data30 != @20-10-01 00:01:40.062@ then
|
|
return -1
|
|
endi
|
|
if $data31 != @10@ then
|
|
return -1
|
|
endi
|
|
if $data32 != @2@ then
|
|
return -1
|
|
endi
|
|
if $data33 != @ct2@ then
|
|
return -1
|
|
endi
|
|
if $data34 != @ct2@ then
|
|
return -1
|
|
endi
|
|
if $data40 != @20-10-01 00:01:40.003@ then
|
|
return -1
|
|
endi
|
|
if $data41 != @10@ then
|
|
return -1
|
|
endi
|
|
if $data42 != @3@ then
|
|
return -1
|
|
endi
|
|
if $data43 != @ct3@ then
|
|
return -1
|
|
endi
|
|
if $data44 != @ct3@ then
|
|
return -1
|
|
endi
|
|
if $data50 != @20-10-01 00:01:40.063@ then
|
|
return -1
|
|
endi
|
|
if $data51 != @10@ then
|
|
return -1
|
|
endi
|
|
if $data52 != @3@ then
|
|
return -1
|
|
endi
|
|
if $data53 != @ct3@ then
|
|
return -1
|
|
endi
|
|
if $data54 != @ct3@ then
|
|
return -1
|
|
endi
|
|
print execute sql select derivative(f1, 1s, 0),t,tbname from st group by tbname limit 2 offset 9
|
|
|
|
sql select derivative(f1, 1s, 0),t,tbname from st group by tbname limit 2 offset 9
|
|
|
|
if $rows != 6 then
|
|
return -1
|
|
endi
|
|
if $data00 != @20-10-01 00:01:40.001@ then
|
|
return -1
|
|
endi
|
|
if $data01 != @0.100542932@ then
|
|
return -1
|
|
endi
|
|
if $data02 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data03 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data04 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data10 != @20-10-01 00:01:40.061@ then
|
|
return -1
|
|
endi
|
|
if $data11 != @166.666666667@ then
|
|
return -1
|
|
endi
|
|
if $data12 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data13 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data14 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data20 != @20-10-01 00:01:40.002@ then
|
|
return -1
|
|
endi
|
|
if $data21 != @0.100542932@ then
|
|
return -1
|
|
endi
|
|
if $data22 != @2@ then
|
|
return -1
|
|
endi
|
|
if $data23 != @ct2@ then
|
|
return -1
|
|
endi
|
|
if $data24 != @ct2@ then
|
|
return -1
|
|
endi
|
|
if $data30 != @20-10-01 00:01:40.062@ then
|
|
return -1
|
|
endi
|
|
if $data31 != @166.666666667@ then
|
|
return -1
|
|
endi
|
|
if $data32 != @2@ then
|
|
return -1
|
|
endi
|
|
if $data33 != @ct2@ then
|
|
return -1
|
|
endi
|
|
if $data34 != @ct2@ then
|
|
return -1
|
|
endi
|
|
if $data40 != @20-10-01 00:01:40.003@ then
|
|
return -1
|
|
endi
|
|
if $data41 != @0.100542932@ then
|
|
return -1
|
|
endi
|
|
if $data42 != @3@ then
|
|
return -1
|
|
endi
|
|
if $data43 != @ct3@ then
|
|
return -1
|
|
endi
|
|
if $data44 != @ct3@ then
|
|
return -1
|
|
endi
|
|
if $data50 != @20-10-01 00:01:40.063@ then
|
|
return -1
|
|
endi
|
|
if $data51 != @166.666666667@ then
|
|
return -1
|
|
endi
|
|
if $data52 != @3@ then
|
|
return -1
|
|
endi
|
|
if $data53 != @ct3@ then
|
|
return -1
|
|
endi
|
|
if $data54 != @ct3@ then
|
|
return -1
|
|
endi
|
|
print execute sql select mavg(f1,2),t,tbname from st group by tbname limit 2 offset 9
|
|
|
|
sql select mavg(f1,2),t,tbname from st group by tbname limit 2 offset 9
|
|
|
|
if $rows != 6 then
|
|
return -1
|
|
endi
|
|
if $data00 != @20-10-01 00:01:40.001@ then
|
|
return -1
|
|
endi
|
|
if $data01 != @96.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data02 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data03 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data04 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data10 != @20-10-01 00:01:40.061@ then
|
|
return -1
|
|
endi
|
|
if $data11 != @106.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data12 != @1@ then
|
|
return -1
|
|
endi
|
|
if $data13 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data14 != @ct1@ then
|
|
return -1
|
|
endi
|
|
if $data20 != @20-10-01 00:01:40.002@ then
|
|
return -1
|
|
endi
|
|
if $data21 != @97.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data22 != @2@ then
|
|
return -1
|
|
endi
|
|
if $data23 != @ct2@ then
|
|
return -1
|
|
endi
|
|
if $data24 != @ct2@ then
|
|
return -1
|
|
endi
|
|
if $data30 != @20-10-01 00:01:40.062@ then
|
|
return -1
|
|
endi
|
|
if $data31 != @107.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data32 != @2@ then
|
|
return -1
|
|
endi
|
|
if $data33 != @ct2@ then
|
|
return -1
|
|
endi
|
|
if $data34 != @ct2@ then
|
|
return -1
|
|
endi
|
|
if $data40 != @20-10-01 00:01:40.003@ then
|
|
return -1
|
|
endi
|
|
if $data41 != @98.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data42 != @3@ then
|
|
return -1
|
|
endi
|
|
if $data43 != @ct3@ then
|
|
return -1
|
|
endi
|
|
if $data44 != @ct3@ then
|
|
return -1
|
|
endi
|
|
if $data50 != @20-10-01 00:01:40.063@ then
|
|
return -1
|
|
endi
|
|
if $data51 != @108.000000000@ then
|
|
return -1
|
|
endi
|
|
if $data52 != @3@ then
|
|
return -1
|
|
endi
|
|
if $data53 != @ct3@ then
|
|
return -1
|
|
endi
|
|
if $data54 != @ct3@ then
|
|
return -1
|
|
endi
|
|
print ================================ clear
|
|
#sql drop database $db
|
|
#sql show databases
|
|
#if $rows != 0 then
|
|
# return -1
|
|
#endi
|
|
|
|
#system sh/exec.sh -n dnode1 -s stop -x SIGINT
|
|
|