sleep 100 sql connect sql use db print execute sql select abs(*) from tb1; sql_error select abs(*) from tb1; print execute sql select abs(*) from tb1; sql_error select abs(*) from tb1; print execute sql select abs(*) from tb1; sql_error select abs(*) from tb1; print execute sql select abs(*) from tb1; sql_error select abs(*) from tb1; print execute sql select abs(*) as a from tb1; sql_error select abs(*) as a from tb1; print execute sql select abs(*) + 1 as a from tb1; sql_error select abs(*) + 1 as a from tb1; print execute sql select abs(tb1.*) + 1 as a from tb1; sql_error select abs(tb1.*) + 1 as a from tb1; print execute sql select abs(*) from tb1; sql_error select abs(*) from tb1; print execute sql select abs(c1) from tb1; sql_error select abs(c1) from tb1; print execute sql select abs(c1) from tb1; sql_error select abs(c1) from tb1; print execute sql select abs(c1 + c2) from tb1; sql_error select abs(c1 + c2) from tb1; print execute sql select abs(13) from tb1; sql select abs(13) from tb1; if $data00 != @13@ then return -1 endi if $data10 != @13@ then return -1 endi if $data20 != @13@ then return -1 endi if $data30 != @13@ then return -1 endi if $data40 != @13@ then return -1 endi if $data50 != @13@ then return -1 endi if $data60 != @13@ then return -1 endi print execute sql select abs(c1) from tb1; sql_error select abs(c1) from tb1; print execute sql select abs(c2) from tb1; sql select abs(c2) from tb1; if $data00 != @1@ then return -1 endi if $data10 != NULL then return -1 endi if $data20 != @2@ then return -1 endi if $data30 != NULL then return -1 endi if $data40 != @4@ then return -1 endi if $data50 != @127@ then return -1 endi if $data60 != @127@ then return -1 endi print execute sql select abs(c3) from tb1; sql select abs(c3) from tb1; if $data00 != @1@ then return -1 endi if $data10 != NULL then return -1 endi if $data20 != NULL then return -1 endi if $data30 != @3@ then return -1 endi if $data40 != @4@ then return -1 endi if $data50 != @32767@ then return -1 endi if $data60 != @32767@ then return -1 endi print execute sql select abs(c4) from tb1; sql select abs(c4) from tb1; if $data00 != @1@ then return -1 endi if $data10 != NULL then return -1 endi if $data20 != @2@ then return -1 endi if $data30 != NULL then return -1 endi if $data40 != @4@ then return -1 endi if $data50 != @2147483647@ then return -1 endi if $data60 != @2147483647@ then return -1 endi print execute sql select abs(c5) from tb1; sql select abs(c5) from tb1; if $data00 != @1@ then return -1 endi if $data10 != NULL then return -1 endi if $data20 != NULL then return -1 endi if $data30 != @3@ then return -1 endi if $data40 != @4@ then return -1 endi if $data50 != @9223372036854775807@ then return -1 endi if $data60 != @9223372036854775807@ then return -1 endi print execute sql select abs(c6) from tb1; sql select abs(c6) from tb1; if $data00 != @1.000000000@ then return -1 endi if $data10 != NULL then return -1 endi if $data20 != @2.000000000@ then return -1 endi if $data30 != NULL then return -1 endi if $data40 != @4.000000000@ then return -1 endi if $data50 != @340282346638528859811704183484516925440.000000000@ then return -1 endi if $data60 != @340282346638528859811704183484516925440.000000000@ then return -1 endi print execute sql select abs(c7) from tb1; sql select abs(c7) from tb1; if $data00 != @1.000000000@ then return -1 endi if $data10 != NULL then return -1 endi if $data20 != NULL then return -1 endi if $data30 != @3.000000000@ then return -1 endi if $data40 != @4.000000000@ then return -1 endi if $data50 != @179769000000000006323030492138942643493033036433685336215410983289126434148906289940615299632196609445533816320312774433484859900046491141051651091672734470972759941382582304802812882753059262973637182942535982636884444611376868582636745405553206881859340916340092953230149901406738427651121855107737424232448.000000000@ then return -1 endi if $data60 != @179769000000000006323030492138942643493033036433685336215410983289126434148906289940615299632196609445533816320312774433484859900046491141051651091672734470972759941382582304802812882753059262973637182942535982636884444611376868582636745405553206881859340916340092953230149901406738427651121855107737424232448.000000000@ then return -1 endi print execute sql select abs(c8) from tb1; sql_error select abs(c8) from tb1; print execute sql select abs(c9) from tb1; sql_error select abs(c9) from tb1; print execute sql select abs(c10) from tb1; sql select abs(c10) from tb1; if $data00 != @1@ then return -1 endi if $data10 != NULL then return -1 endi if $data20 != @2@ then return -1 endi if $data30 != NULL then return -1 endi if $data40 != @4@ then return -1 endi if $data50 != @254@ then return -1 endi if $data60 != @0@ then return -1 endi print execute sql select abs(c11) from tb1; sql select abs(c11) from tb1; if $data00 != @1@ then return -1 endi if $data10 != NULL then return -1 endi if $data20 != NULL then return -1 endi if $data30 != @3@ then return -1 endi if $data40 != @4@ then return -1 endi if $data50 != @65534@ then return -1 endi if $data60 != @0@ then return -1 endi print execute sql select abs(c12) from tb1; sql select abs(c12) from tb1; if $data00 != @1@ then return -1 endi if $data10 != NULL then return -1 endi if $data20 != @2@ then return -1 endi if $data30 != NULL then return -1 endi if $data40 != @4@ then return -1 endi if $data50 != @4294967294@ then return -1 endi if $data60 != @0@ then return -1 endi print execute sql select abs(c13) from tb1; sql select abs(c13) from tb1; if $data00 != @1@ then return -1 endi if $data10 != NULL then return -1 endi if $data20 != NULL then return -1 endi if $data30 != @3@ then return -1 endi if $data40 != @4@ then return -1 endi if $data50 != @9223372036854775807@ then return -1 endi if $data60 != @0@ then return -1 endi print execute sql select abs(12345678900000000000000000) from tb1; sql_error select abs(12345678900000000000000000) from tb1; print execute sql select distinct abs(123) from tb1; sql_error select distinct abs(123) from tb1; print execute sql select abs(t1) from stb1; sql_error select abs(t1) from stb1; print execute sql select abs(c1),avg(c3) from tb1; sql_error select abs(c1),avg(c3) from tb1; print execute sql select abs(c1),top(c3,1) from tb1; sql_error select abs(c1),top(c3,1) from tb1; print execute sql select abs(c2+c3) from tb1 session(ts, 1s); sql_error select abs(c2+c3) from tb1 session(ts, 1s); print execute sql select abs(c2+c3) from tb1 STATE_WINDOW(c1); sql_error select abs(c2+c3) from tb1 STATE_WINDOW(c1); print execute sql select abs(c2+c3) from tb1 interval(1s) sliding(1s) fill(NULL); sql_error select abs(c2+c3) from tb1 interval(1s) sliding(1s) fill(NULL); print execute sql select abs(c2+c3) from stb1 group by t1; sql_error select abs(c2+c3) from stb1 group by t1; print execute sql select abs(c2+c3) from stb1 group by ts; sql_error select abs(c2+c3) from stb1 group by ts; print execute sql select abs(c2+c3) from stb1 group by c1; sql_error select abs(c2+c3) from stb1 group by c1; print execute sql select abs(c2+c3) from stb1 group by tbname; sql_error select abs(c2+c3) from stb1 group by tbname; print execute sql select abs(c2+c3) from tb1 order by c2; sql_error select abs(c2+c3) from tb1 order by c2; print execute sql select abs(c8),abs(c9) from tbn; sql_error select abs(c8),abs(c9) from tbn; print execute sql select abs(ts) from (select avg(c2) as a from stb1 interval(1s)); sql_error select abs(ts) from (select avg(c2) as a from stb1 interval(1s)); print execute sql select abs(a) from (select abs(c2) as a from tb1); sql select abs(a) from (select abs(c2) as a from tb1); if $data00 != @1@ then return -1 endi if $data10 != NULL then return -1 endi if $data20 != @2@ then return -1 endi if $data30 != NULL then return -1 endi if $data40 != @4@ then return -1 endi if $data50 != @127@ then return -1 endi if $data60 != @127@ then return -1 endi print execute sql select abs("abc") from tb1; sql_error select abs("abc") from tb1; print execute sql select abs(c2 + c3) from tb1; sql select abs(c2 + c3) from tb1; if $data00 != @2.000000000@ then return -1 endi if $data10 != NULL then return -1 endi if $data20 != NULL then return -1 endi if $data30 != NULL then return -1 endi if $data40 != @8.000000000@ then return -1 endi if $data50 != @32894.000000000@ then return -1 endi if $data60 != @32894.000000000@ then return -1 endi print execute sql select abs((c2 + c3)) from tb1; sql select abs((c2 + c3)) from tb1; if $data00 != @2.000000000@ then return -1 endi if $data10 != NULL then return -1 endi if $data20 != NULL then return -1 endi if $data30 != NULL then return -1 endi if $data40 != @8.000000000@ then return -1 endi if $data50 != @32894.000000000@ then return -1 endi if $data60 != @32894.000000000@ then return -1 endi print execute sql select abs((c2 * c3)+c4-6) from tb1; sql select abs((c2 * c3)+c4-6) from tb1; if $data00 != @4.000000000@ then return -1 endi if $data10 != NULL then return -1 endi if $data20 != NULL then return -1 endi if $data30 != NULL then return -1 endi if $data40 != @14.000000000@ then return -1 endi if $data50 != @2151645050.000000000@ then return -1 endi if $data60 != @2143322244.000000000@ then return -1 endi print execute sql select abs(11)+c2 from tb1; sql select abs(11)+c2 from tb1; if $data00 != @12.000000000@ then return -1 endi if $data10 != NULL then return -1 endi if $data20 != @13.000000000@ then return -1 endi if $data30 != NULL then return -1 endi if $data40 != @15.000000000@ then return -1 endi if $data50 != @138.000000000@ then return -1 endi if $data60 != @-116.000000000@ then return -1 endi print execute sql select abs(c1)+c2 from tb1; sql_error select abs(c1)+c2 from tb1; print execute sql select abs(c2)+11 from tb1; sql select abs(c2)+11 from tb1; if $data00 != @12.000000000@ then return -1 endi if $data10 != NULL then return -1 endi if $data20 != @13.000000000@ then return -1 endi if $data30 != NULL then return -1 endi if $data40 != @15.000000000@ then return -1 endi if $data50 != @138.000000000@ then return -1 endi if $data60 != @138.000000000@ then return -1 endi print execute sql select abs(c1),c1,c2 from tb1; sql_error select abs(c1),c1,c2 from tb1; print execute sql select abs(c1),t1,ts,tbname,_C0,_c0 from tb1; sql_error select abs(c1),t1,ts,tbname,_C0,_c0 from tb1; print execute sql select abs(c1),floor(c3) from tb1; sql_error select abs(c1),floor(c3) from tb1; print execute sql select abs(c1),abs(c2+c3) from tb1; sql_error select abs(c1),abs(c2+c3) from tb1; print execute sql select abs(c2+c3) from tb1 where c2 is not null and c3 is not null; sql select abs(c2+c3) from tb1 where c2 is not null and c3 is not null; if $data00 != @2.000000000@ then return -1 endi if $data10 != @8.000000000@ then return -1 endi if $data20 != @32894.000000000@ then return -1 endi if $data30 != @32894.000000000@ then return -1 endi print execute sql select abs(c2) from tb1 order by ts desc; sql select abs(c2) from tb1 order by ts desc; if $data00 != @127@ then return -1 endi if $data10 != @127@ then return -1 endi if $data20 != @4@ then return -1 endi if $data30 != NULL then return -1 endi if $data40 != @2@ then return -1 endi if $data50 != NULL then return -1 endi if $data60 != @1@ then return -1 endi print execute sql select abs(c2+c3) from tb1 order by ts desc; sql select abs(c2+c3) from tb1 order by ts desc; if $data00 != @32894.000000000@ then return -1 endi if $data10 != @32894.000000000@ then return -1 endi if $data20 != @8.000000000@ then return -1 endi if $data30 != NULL then return -1 endi if $data40 != NULL then return -1 endi if $data50 != NULL then return -1 endi if $data60 != @2.000000000@ then return -1 endi print execute sql select abs(c2+c3) from tb1 order by ts desc limit 3 offset 2; sql select abs(c2+c3) from tb1 order by ts desc limit 3 offset 2; if $data00 != @8.000000000@ then return -1 endi if $data10 != NULL then return -1 endi if $data20 != NULL then return -1 endi print execute sql select abs(c2) from stb1; sql select abs(c2) from stb1; if $data00 != @1@ then if $data10 != NULL then return -1 endi endi if $data20 != @2@ then if $data30 != NULL then return -1 endi endi if $data40 != @4@ then if $data50 != @127@ then return -1 endi endi if $data60 != @127@ then if $data70 != @1@ then return -1 endi endi if $data80 != @2@ then if $data90 != @3@ then return -1 endi endi print execute sql select abs(c2) from stb1 order by ts desc; sql select abs(c2) from stb1 order by ts desc; if $data00 != @7@ then if $data00 != @127@ then return -1 endi endi if $data20 != @6@ then if $data20 != @127@ then return -1 endi endi if $data40 != @5@ then if $data40 != @4@ then return -1 endi endi if $data60 != @4@ then if $data60 != NULL then return -1 endi endi if $data80 != @3@ then if $data80 != @2@ then return -1 endi endi print execute sql select abs(c4),t1 from stb1 order by ts desc; sql select abs(c4),t1 from stb1 order by ts desc; if $data00 != @7@ then if $data00 != @2147483647@ then return -1 endi endi if $data01 != @2@ then if $data01 != @1@ then return -1 endi endi if $data20 != @6@ then if $data20 != @2147483647@ then return -1 endi endi if $data21 != @2@ then if $data21 != @1@ then return -1 endi endi if $data40 != @5@ then if $data40 != @4@ then return -1 endi endi if $data41 != @2@ then if $data41 != @1@ then return -1 endi endi if $data60 != @4@ then if $data60 != NULL then return -1 endi endi if $data61 != @2@ then if $data61 != @1@ then return -1 endi endi if $data80 != @2@ then if $data80 != @2@ then return -1 endi endi if $data81 != @2@ then if $data81 != @1@ then return -1 endi endi print execute sql select abs(c3),tbname from stb1; sql select abs(c3),tbname from stb1; if $data00 != @1@ then return -1 endi if $data01 != @tb1@ then return -1 endi if $data10 != NULL then return -1 endi if $data11 != @tb1@ then return -1 endi if $data20 != NULL then return -1 endi if $data21 != @tb1@ then return -1 endi if $data30 != @3@ then return -1 endi if $data31 != @tb1@ then return -1 endi if $data40 != @4@ then return -1 endi if $data41 != @tb1@ then return -1 endi if $data50 != @32767@ then return -1 endi if $data51 != @tb1@ then return -1 endi if $data60 != @32767@ then return -1 endi if $data61 != @tb1@ then return -1 endi if $data70 != @1@ then return -1 endi if $data71 != @tb2@ then return -1 endi if $data80 != @2@ then return -1 endi if $data81 != @tb2@ then return -1 endi if $data90 != @3@ then return -1 endi if $data91 != @tb2@ then return -1 endi print execute sql select abs(c3),tbname from stb1 where t1 > 1; sql select abs(c3),tbname from stb1 where t1 > 1; if $data00 != @1@ then return -1 endi if $data01 != @tb2@ then return -1 endi if $data10 != @2@ then return -1 endi if $data11 != @tb2@ then return -1 endi if $data20 != @3@ then return -1 endi if $data21 != @tb2@ then return -1 endi if $data30 != @4@ then return -1 endi if $data31 != @tb2@ then return -1 endi if $data40 != @5@ then return -1 endi if $data41 != @tb2@ then return -1 endi if $data50 != @6@ then return -1 endi if $data51 != @tb2@ then return -1 endi if $data60 != @7@ then return -1 endi if $data61 != @tb2@ then return -1 endi print execute sql select abs(c8),abs(c9) from tbn; sql_error select abs(c8),abs(c9) from tbn; print execute sql select abs(c8),abs(c9) from tbn order by ts desc; sql_error select abs(c8),abs(c9) from tbn order by ts desc; print execute sql select abs(abs(c8)) from tbn; sql_error select abs(abs(c8)) from tbn; print execute sql select abs(a) from (select avg(c2) as a from stb1 interval(1s)); sql select abs(a) from (select avg(c2) as a from stb1 interval(1s)); if $data00 != @1.000000000@ then return -1 endi if $data10 != @2.000000000@ then return -1 endi if $data20 != @2.500000000@ then return -1 endi if $data30 != @4.000000000@ then return -1 endi if $data40 != @4.500000000@ then return -1 endi if $data50 != @66.500000000@ then return -1 endi if $data60 != @60.000000000@ then return -1 endi print execute sql select abs(c2) from (select * from stb1); sql select abs(c2) from (select * from stb1); if $data00 != @1@ then return -1 endi if $data10 != NULL then return -1 endi if $data20 != @2@ then return -1 endi if $data30 != NULL then return -1 endi if $data40 != @4@ then return -1 endi if $data50 != @127@ then return -1 endi if $data60 != @127@ then return -1 endi if $data70 != @1@ then return -1 endi if $data80 != @2@ then return -1 endi if $data90 != @3@ then return -1 endi print execute sql select abs(a) from (select avg(c2) as a from stb1 where ts >= '2021-11-11 09:00:00.000' and ts <= '2021-11-11 09:00:09.000' interval(1s) fill(null)); sql select abs(a) from (select avg(c2) as a from stb1 where ts >= '2021-11-11 09:00:00.000' and ts <= '2021-11-11 09:00:09.000' interval(1s) fill(null)); if $data00 != @1.000000000@ then return -1 endi if $data10 != @2.000000000@ then return -1 endi if $data20 != @2.500000000@ then return -1 endi if $data30 != @4.000000000@ then return -1 endi if $data40 != @4.500000000@ then return -1 endi if $data50 != @66.500000000@ then return -1 endi if $data60 != @60.000000000@ then return -1 endi if $data70 != NULL then return -1 endi if $data80 != NULL then return -1 endi if $data90 != NULL then return -1 endi print execute sql select abs(a) from (select avg(c2) as a from stb1 where ts >= '2021-11-11 09:00:00.000' and ts <= '2021-11-11 09:00:09.000' interval(1s) fill(null)) order by ts; sql select abs(a) from (select avg(c2) as a from stb1 where ts >= '2021-11-11 09:00:00.000' and ts <= '2021-11-11 09:00:09.000' interval(1s) fill(null)) order by ts; if $data00 != @1.000000000@ then return -1 endi if $data10 != @2.000000000@ then return -1 endi if $data20 != @2.500000000@ then return -1 endi if $data30 != @4.000000000@ then return -1 endi if $data40 != @4.500000000@ then return -1 endi if $data50 != @66.500000000@ then return -1 endi if $data60 != @60.000000000@ then return -1 endi if $data70 != NULL then return -1 endi if $data80 != NULL then return -1 endi if $data90 != NULL then return -1 endi print execute sql select abs(a) from (select avg(c2) as a from stb1 where ts >= '2021-11-11 09:00:00.000' and ts <= '2021-11-11 09:00:09.000' interval(1s) fill(null)) order by ts desc; sql select abs(a) from (select avg(c2) as a from stb1 where ts >= '2021-11-11 09:00:00.000' and ts <= '2021-11-11 09:00:09.000' interval(1s) fill(null)) order by ts desc; if $data00 != NULL then return -1 endi if $data10 != NULL then return -1 endi if $data20 != NULL then return -1 endi if $data30 != @60.000000000@ then return -1 endi if $data40 != @66.500000000@ then return -1 endi if $data50 != @4.500000000@ then return -1 endi if $data60 != @4.000000000@ then return -1 endi if $data70 != @2.500000000@ then return -1 endi if $data80 != @2.000000000@ then return -1 endi if $data90 != @1.000000000@ then return -1 endi print execute sql select abs(a) from (select avg(c2) as a from stb1 where ts >= '2021-11-11 09:00:00.000' and ts <= '2021-11-11 09:00:09.000' interval(1s) fill(null)) order by a desc; sql select abs(a) from (select avg(c2) as a from stb1 where ts >= '2021-11-11 09:00:00.000' and ts <= '2021-11-11 09:00:09.000' interval(1s) fill(null)) order by a desc; if $data00 != NULL then return -1 endi if $data10 != NULL then return -1 endi if $data20 != NULL then return -1 endi if $data30 != @66.500000000@ then return -1 endi if $data40 != @4.500000000@ then return -1 endi if $data50 != @4.000000000@ then return -1 endi if $data60 != @2.500000000@ then return -1 endi if $data70 != @2.000000000@ then return -1 endi if $data80 != @1.000000000@ then return -1 endi if $data90 != @60.000000000@ then return -1 endi print execute sql select abs(a) from (select avg(c2) as a from stb1 where ts >= '2021-11-11 09:00:00.000' and ts <= '2021-11-11 09:00:09.000' interval(1s) fill(null)) order by a; sql select abs(a) from (select avg(c2) as a from stb1 where ts >= '2021-11-11 09:00:00.000' and ts <= '2021-11-11 09:00:09.000' interval(1s) fill(null)) order by a; if $data00 != @60.000000000@ then return -1 endi if $data10 != @1.000000000@ then return -1 endi if $data20 != @2.000000000@ then return -1 endi if $data30 != @2.500000000@ then return -1 endi if $data40 != @4.000000000@ then return -1 endi if $data50 != @4.500000000@ then return -1 endi if $data60 != @66.500000000@ then return -1 endi if $data70 != NULL then return -1 endi if $data80 != NULL then return -1 endi if $data90 != NULL then return -1 endi print execute sql select abs(a) from (select abs(c2) as a from tb1); sql select abs(a) from (select abs(c2) as a from tb1); if $data00 != @1@ then return -1 endi if $data10 != NULL then return -1 endi if $data20 != @2@ then return -1 endi if $data30 != NULL then return -1 endi if $data40 != @4@ then return -1 endi if $data50 != @127@ then return -1 endi if $data60 != @127@ then return -1 endi print execute sql select abs(tb1.c3),abs(tb2.c3) from tb1,tb2 where tb1.ts=tb2.ts; sql select abs(tb1.c3),abs(tb2.c3) from tb1,tb2 where tb1.ts=tb2.ts; if $data00 != @1@ then return -1 endi if $data01 != @1@ then return -1 endi if $data10 != NULL then return -1 endi if $data11 != @2@ then return -1 endi if $data20 != NULL then return -1 endi if $data21 != @3@ then return -1 endi if $data30 != @3@ then return -1 endi if $data31 != @4@ then return -1 endi if $data40 != @4@ then return -1 endi if $data41 != @5@ then return -1 endi if $data50 != @32767@ then return -1 endi if $data51 != @6@ then return -1 endi if $data60 != @32767@ then return -1 endi if $data61 != @7@ then return -1 endi print execute sql select abs(c3) from tb1 union all select abs(c3) from tb2; sql select abs(c3) from tb1 union all select abs(c3) from tb2; if $data00 != @1@ then return -1 endi if $data10 != NULL then return -1 endi if $data20 != NULL then return -1 endi if $data30 != @3@ then return -1 endi if $data40 != @4@ then return -1 endi if $data50 != @32767@ then return -1 endi if $data60 != @32767@ then return -1 endi if $data70 != @1@ then return -1 endi if $data80 != @2@ then return -1 endi if $data90 != @3@ then return -1 endi