Elgato_dark/TDengine
1
0
Fork 0
mirror of https://github.com/taosdata/TDengine synced 2026-05-24 10:09:01 +00:00
Code Issues Projects Releases Packages Wiki Activity Actions 4
TDengine/tests/script/general/parser/interp_full_test3.sim
Shuduo Sang d69c5977db
Test/sangshuduo/td 13408 move tests in (#10589) 
* 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>
2022-03-07 17:59:24 +08:00

2401 lines
48 KiB
Text
Raw Permalink Blame History

sleep 100
sql connect
sql use db;
sql SELECT tbname,INTERP(c1),t1,interp(c2),t2,interp(c3) FROM stb1 every(4s) group by tbname ORDER BY ts DESC;
if $rows != 5 then
return -1
endi
if $data00 != @21-10-20 10:00:00.000@ then
return -1
endi
if $data01 != tb1 then
return -1
endi
if $data02 != 0 then
return -1
endi
if $data03 != 1 then
return -1
endi
if $data04 != 0.00000 then
return -1
endi
if $data05 != 1 then
return -1
endi
if $data06 != 0 then
return -1
endi
if $data07 != tb1 then
return -1
endi
if $data30 != @21-10-20 10:00:00.000@ then
return -1
endi
if $data31 != tb2 then
return -1
endi
if $data32 != 0 then
return -1
endi
if $data33 != 2 then
return -1
endi
if $data34 != 0.00000 then
return -1
endi
if $data35 != 2 then
return -1
endi
if $data36 != 0 then
return -1
endi
if $data37 != tb2 then
return -1
endi
if $data20 != @21-10-20 10:00:04.000@ then
return -1
endi
if $data21 != tb2 then
return -1
endi
if $data22 != 4 then
return -1
endi
if $data23 != 2 then
return -1
endi
if $data24 != 4.00000 then
return -1
endi
if $data25 != 2 then
return -1
endi
if $data26 != 4 then
return -1
endi
if $data27 != tb2 then
return -1
endi
if $data10 != @21-10-20 10:00:12.000@ then
return -1
endi
if $data11 != tb2 then
return -1
endi
if $data12 != 12 then
return -1
endi
if $data13 != 2 then
return -1
endi
if $data14 != 12.00000 then
return -1
endi
if $data15 != 2 then
return -1
endi
if $data16 != 12 then
return -1
endi
if $data17 != tb2 then
return -1
endi
if $data40 != @21-10-20 10:00:00.000@ then
return -1
endi
if $data41 != tb3 then
return -1
endi
if $data42 != 0 then
return -1
endi
if $data43 != 3 then
return -1
endi
if $data44 != 0.00000 then
return -1
endi
if $data45 != 3 then
return -1
endi
if $data46 != 0 then
return -1
endi
if $data47 != tb3 then
return -1
endi
sql SELECT INTERP(c1) FROM stb1 range('2021-10-20 10:00:00.000','2021-10-20 10:00:40.000') every(1s) fill(linear) group by tbname ORDER BY ts DESC;
if $rows != 59 then
return -1
endi
if $data00 != @21-10-20 10:00:21.000@ then
return -1
endi
if $data01 != 21 then
return -1
endi
if $data02 != tb1 then
return -1
endi
if $data10 != @21-10-20 10:00:20.000@ then
return -1
endi
if $data11 != 20 then
return -1
endi
if $data12 != tb1 then
return -1
endi
if $data20 != @21-10-20 10:00:19.000@ then
return -1
endi
if $data21 != 19 then
return -1
endi
if $data22 != tb1 then
return -1
endi
if $data30 != @21-10-20 10:00:18.000@ then
return -1
endi
if $data31 != 18 then
return -1
endi
if $data32 != tb1 then
return -1
endi
if $data40 != @21-10-20 10:00:17.000@ then
return -1
endi
if $data41 != 17 then
return -1
endi
if $data42 != tb1 then
return -1
endi
if $data50 != @21-10-20 10:00:16.000@ then
return -1
endi
if $data51 != 16 then
return -1
endi
if $data52 != tb1 then
return -1
endi
if $data60 != @21-10-20 10:00:15.000@ then
return -1
endi
if $data61 != 15 then
return -1
endi
if $data62 != tb1 then
return -1
endi
if $data70 != @21-10-20 10:00:14.000@ then
return -1
endi
if $data71 != 14 then
return -1
endi
if $data72 != tb1 then
return -1
endi
if $data80 != @21-10-20 10:00:13.000@ then
return -1
endi
if $data81 != 13 then
return -1
endi
if $data82 != tb1 then
return -1
endi
if $data90 != @21-10-20 10:00:12.000@ then
return -1
endi
if $data91 != 12 then
return -1
endi
if $data92 != tb1 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 09:00:00','2021-10-20 14:00:00') ORDER BY ts DESC;
if $rows != 0 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 09:00:00','2021-10-20 09:00:01') ORDER BY ts DESC;
if $rows != 0 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 10:00:00','2021-10-20 14:00:00') ORDER BY ts DESC;
if $rows != 1 then
return -1
endi
if $data00 != @21-10-20 10:00:00.000@ then
return -1
endi
if $data01 != 0 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 10:00:04','2021-10-20 14:00:00') ORDER BY ts DESC;
if $rows != 0 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 11:00:00','2021-10-20 14:00:00') ORDER BY ts DESC;
if $rows != 0 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 FILL(LINEAR) ORDER BY ts DESC;
if $rows != 1 then
return -1
endi
if $data00 != @21-10-20 10:00:00.000@ then
return -1
endi
if $data01 != 0 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 FILL(NEXT) ORDER BY ts DESC;
if $rows != 1 then
return -1
endi
if $data00 != @21-10-20 10:00:00.000@ then
return -1
endi
if $data01 != 0 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 FILL(PREV) ORDER BY ts DESC;
if $rows != 1 then
return -1
endi
if $data00 != @21-10-20 10:00:00.000@ then
return -1
endi
if $data01 != 0 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 FILL(VALUE, 100) ORDER BY ts DESC;
if $rows != 1 then
return -1
endi
if $data00 != @21-10-20 10:00:00.000@ then
return -1
endi
if $data01 != 0 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 FILL(NULL) ORDER BY ts DESC;
if $rows != 1 then
return -1
endi
if $data00 != @21-10-20 10:00:00.000@ then
return -1
endi
if $data01 != 0 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 every(1s) ORDER BY ts DESC;
if $rows != 7 then
return -1
endi
if $data60 != @21-10-20 10:00:00.000@ then
return -1
endi
if $data61 != 0 then
return -1
endi
if $data50 != @21-10-20 10:00:01.000@ then
return -1
endi
if $data51 != 1 then
return -1
endi
if $data40 != @21-10-20 10:00:03.000@ then
return -1
endi
if $data41 != 3 then
return -1
endi
if $data30 != @21-10-20 10:00:06.000@ then
return -1
endi
if $data31 != 6 then
return -1
endi
if $data20 != @21-10-20 10:00:10.000@ then
return -1
endi
if $data21 != 10 then
return -1
endi
if $data10 != @21-10-20 10:00:15.000@ then
return -1
endi
if $data11 != 15 then
return -1
endi
if $data00 != @21-10-20 10:00:21.000@ then
return -1
endi
if $data01 != 21 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 every(2s) ORDER BY ts DESC;
if $rows != 3 then
return -1
endi
if $data20 != @21-10-20 10:00:00.000@ then
return -1
endi
if $data21 != 0 then
return -1
endi
if $data10 != @21-10-20 10:00:06.000@ then
return -1
endi
if $data11 != 6 then
return -1
endi
if $data00 != @21-10-20 10:00:10.000@ then
return -1
endi
if $data01 != 10 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 every(5s) ORDER BY ts DESC;
if $rows != 3 then
return -1
endi
if $data20 != @21-10-20 10:00:00.000@ then
return -1
endi
if $data21 != 0 then
return -1
endi
if $data10 != @21-10-20 10:00:10.000@ then
return -1
endi
if $data11 != 10 then
return -1
endi
if $data00 != @21-10-20 10:00:15.000@ then
return -1
endi
if $data01 != 15 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 every(100s) ORDER BY ts DESC;
if $rows != 1 then
return -1
endi
if $data00 != @21-10-20 10:00:00.000@ then
return -1
endi
if $data01 != 0 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 09:00:00','2021-10-20 14:00:00') FILL(LINEAR) ORDER BY ts DESC;
if $rows != 0 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 09:00:00','2021-10-20 09:00:01') FILL(LINEAR) ORDER BY ts DESC;
if $rows != 0 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 10:00:00','2021-10-20 10:00:00') FILL(LINEAR) ORDER BY ts DESC;
if $rows != 1 then
return -1
endi
if $data00 != @21-10-20 10:00:00.000@ then
return -1
endi
if $data01 != 0 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 10:00:04','2021-10-20 14:00:00') FILL(LINEAR) ORDER BY ts DESC;
if $rows != 1 then
return -1
endi
if $data00 != @21-10-20 10:00:04.000@ then
return -1
endi
if $data01 != 4 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 11:00:00','2021-10-20 14:00:00') FILL(LINEAR) ORDER BY ts DESC;
if $rows != 0 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 09:00:00','2021-10-20 14:00:00') FILL(NEXT) ORDER BY ts DESC;
if $rows != 1 then
return -1
endi
if $data00 != @21-10-20 09:00:00.000@ then
return -1
endi
if $data01 != 0 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 09:00:00','2021-10-20 09:00:01') FILL(NEXT) ORDER BY ts DESC;
if $rows != 1 then
return -1
endi
if $data00 != @21-10-20 09:00:00.000@ then
return -1
endi
if $data01 != 0 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 10:00:00','2021-10-20 12:00:00') FILL(NEXT) ORDER BY ts DESC;
if $rows != 1 then
return -1
endi
if $data00 != @21-10-20 10:00:00.000@ then
return -1
endi
if $data01 != 0 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 10:00:04','2021-10-20 14:00:00') FILL(NEXT) ORDER BY ts DESC;
if $rows != 1 then
return -1
endi
if $data00 != @21-10-20 10:00:04.000@ then
return -1
endi
if $data01 != 6 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 11:00:00','2021-10-20 14:00:00') FILL(NEXT) ORDER BY ts DESC;
if $rows != 0 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 09:00:00','2021-10-20 14:00:00') FILL(PREV) ORDER BY ts DESC;
if $rows != 0 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 09:00:00','2021-10-20 09:00:01') FILL(PREV) ORDER BY ts DESC;
if $rows != 0 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 10:00:00','2021-10-20 12:00:00') FILL(PREV) ORDER BY ts DESC;
if $rows != 1 then
return -1
endi
if $data00 != @21-10-20 10:00:00.000@ then
return -1
endi
if $data01 != 0 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 10:00:04','2021-10-20 14:00:00') FILL(PREV) ORDER BY ts DESC;
if $rows != 1 then
return -1
endi
if $data00 != @21-10-20 10:00:04.000@ then
return -1
endi
if $data01 != 3 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 11:00:00','2021-10-20 14:00:00') FILL(PREV) ORDER BY ts DESC;
if $rows != 1 then
return -1
endi
if $data00 != @21-10-20 11:00:00.000@ then
return -1
endi
if $data01 != 21 then
return -1
endi
sql SELECT INTERP(c2) FROM tb1 RANGE('2021-10-20 09:00:00','2021-10-20 14:00:00') FILL(VALUE,100) ORDER BY ts DESC;
if $rows != 1 then
return -1
endi
if $data00 != @21-10-20 09:00:00.000@ then
return -1
endi
if $data01 != 100.00000 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 09:00:00','2021-10-20 09:00:01') FILL(VALUE,100) ORDER BY ts DESC;
if $rows != 1 then
return -1
endi
if $data00 != @21-10-20 09:00:00.000@ then
return -1
endi
if $data01 != 100 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 10:00:00','2021-10-20 12:00:00') FILL(VALUE,100) ORDER BY ts DESC;
if $rows != 1 then
return -1
endi
if $data00 != @21-10-20 10:00:00.000@ then
return -1
endi
if $data01 != 0 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 10:00:04','2021-10-20 14:00:00') FILL(VALUE,100) ORDER BY ts DESC;
if $rows != 1 then
return -1
endi
if $data00 != @21-10-20 10:00:04.000@ then
return -1
endi
if $data01 != 100 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 11:00:00','2021-10-20 14:00:00') FILL(VALUE,100) ORDER BY ts DESC;
if $rows != 1 then
return -1
endi
if $data00 != @21-10-20 11:00:00.000@ then
return -1
endi
if $data01 != 100 then
return -1
endi
sql SELECT INTERP(c2) FROM tb1 RANGE('2021-10-20 09:00:00','2021-10-20 14:00:00') FILL(NULL) ORDER BY ts DESC;
if $rows != 1 then
return -1
endi
if $data00 != @21-10-20 09:00:00.000@ then
return -1
endi
if $data01 != NULL then
return -1
endi
sql SELECT INTERP(c2) FROM tb1 RANGE('2021-10-20 09:00:00','2021-10-20 09:00:01') FILL(NULL) ORDER BY ts DESC;
if $rows != 1 then
return -1
endi
if $data00 != @21-10-20 09:00:00.000@ then
return -1
endi
if $data01 != NULL then
return -1
endi
sql SELECT INTERP(c2) FROM tb1 RANGE('2021-10-20 10:00:00','2021-10-20 12:00:00') FILL(NULL) ORDER BY ts DESC;
if $rows != 1 then
return -1
endi
if $data00 != @21-10-20 10:00:00.000@ then
return -1
endi
if $data01 != 0.00000 then
return -1
endi
sql SELECT INTERP(c2) FROM tb1 RANGE('2021-10-20 10:00:04','2021-10-20 14:00:00') FILL(NULL) ORDER BY ts DESC;
if $rows != 1 then
return -1
endi
if $data00 != @21-10-20 10:00:04.000@ then
return -1
endi
if $data01 != NULL then
return -1
endi
sql SELECT INTERP(c2) FROM tb1 RANGE('2021-10-20 11:00:00','2021-10-20 14:00:00') FILL(NULL) ORDER BY ts DESC;
if $rows != 1 then
return -1
endi
if $data00 != @21-10-20 11:00:00.000@ then
return -1
endi
if $data01 != NULL then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 09:00:00','2021-10-20 14:00:00') EVERY(1s) ORDER BY ts DESC;
if $rows != 7 then
return -1
endi
if $data60 != @21-10-20 10:00:00.000@ then
return -1
endi
if $data61 != 0 then
return -1
endi
if $data50 != @21-10-20 10:00:01.000@ then
return -1
endi
if $data51 != 1 then
return -1
endi
if $data40 != @21-10-20 10:00:03.000@ then
return -1
endi
if $data41 != 3 then
return -1
endi
if $data30 != @21-10-20 10:00:06.000@ then
return -1
endi
if $data31 != 6 then
return -1
endi
if $data20 != @21-10-20 10:00:10.000@ then
return -1
endi
if $data21 != 10 then
return -1
endi
if $data10 != @21-10-20 10:00:15.000@ then
return -1
endi
if $data11 != 15 then
return -1
endi
if $data00 != @21-10-20 10:00:21.000@ then
return -1
endi
if $data01 != 21 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 09:00:00','2021-10-20 09:00:01') EVERY(1s) ORDER BY ts DESC;
if $rows != 0 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 10:00:00','2021-10-20 10:00:00') EVERY(1s) ORDER BY ts DESC;
if $rows != 1 then
return -1
endi
if $data00 != @21-10-20 10:00:00.000@ then
return -1
endi
if $data01 != 0 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 10:00:04','2021-10-20 14:00:00') EVERY(1s) ORDER BY ts DESC;
if $rows != 4 then
return -1
endi
if $data30 != @21-10-20 10:00:06.000@ then
return -1
endi
if $data31 != 6 then
return -1
endi
if $data20 != @21-10-20 10:00:10.000@ then
return -1
endi
if $data21 != 10 then
return -1
endi
if $data10 != @21-10-20 10:00:15.000@ then
return -1
endi
if $data11 != 15 then
return -1
endi
if $data00 != @21-10-20 10:00:21.000@ then
return -1
endi
if $data01 != 21 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 11:00:00','2021-10-20 14:00:00') EVERY(1s) ORDER BY ts DESC;
if $rows != 0 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 09:00:00','2021-10-20 14:00:00') EVERY(2s) ORDER BY ts DESC;
if $rows != 3 then
return -1
endi
if $data20 != @21-10-20 10:00:00.000@ then
return -1
endi
if $data21 != 0 then
return -1
endi
if $data10 != @21-10-20 10:00:06.000@ then
return -1
endi
if $data11 != 6 then
return -1
endi
if $data00 != @21-10-20 10:00:10.000@ then
return -1
endi
if $data01 != 10 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 09:00:00','2021-10-20 09:00:01') EVERY(2s) ORDER BY ts DESC;
if $rows != 0 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 10:00:00','2021-10-20 10:00:00') EVERY(2s) ORDER BY ts DESC;
if $rows != 1 then
return -1
endi
if $data00 != @21-10-20 10:00:00.000@ then
return -1
endi
if $data01 != 0 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 10:00:04','2021-10-20 14:00:00') EVERY(2s) ORDER BY ts DESC;
if $rows != 2 then
return -1
endi
if $data10 != @21-10-20 10:00:06.000@ then
return -1
endi
if $data11 != 6 then
return -1
endi
if $data00 != @21-10-20 10:00:10.000@ then
return -1
endi
if $data01 != 10 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 11:00:00','2021-10-20 14:00:00') EVERY(2s) ORDER BY ts DESC;
if $rows != 0 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 EVERY(1s) FILL(LINEAR) ORDER BY ts DESC;
if $rows != 22 then
return -1
endi
if $data00 != @21-10-20 10:00:21.000@ then
return -1
endi
if $data01 != 21 then
return -1
endi
if $data10 != @21-10-20 10:00:20.000@ then
return -1
endi
if $data11 != 20 then
return -1
endi
if $data20 != @21-10-20 10:00:19.000@ then
return -1
endi
if $data21 != 19 then
return -1
endi
if $data80 != @21-10-20 10:00:13.000@ then
return -1
endi
if $data81 != 13 then
return -1
endi
if $data90 != @21-10-20 10:00:12.000@ then
return -1
endi
if $data91 != 12 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 EVERY(1s) FILL(NEXT) ORDER BY ts DESC;
if $rows != 22 then
return -1
endi
if $data00 != @21-10-20 10:00:21.000@ then
return -1
endi
if $data01 != 21 then
return -1
endi
if $data10 != @21-10-20 10:00:20.000@ then
return -1
endi
if $data11 != 21 then
return -1
endi
if $data20 != @21-10-20 10:00:19.000@ then
return -1
endi
if $data21 != 21 then
return -1
endi
if $data30 != @21-10-20 10:00:18.000@ then
return -1
endi
if $data31 != 21 then
return -1
endi
if $data40 != @21-10-20 10:00:17.000@ then
return -1
endi
if $data41 != 21 then
return -1
endi
if $data50 != @21-10-20 10:00:16.000@ then
return -1
endi
if $data51 != 21 then
return -1
endi
if $data60 != @21-10-20 10:00:15.000@ then
return -1
endi
if $data61 != 15 then
return -1
endi
if $data70 != @21-10-20 10:00:14.000@ then
return -1
endi
if $data71 != 15 then
return -1
endi
if $data80 != @21-10-20 10:00:13.000@ then
return -1
endi
if $data81 != 15 then
return -1
endi
if $data90 != @21-10-20 10:00:12.000@ then
return -1
endi
if $data91 != 15 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 EVERY(1s) FILL(NEXT) ORDER BY ts DESC limit 10 offset 10;
if $rows != 10 then
return -1
endi
if $data00 != @21-10-20 10:00:11.000@ then
return -1
endi
if $data01 != 15 then
return -1
endi
if $data10 != @21-10-20 10:00:10.000@ then
return -1
endi
if $data11 != 10 then
return -1
endi
if $data20 != @21-10-20 10:00:09.000@ then
return -1
endi
if $data21 != 10 then
return -1
endi
if $data30 != @21-10-20 10:00:08.000@ then
return -1
endi
if $data31 != 10 then
return -1
endi
if $data40 != @21-10-20 10:00:07.000@ then
return -1
endi
if $data41 != 10 then
return -1
endi
if $data50 != @21-10-20 10:00:06.000@ then
return -1
endi
if $data51 != 6 then
return -1
endi
if $data60 != @21-10-20 10:00:05.000@ then
return -1
endi
if $data61 != 6 then
return -1
endi
if $data70 != @21-10-20 10:00:04.000@ then
return -1
endi
if $data71 != 6 then
return -1
endi
if $data80 != @21-10-20 10:00:03.000@ then
return -1
endi
if $data81 != 3 then
return -1
endi
if $data90 != @21-10-20 10:00:02.000@ then
return -1
endi
if $data91 != 3 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 EVERY(1s) FILL(PREV) ORDER BY ts DESC;
if $rows != 22 then
return -1
endi
if $data00 != @21-10-20 10:00:21.000@ then
return -1
endi
if $data01 != 21 then
return -1
endi
if $data10 != @21-10-20 10:00:20.000@ then
return -1
endi
if $data11 != 15 then
return -1
endi
if $data20 != @21-10-20 10:00:19.000@ then
return -1
endi
if $data21 != 15 then
return -1
endi
if $data30 != @21-10-20 10:00:18.000@ then
return -1
endi
if $data31 != 15 then
return -1
endi
if $data40 != @21-10-20 10:00:17.000@ then
return -1
endi
if $data41 != 15 then
return -1
endi
if $data50 != @21-10-20 10:00:16.000@ then
return -1
endi
if $data51 != 15 then
return -1
endi
if $data60 != @21-10-20 10:00:15.000@ then
return -1
endi
if $data61 != 15 then
return -1
endi
if $data70 != @21-10-20 10:00:14.000@ then
return -1
endi
if $data71 != 10 then
return -1
endi
if $data80 != @21-10-20 10:00:13.000@ then
return -1
endi
if $data81 != 10 then
return -1
endi
if $data90 != @21-10-20 10:00:12.000@ then
return -1
endi
if $data91 != 10 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 EVERY(1s) FILL(PREV) ORDER BY ts DESC limit 10 offset 10;
if $rows != 10 then
return -1
endi
if $data00 != @21-10-20 10:00:11.000@ then
return -1
endi
if $data01 != 10 then
return -1
endi
if $data10 != @21-10-20 10:00:10.000@ then
return -1
endi
if $data11 != 10 then
return -1
endi
if $data20 != @21-10-20 10:00:09.000@ then
return -1
endi
if $data21 != 6 then
return -1
endi
if $data30 != @21-10-20 10:00:08.000@ then
return -1
endi
if $data31 != 6 then
return -1
endi
if $data40 != @21-10-20 10:00:07.000@ then
return -1
endi
if $data41 != 6 then
return -1
endi
if $data50 != @21-10-20 10:00:06.000@ then
return -1
endi
if $data51 != 6 then
return -1
endi
if $data60 != @21-10-20 10:00:05.000@ then
return -1
endi
if $data61 != 3 then
return -1
endi
if $data70 != @21-10-20 10:00:04.000@ then
return -1
endi
if $data71 != 3 then
return -1
endi
if $data80 != @21-10-20 10:00:03.000@ then
return -1
endi
if $data81 != 3 then
return -1
endi
if $data90 != @21-10-20 10:00:02.000@ then
return -1
endi
if $data91 != 1 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 EVERY(1s) FILL(PREV) ORDER BY ts DESC limit 10 offset 20;
if $rows != 2 then
return -1
endi
if $data00 != @21-10-20 10:00:01.000@ then
return -1
endi
if $data01 != 1 then
return -1
endi
if $data10 != @21-10-20 10:00:00.000@ then
return -1
endi
if $data11 != 0 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 EVERY(1s) FILL(VALUE,100) ORDER BY ts DESC;
if $rows != 22 then
return -1
endi
if $data00 != @21-10-20 10:00:21.000@ then
return -1
endi
if $data01 != 21 then
return -1
endi
if $data10 != @21-10-20 10:00:20.000@ then
return -1
endi
if $data11 != 100 then
return -1
endi
if $data20 != @21-10-20 10:00:19.000@ then
return -1
endi
if $data21 != 100 then
return -1
endi
if $data30 != @21-10-20 10:00:18.000@ then
return -1
endi
if $data31 != 100 then
return -1
endi
if $data40 != @21-10-20 10:00:17.000@ then
return -1
endi
if $data41 != 100 then
return -1
endi
if $data50 != @21-10-20 10:00:16.000@ then
return -1
endi
if $data51 != 100 then
return -1
endi
if $data60 != @21-10-20 10:00:15.000@ then
return -1
endi
if $data61 != 15 then
return -1
endi
if $data70 != @21-10-20 10:00:14.000@ then
return -1
endi
if $data71 != 100 then
return -1
endi
if $data80 != @21-10-20 10:00:13.000@ then
return -1
endi
if $data81 != 100 then
return -1
endi
if $data90 != @21-10-20 10:00:12.000@ then
return -1
endi
if $data91 != 100 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 EVERY(1s) FILL(NULL) ORDER BY ts DESC;
if $rows != 22 then
return -1
endi
if $data00 != @21-10-20 10:00:21.000@ then
return -1
endi
if $data01 != 21 then
return -1
endi
if $data10 != @21-10-20 10:00:20.000@ then
return -1
endi
if $data11 != NULL then
return -1
endi
if $data20 != @21-10-20 10:00:19.000@ then
return -1
endi
if $data21 != NULL then
return -1
endi
if $data30 != @21-10-20 10:00:18.000@ then
return -1
endi
if $data31 != NULL then
return -1
endi
if $data40 != @21-10-20 10:00:17.000@ then
return -1
endi
if $data41 != NULL then
return -1
endi
if $data50 != @21-10-20 10:00:16.000@ then
return -1
endi
if $data51 != NULL then
return -1
endi
if $data60 != @21-10-20 10:00:15.000@ then
return -1
endi
if $data61 != 15 then
return -1
endi
if $data70 != @21-10-20 10:00:14.000@ then
return -1
endi
if $data71 != NULL then
return -1
endi
if $data80 != @21-10-20 10:00:13.000@ then
return -1
endi
if $data81 != NULL then
return -1
endi
if $data90 != @21-10-20 10:00:12.000@ then
return -1
endi
if $data91 != NULL then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 EVERY(5s) FILL(LINEAR) ORDER BY ts DESC;
if $rows != 5 then
return -1
endi
if $data40 != @21-10-20 10:00:00.000@ then
return -1
endi
if $data41 != 0 then
return -1
endi
if $data30 != @21-10-20 10:00:05.000@ then
return -1
endi
if $data31 != 5 then
return -1
endi
if $data20 != @21-10-20 10:00:10.000@ then
return -1
endi
if $data21 != 10 then
return -1
endi
if $data10 != @21-10-20 10:00:15.000@ then
return -1
endi
if $data11 != 15 then
return -1
endi
if $data00 != @21-10-20 10:00:20.000@ then
return -1
endi
if $data01 != 20 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 EVERY(5s) FILL(NEXT) ORDER BY ts DESC;
if $rows != 5 then
return -1
endi
if $data40 != @21-10-20 10:00:00.000@ then
return -1
endi
if $data41 != 0 then
return -1
endi
if $data30 != @21-10-20 10:00:05.000@ then
return -1
endi
if $data31 != 6 then
return -1
endi
if $data20 != @21-10-20 10:00:10.000@ then
return -1
endi
if $data21 != 10 then
return -1
endi
if $data10 != @21-10-20 10:00:15.000@ then
return -1
endi
if $data11 != 15 then
return -1
endi
if $data00 != @21-10-20 10:00:20.000@ then
return -1
endi
if $data01 != 21 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 EVERY(5s) FILL(PREV) ORDER BY ts DESC;
if $rows != 5 then
return -1
endi
if $data40 != @21-10-20 10:00:00.000@ then
return -1
endi
if $data41 != 0 then
return -1
endi
if $data30 != @21-10-20 10:00:05.000@ then
return -1
endi
if $data31 != 3 then
return -1
endi
if $data20 != @21-10-20 10:00:10.000@ then
return -1
endi
if $data21 != 10 then
return -1
endi
if $data10 != @21-10-20 10:00:15.000@ then
return -1
endi
if $data11 != 15 then
return -1
endi
if $data00 != @21-10-20 10:00:20.000@ then
return -1
endi
if $data01 != 15 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 EVERY(5s) FILL(VALUE,100) ORDER BY ts DESC;
if $rows != 5 then
return -1
endi
if $data40 != @21-10-20 10:00:00.000@ then
return -1
endi
if $data41 != 0 then
return -1
endi
if $data30 != @21-10-20 10:00:05.000@ then
return -1
endi
if $data31 != 100 then
return -1
endi
if $data20 != @21-10-20 10:00:10.000@ then
return -1
endi
if $data21 != 10 then
return -1
endi
if $data10 != @21-10-20 10:00:15.000@ then
return -1
endi
if $data11 != 15 then
return -1
endi
if $data00 != @21-10-20 10:00:20.000@ then
return -1
endi
if $data01 != 100 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 EVERY(5s) FILL(NULL) ORDER BY ts DESC;
if $rows != 5 then
return -1
endi
if $data40 != @21-10-20 10:00:00.000@ then
return -1
endi
if $data41 != 0 then
return -1
endi
if $data30 != @21-10-20 10:00:05.000@ then
return -1
endi
if $data31 != NULL then
return -1
endi
if $data20 != @21-10-20 10:00:10.000@ then
return -1
endi
if $data21 != 10 then
return -1
endi
if $data10 != @21-10-20 10:00:15.000@ then
return -1
endi
if $data11 != 15 then
return -1
endi
if $data00 != @21-10-20 10:00:20.000@ then
return -1
endi
if $data01 != NULL then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 09:00:00','2021-10-20 14:00:00') EVERY(1s) FILL(LINEAR) ORDER BY ts DESC;
if $rows != 22 then
return -1
endi
if $data00 != @21-10-20 10:00:21.000@ then
return -1
endi
if $data01 != 21 then
return -1
endi
if $data10 != @21-10-20 10:00:20.000@ then
return -1
endi
if $data11 != 20 then
return -1
endi
if $data20 != @21-10-20 10:00:19.000@ then
return -1
endi
if $data21 != 19 then
return -1
endi
if $data30 != @21-10-20 10:00:18.000@ then
return -1
endi
if $data31 != 18 then
return -1
endi
if $data40 != @21-10-20 10:00:17.000@ then
return -1
endi
if $data41 != 17 then
return -1
endi
if $data50 != @21-10-20 10:00:16.000@ then
return -1
endi
if $data51 != 16 then
return -1
endi
if $data60 != @21-10-20 10:00:15.000@ then
return -1
endi
if $data61 != 15 then
return -1
endi
if $data70 != @21-10-20 10:00:14.000@ then
return -1
endi
if $data71 != 14 then
return -1
endi
if $data80 != @21-10-20 10:00:13.000@ then
return -1
endi
if $data81 != 13 then
return -1
endi
if $data90 != @21-10-20 10:00:12.000@ then
return -1
endi
if $data91 != 12 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 09:00:00','2021-10-20 14:00:00') EVERY(1s) FILL(LINEAR) ORDER BY ts DESC limit 20 offset 10;
if $rows != 12 then
return -1
endi
if $data00 != @21-10-20 10:00:11.000@ then
return -1
endi
if $data01 != 11 then
return -1
endi
if $data10 != @21-10-20 10:00:10.000@ then
return -1
endi
if $data11 != 10 then
return -1
endi
if $data20 != @21-10-20 10:00:09.000@ then
return -1
endi
if $data21 != 9 then
return -1
endi
if $data30 != @21-10-20 10:00:08.000@ then
return -1
endi
if $data31 != 8 then
return -1
endi
if $data40 != @21-10-20 10:00:07.000@ then
return -1
endi
if $data41 != 7 then
return -1
endi
if $data50 != @21-10-20 10:00:06.000@ then
return -1
endi
if $data51 != 6 then
return -1
endi
if $data60 != @21-10-20 10:00:05.000@ then
return -1
endi
if $data61 != 5 then
return -1
endi
if $data70 != @21-10-20 10:00:04.000@ then
return -1
endi
if $data71 != 4 then
return -1
endi
if $data80 != @21-10-20 10:00:03.000@ then
return -1
endi
if $data81 != 3 then
return -1
endi
if $data90 != @21-10-20 10:00:02.000@ then
return -1
endi
if $data91 != 2 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 09:00:00','2021-10-20 09:00:01') EVERY(1s) FILL(LINEAR) ORDER BY ts DESC;
if $rows != 0 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 10:00:00','2021-10-20 10:00:00') EVERY(1s) FILL(LINEAR) ORDER BY ts DESC;
if $rows != 1 then
return -1
endi
if $data00 != @21-10-20 10:00:00.000@ then
return -1
endi
if $data01 != 0 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 10:00:04','2021-10-20 14:00:00') EVERY(1s) FILL(LINEAR) ORDER BY ts DESC;
if $rows != 18 then
return -1
endi
if $data00 != @21-10-20 10:00:21.000@ then
return -1
endi
if $data01 != 21 then
return -1
endi
if $data10 != @21-10-20 10:00:20.000@ then
return -1
endi
if $data11 != 20 then
return -1
endi
if $data20 != @21-10-20 10:00:19.000@ then
return -1
endi
if $data21 != 19 then
return -1
endi
if $data30 != @21-10-20 10:00:18.000@ then
return -1
endi
if $data31 != 18 then
return -1
endi
if $data40 != @21-10-20 10:00:17.000@ then
return -1
endi
if $data41 != 17 then
return -1
endi
if $data50 != @21-10-20 10:00:16.000@ then
return -1
endi
if $data51 != 16 then
return -1
endi
if $data60 != @21-10-20 10:00:15.000@ then
return -1
endi
if $data61 != 15 then
return -1
endi
if $data70 != @21-10-20 10:00:14.000@ then
return -1
endi
if $data71 != 14 then
return -1
endi
if $data80 != @21-10-20 10:00:13.000@ then
return -1
endi
if $data81 != 13 then
return -1
endi
if $data90 != @21-10-20 10:00:12.000@ then
return -1
endi
if $data91 != 12 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 11:00:00','2021-10-20 14:00:00') EVERY(1s) FILL(LINEAR) ORDER BY ts DESC;
if $rows != 0 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 09:00:00','2021-10-20 14:00:00') EVERY(1s) FILL(NEXT) ORDER BY ts DESC;
if $rows != 3622 then
return -1
endi
if $data00 != @21-10-20 10:00:21.000@ then
return -1
endi
if $data01 != 21 then
return -1
endi
if $data10 != @21-10-20 10:00:20.000@ then
return -1
endi
if $data11 != 21 then
return -1
endi
if $data20 != @21-10-20 10:00:19.000@ then
return -1
endi
if $data21 != 21 then
return -1
endi
if $data30 != @21-10-20 10:00:18.000@ then
return -1
endi
if $data31 != 21 then
return -1
endi
if $data40 != @21-10-20 10:00:17.000@ then
return -1
endi
if $data41 != 21 then
return -1
endi
if $data50 != @21-10-20 10:00:16.000@ then
return -1
endi
if $data51 != 21 then
return -1
endi
if $data60 != @21-10-20 10:00:15.000@ then
return -1
endi
if $data61 != 15 then
return -1
endi
if $data70 != @21-10-20 10:00:14.000@ then
return -1
endi
if $data71 != 15 then
return -1
endi
if $data80 != @21-10-20 10:00:13.000@ then
return -1
endi
if $data81 != 15 then
return -1
endi
if $data90 != @21-10-20 10:00:12.000@ then
return -1
endi
if $data91 != 15 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 09:00:00','2021-10-20 14:00:00') EVERY(1s) FILL(NEXT) ORDER BY ts DESC limit 20 offset 10 ;
if $rows != 20 then
return -1
endi
if $data00 != @21-10-20 10:00:11.000@ then
return -1
endi
if $data01 != 15 then
return -1
endi
if $data10 != @21-10-20 10:00:10.000@ then
return -1
endi
if $data11 != 10 then
return -1
endi
if $data20 != @21-10-20 10:00:09.000@ then
return -1
endi
if $data21 != 10 then
return -1
endi
if $data30 != @21-10-20 10:00:08.000@ then
return -1
endi
if $data31 != 10 then
return -1
endi
if $data40 != @21-10-20 10:00:07.000@ then
return -1
endi
if $data41 != 10 then
return -1
endi
if $data50 != @21-10-20 10:00:06.000@ then
return -1
endi
if $data51 != 6 then
return -1
endi
if $data60 != @21-10-20 10:00:05.000@ then
return -1
endi
if $data61 != 6 then
return -1
endi
if $data70 != @21-10-20 10:00:04.000@ then
return -1
endi
if $data71 != 6 then
return -1
endi
if $data80 != @21-10-20 10:00:03.000@ then
return -1
endi
if $data81 != 3 then
return -1
endi
if $data90 != @21-10-20 10:00:02.000@ then
return -1
endi
if $data91 != 3 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 09:00:00','2021-10-20 14:00:00') EVERY(1s) FILL(NEXT) ORDER BY ts DESC limit 20 offset 20 ;
if $rows != 20 then
return -1
endi
if $data00 != @21-10-20 10:00:01.000@ then
return -1
endi
if $data01 != 1 then
return -1
endi
if $data10 != @21-10-20 10:00:00.000@ then
return -1
endi
if $data11 != 0 then
return -1
endi
if $data20 != @21-10-20 09:59:59.000@ then
return -1
endi
if $data21 != 0 then
return -1
endi
if $data30 != @21-10-20 09:59:58.000@ then
return -1
endi
if $data31 != 0 then
return -1
endi
if $data40 != @21-10-20 09:59:57.000@ then
return -1
endi
if $data41 != 0 then
return -1
endi
if $data50 != @21-10-20 09:59:56.000@ then
return -1
endi
if $data51 != 0 then
return -1
endi
if $data60 != @21-10-20 09:59:55.000@ then
return -1
endi
if $data61 != 0 then
return -1
endi
if $data70 != @21-10-20 09:59:54.000@ then
return -1
endi
if $data71 != 0 then
return -1
endi
if $data80 != @21-10-20 09:59:53.000@ then
return -1
endi
if $data81 != 0 then
return -1
endi
if $data90 != @21-10-20 09:59:52.000@ then
return -1
endi
if $data91 != 0 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 09:00:00','2021-10-20 09:00:01') EVERY(1s) FILL(NEXT) ORDER BY ts DESC;
if $rows != 2 then
return -1
endi
if $data00 != @21-10-20 09:00:01.000@ then
return -1
endi
if $data01 != 0 then
return -1
endi
if $data10 != @21-10-20 09:00:00.000@ then
return -1
endi
if $data11 != 0 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 10:00:00','2021-10-20 10:00:00') EVERY(1s) FILL(NEXT) ORDER BY ts DESC;
if $rows != 1 then
return -1
endi
if $data00 != @21-10-20 10:00:00.000@ then
return -1
endi
if $data01 != 0 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 10:00:04','2021-10-20 14:00:00') EVERY(1s) FILL(NEXT) ORDER BY ts DESC;
if $rows != 18 then
return -1
endi
if $data00 != @21-10-20 10:00:21.000@ then
return -1
endi
if $data01 != 21 then
return -1
endi
if $data10 != @21-10-20 10:00:20.000@ then
return -1
endi
if $data11 != 21 then
return -1
endi
if $data20 != @21-10-20 10:00:19.000@ then
return -1
endi
if $data21 != 21 then
return -1
endi
if $data30 != @21-10-20 10:00:18.000@ then
return -1
endi
if $data31 != 21 then
return -1
endi
if $data40 != @21-10-20 10:00:17.000@ then
return -1
endi
if $data41 != 21 then
return -1
endi
if $data50 != @21-10-20 10:00:16.000@ then
return -1
endi
if $data51 != 21 then
return -1
endi
if $data60 != @21-10-20 10:00:15.000@ then
return -1
endi
if $data61 != 15 then
return -1
endi
if $data70 != @21-10-20 10:00:14.000@ then
return -1
endi
if $data71 != 15 then
return -1
endi
if $data80 != @21-10-20 10:00:13.000@ then
return -1
endi
if $data81 != 15 then
return -1
endi
if $data90 != @21-10-20 10:00:12.000@ then
return -1
endi
if $data91 != 15 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 11:00:00','2021-10-20 14:00:00') EVERY(1s) FILL(NEXT) ORDER BY ts DESC;
if $rows != 0 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 09:00:00','2021-10-20 14:00:00') EVERY(1s) FILL(PREV) ORDER BY ts DESC;
if $rows != 14401 then
return -1
endi
if $data00 != @21-10-20 14:00:00.000@ then
return -1
endi
if $data01 != 21 then
return -1
endi
if $data10 != @21-10-20 13:59:59.000@ then
return -1
endi
if $data11 != 21 then
return -1
endi
if $data20 != @21-10-20 13:59:58.000@ then
return -1
endi
if $data21 != 21 then
return -1
endi
if $data30 != @21-10-20 13:59:57.000@ then
return -1
endi
if $data31 != 21 then
return -1
endi
if $data40 != @21-10-20 13:59:56.000@ then
return -1
endi
if $data41 != 21 then
return -1
endi
if $data50 != @21-10-20 13:59:55.000@ then
return -1
endi
if $data51 != 21 then
return -1
endi
if $data60 != @21-10-20 13:59:54.000@ then
return -1
endi
if $data61 != 21 then
return -1
endi
if $data70 != @21-10-20 13:59:53.000@ then
return -1
endi
if $data71 != 21 then
return -1
endi
if $data80 != @21-10-20 13:59:52.000@ then
return -1
endi
if $data81 != 21 then
return -1
endi
if $data90 != @21-10-20 13:59:51.000@ then
return -1
endi
if $data91 != 21 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 09:00:00','2021-10-20 14:00:00') EVERY(1s) FILL(PREV) ORDER BY ts DESC limit 30 offset 14379;
if $rows != 22 then
return -1
endi
if $data00 != @21-10-20 10:00:21.000@ then
return -1
endi
if $data01 != 21 then
return -1
endi
if $data10 != @21-10-20 10:00:20.000@ then
return -1
endi
if $data11 != 15 then
return -1
endi
if $data20 != @21-10-20 10:00:19.000@ then
return -1
endi
if $data21 != 15 then
return -1
endi
if $data30 != @21-10-20 10:00:18.000@ then
return -1
endi
if $data31 != 15 then
return -1
endi
if $data40 != @21-10-20 10:00:17.000@ then
return -1
endi
if $data41 != 15 then
return -1
endi
if $data50 != @21-10-20 10:00:16.000@ then
return -1
endi
if $data51 != 15 then
return -1
endi
if $data60 != @21-10-20 10:00:15.000@ then
return -1
endi
if $data61 != 15 then
return -1
endi
if $data70 != @21-10-20 10:00:14.000@ then
return -1
endi
if $data71 != 10 then
return -1
endi
if $data80 != @21-10-20 10:00:13.000@ then
return -1
endi
if $data81 != 10 then
return -1
endi
if $data90 != @21-10-20 10:00:12.000@ then
return -1
endi
if $data91 != 10 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 09:00:00','2021-10-20 09:00:01') EVERY(1s) FILL(PREV) ORDER BY ts DESC;
if $rows != 0 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 10:00:00','2021-10-20 10:00:00') EVERY(1s) FILL(PREV) ORDER BY ts DESC;
if $rows != 1 then
return -1
endi
if $data00 != @21-10-20 10:00:00.000@ then
return -1
endi
if $data01 != 0 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 10:00:04','2021-10-20 14:00:00') EVERY(1s) FILL(PREV) ORDER BY ts DESC;
if $rows != 14397 then
return -1
endi
if $data00 != @21-10-20 14:00:00.000@ then
return -1
endi
if $data01 != 21 then
return -1
endi
if $data10 != @21-10-20 13:59:59.000@ then
return -1
endi
if $data11 != 21 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 10:00:04','2021-10-20 14:00:00') EVERY(1s) FILL(PREV) ORDER BY ts DESC limit 20 offset 14387;
if $rows != 10 then
return -1
endi
if $data00 != @21-10-20 10:00:13.000@ then
return -1
endi
if $data01 != 10 then
return -1
endi
if $data10 != @21-10-20 10:00:12.000@ then
return -1
endi
if $data11 != 10 then
return -1
endi
if $data20 != @21-10-20 10:00:11.000@ then
return -1
endi
if $data21 != 10 then
return -1
endi
if $data30 != @21-10-20 10:00:10.000@ then
return -1
endi
if $data31 != 10 then
return -1
endi
if $data40 != @21-10-20 10:00:09.000@ then
return -1
endi
if $data41 != 6 then
return -1
endi
if $data50 != @21-10-20 10:00:08.000@ then
return -1
endi
if $data51 != 6 then
return -1
endi
if $data60 != @21-10-20 10:00:07.000@ then
return -1
endi
if $data61 != 6 then
return -1
endi
if $data70 != @21-10-20 10:00:06.000@ then
return -1
endi
if $data71 != 6 then
return -1
endi
if $data80 != @21-10-20 10:00:05.000@ then
return -1
endi
if $data81 != 3 then
return -1
endi
if $data90 != @21-10-20 10:00:04.000@ then
return -1
endi
if $data91 != 3 then
return -1
endi
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 11:00:00','2021-10-20 14:00:00') EVERY(1s) FILL(PREV);
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 09:00:00','2021-10-20 14:00:00') EVERY(1s) FILL(VALUE,100);
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 09:00:00','2021-10-20 14:00:00') EVERY(1s) FILL(VALUE,100) limit 20 offset 3600;
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 09:00:00','2021-10-20 09:00:01') EVERY(1s) FILL(VALUE,100);
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 10:00:00','2021-10-20 10:00:00') EVERY(1s) FILL(VALUE,100);
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 10:00:04','2021-10-20 14:00:00') EVERY(1s) FILL(VALUE,100);
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 11:00:00','2021-10-20 14:00:00') EVERY(1s) FILL(VALUE,100);
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 09:00:00','2021-10-20 14:00:00') EVERY(1s) FILL(NULL);
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 09:00:00','2021-10-20 14:00:00') EVERY(1s) FILL(NULL) limit 20 offset 3600;
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 09:00:00','2021-10-20 09:00:01') EVERY(1s) FILL(NULL);
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 10:00:00','2021-10-20 10:00:00') EVERY(1s) FILL(NULL);
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 10:00:04','2021-10-20 14:00:00') EVERY(1s) FILL(NULL);
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 11:00:00','2021-10-20 14:00:00') EVERY(1s) FILL(NULL);
sql SELECT INTERP(c1) FROM tb1 RANGE('2021-10-20 10:00:03.500','2021-10-20 14:00:00') EVERY(1s) FILL(LINEAR);
sql SELECT INTERP(c2) FROM tb1 RANGE('2021-10-20 10:00:03.500','2021-10-20 14:00:00') EVERY(1s) FILL(LINEAR);
sql SELECT INTERP(c1) FROM tb1 WHERE ts BETWEEN '2021-10-20 10:00:10' AND '2021-10-20 10:00:15' RANGE('2021-10-20 10:00:00','2021-10-20 14:00:00') EVERY(1s) FILL(LINEAR);
sql SELECT INTERP(c1) FROM tb1 WHERE ts BETWEEN '2021-10-20 10:00:10' AND '2021-10-20 10:00:11' RANGE('2021-10-20 10:00:00','2021-10-20 14:00:00') EVERY(1s) FILL(LINEAR);
sql SELECT INTERP(c1) FROM tb1 WHERE ts BETWEEN '2021-10-20 10:00:10' AND '2021-10-20 10:00:15' RANGE('2021-10-20 10:00:00','2021-10-20 14:00:00') EVERY(1s) FILL(NEXT);
sql SELECT INTERP(c1) FROM tb1 WHERE ts BETWEEN '2021-10-20 10:00:10' AND '2021-10-20 10:00:15' RANGE('2021-10-20 09:00:00','2021-10-20 09:00:10') EVERY(1s) FILL(LINEAR);
sql SELECT INTERP(c1) FROM tb1 WHERE ts BETWEEN '2021-10-20 10:00:10' AND '2021-10-20 10:00:20' RANGE('2021-10-20 10:00:05','2021-10-20 10:00:16') EVERY(1s) FILL(LINEAR);
sql SELECT INTERP(c1) FROM tb1 WHERE ts BETWEEN '2021-10-20 10:00:10' AND '2021-10-20 10:00:20' RANGE('2021-10-20 10:00:15','2021-10-20 10:00:25') EVERY(1s) FILL(LINEAR);
sql SELECT INTERP(c1) FROM tb1 WHERE ts BETWEEN '2021-10-20 10:00:10' AND '2021-10-20 10:00:20' RANGE('2021-10-20 10:00:21','2021-10-20 10:00:30') EVERY(1s) FILL(LINEAR);
sql SELECT INTERP(c1) FROM tb1 WHERE ts BETWEEN '2021-10-20 10:00:10' AND '2021-10-20 10:00:15' RANGE('2021-10-20 09:00:00','2021-10-20 09:00:10') EVERY(1s) FILL(PREV);
sql SELECT INTERP(c1) FROM tb1 WHERE ts BETWEEN '2021-10-20 10:00:10' AND '2021-10-20 10:00:20' RANGE('2021-10-20 10:00:05','2021-10-20 10:00:16') EVERY(1s) FILL(PREV);
sql SELECT INTERP(c1) FROM tb1 WHERE ts BETWEEN '2021-10-20 10:00:10' AND '2021-10-20 10:00:20' RANGE('2021-10-20 10:00:15','2021-10-20 10:00:25') EVERY(1s) FILL(PREV);
sql SELECT INTERP(c1) FROM tb1 WHERE ts BETWEEN '2021-10-20 10:00:10' AND '2021-10-20 10:00:20' RANGE('2021-10-20 10:00:21','2021-10-20 10:00:30') EVERY(1s) FILL(PREV);
sql SELECT INTERP(c1) FROM tb1 WHERE ts BETWEEN '2021-10-20 10:00:10' AND '2021-10-20 10:00:15' RANGE('2021-10-20 09:00:00','2021-10-20 09:00:10') EVERY(1s) FILL(NEXT);
sql SELECT INTERP(c1) FROM tb1 WHERE ts BETWEEN '2021-10-20 10:00:10' AND '2021-10-20 10:00:20' RANGE('2021-10-20 10:00:05','2021-10-20 10:00:16') EVERY(1s) FILL(NEXT);
sql SELECT INTERP(c1) FROM tb1 WHERE ts BETWEEN '2021-10-20 10:00:10' AND '2021-10-20 10:00:20' RANGE('2021-10-20 10:00:15','2021-10-20 10:00:25') EVERY(1s) FILL(NEXT);
sql SELECT INTERP(c1) FROM tb1 WHERE ts BETWEEN '2021-10-20 10:00:10' AND '2021-10-20 10:00:20' RANGE('2021-10-20 10:00:21','2021-10-20 10:00:30') EVERY(1s) FILL(NEXT);
sql SELECT INTERP(c2) FROM tb4 RANGE('2021-10-20 10:00:00','2021-10-20 12:00:00') FILL(NULL) ORDER BY ts DESC;
if $rows != 0 then
return -1
endi
sql SELECT INTERP(c2) FROM tb4 RANGE('2021-10-20 10:00:00','2021-10-20 12:00:00') EVERY(1s) FILL(NULL) ORDER BY ts DESC;
if $rows != 0 then
return -1
endi
sql SELECT INTERP(c2) FROM tb4 RANGE('2021-10-20 10:00:00','2021-10-20 12:00:00') EVERY(1s) FILL(LINEAR) ORDER BY ts DESC;
if $rows != 0 then
return -1
endi
sql SELECT INTERP(c2) FROM tb4 RANGE('2021-10-20 10:00:00','2021-10-20 12:00:00') EVERY(1s) FILL(PREV) ORDER BY ts DESC;
if $rows != 0 then
return -1
endi
sql SELECT INTERP(c2) FROM tb4 RANGE('2021-10-20 10:00:00','2021-10-20 12:00:00') EVERY(1s) FILL(NEXT) ORDER BY ts DESC;
if $rows != 0 then
return -1
endi
sql SELECT INTERP(c2) FROM tb4 RANGE('2021-10-20 10:00:00','2021-10-20 12:00:00') EVERY(1s) FILL(VALUE,100) ORDER BY ts DESC;
if $rows != 0 then
return -1
endi
sql SELECT INTERP(c1) FROM stb1 RANGE('2021-10-20 10:00:00','2021-10-20 10:00:30') EVERY(1s) FILL(LINEAR) GROUP BY TBNAME ORDER BY TBNAME desc;
if $rows != 59 then
return -1
endi
if $data00 != @21-10-20 10:00:00.000@ then
return -1
endi
if $data01 != 0 then
return -1
endi
if $data02 != tb3 then
return -1
endi
if $data10 != @21-10-20 10:00:01.000@ then
return -1
endi
if $data11 != 1 then
return -1
endi
if $data12 != tb3 then
return -1
endi
if $data20 != @21-10-20 10:00:02.000@ then
return -1
endi
if $data21 != 2 then
return -1
endi
if $data22 != tb3 then
return -1
endi
if $data30 != @21-10-20 10:00:03.000@ then
return -1
endi
if $data31 != 3 then
return -1
endi
if $data32 != tb3 then
return -1
endi
if $data40 != @21-10-20 10:00:04.000@ then
return -1
endi
if $data41 != 4 then
return -1
endi
if $data42 != tb3 then
return -1
endi
if $data50 != @21-10-20 10:00:05.000@ then
return -1
endi
if $data51 != 5 then
return -1
endi
if $data52 != tb3 then
return -1
endi
if $data60 != @21-10-20 10:00:06.000@ then
return -1
endi
if $data61 != 6 then
return -1
endi
if $data62 != tb3 then
return -1
endi
if $data70 != @21-10-20 10:00:07.000@ then
return -1
endi
if $data71 != 7 then
return -1
endi
if $data72 != tb3 then
return -1
endi
if $data80 != @21-10-20 10:00:08.000@ then
return -1
endi
if $data81 != 8 then
return -1
endi
if $data82 != tb3 then
return -1
endi
if $data90 != @21-10-20 10:00:09.000@ then
return -1
endi
if $data91 != 9 then
return -1
endi
if $data92 != tb3 then
return -1
endi
sql select interp(c1) from tb1,tb2 where tb1.ts=tb2.ts;
if $rows != 1 then
return -1
endi
if $data00 != @21-10-20 10:00:00.000@ then
return -1
endi
if $data01 != 0 then
return -1
endi
sql select interp(c1) from tb1,tb2 where tb1.ts=tb2.ts range('2021-10-20 10:00:00','2021-10-20 10:00:30');
if $rows != 1 then
return -1
endi
if $data00 != @21-10-20 10:00:00.000@ then
return -1
endi
if $data01 != 0 then
return -1
endi
sql select interp(c1) from tb1,tb2 where tb1.ts=tb2.ts every(1s);
if $rows != 3 then
return -1
endi
if $data00 != @21-10-20 10:00:00.000@ then
return -1
endi
if $data01 != 0 then
return -1
endi
if $data10 != @21-10-20 10:00:06.000@ then
return -1
endi
if $data11 != 6 then
return -1
endi
if $data20 != @21-10-20 10:00:10.000@ then
return -1
endi
if $data21 != 10 then
return -1
endi
sql select interp(c1) from tb1,tb2 where tb1.ts=tb2.ts fill(linear);
if $rows != 1 then
return -1
endi
if $data00 != @21-10-20 10:00:00.000@ then
return -1
endi
if $data01 != 0 then
return -1
endi
sql select interp(c1) from tb1,tb2 where tb1.ts=tb2.ts range('2021-10-20 10:00:00','2021-10-20 10:00:30') fill(next);
if $rows != 1 then
return -1
endi
if $data00 != @21-10-20 10:00:00.000@ then
return -1
endi
if $data01 != 0 then
return -1
endi
sql select interp(c1) from tb1,tb2 where tb1.ts=tb2.ts every(1s) fill(prev);
if $rows != 11 then
return -1
endi
if $data00 != @21-10-20 10:00:00.000@ then
return -1
endi
if $data01 != 0 then
return -1
endi
if $data10 != @21-10-20 10:00:01.000@ then
return -1
endi
if $data11 != 0 then
return -1
endi
if $data20 != @21-10-20 10:00:02.000@ then
return -1
endi
if $data21 != 0 then
return -1
endi
if $data30 != @21-10-20 10:00:03.000@ then
return -1
endi
if $data31 != 0 then
return -1
endi
if $data40 != @21-10-20 10:00:04.000@ then
return -1
endi
if $data41 != 0 then
return -1
endi
if $data50 != @21-10-20 10:00:05.000@ then
return -1
endi
if $data51 != 0 then
return -1
endi
if $data60 != @21-10-20 10:00:06.000@ then
return -1
endi
if $data61 != 6 then
return -1
endi
if $data70 != @21-10-20 10:00:07.000@ then
return -1
endi
if $data71 != 6 then
return -1
endi
if $data80 != @21-10-20 10:00:08.000@ then
return -1
endi
if $data81 != 6 then
return -1
endi
if $data90 != @21-10-20 10:00:09.000@ then
return -1
endi
if $data91 != 6 then
return -1
endi
Reference in a new issue View git blame Copy permalink