sleep 100 sql connect sql use db print execute sql select pow(c2,*) from tb1; sql_error select pow(c2,*) from tb1; print execute sql select pow(c2,*) from tb1; sql_error select pow(c2,*) from tb1; print execute sql select pow(c2,*) from tb1; sql_error select pow(c2,*) from tb1; print execute sql select pow(c2,*) from tb1; sql_error select pow(c2,*) from tb1; print execute sql select pow(c2,*) as a from tb1; sql_error select pow(c2,*) as a from tb1; print execute sql select pow(c2,*) + 1 as a from tb1; sql_error select pow(c2,*) + 1 as a from tb1; print execute sql select pow(c2,tb1.*) + 1 as a from tb1; sql_error select pow(c2,tb1.*) + 1 as a from tb1; print execute sql select pow(c2,*) from tb1; sql_error select pow(c2,*) from tb1; print execute sql select pow(c2,c1) from tb1; sql_error select pow(c2,c1) from tb1; print execute sql select pow(c2,c1) from tb1; sql_error select pow(c2,c1) from tb1; print execute sql select pow(c2,c1 + c2) from tb1; sql_error select pow(c2,c1 + c2) from tb1; print execute sql select pow(c2,13) from tb1; sql select pow(c2,13) from tb1; if $data00 != @1.000000000@ then return -1 endi if $data10 != @NULL@ then return -1 endi if $data20 != @8192.000000000@ then return -1 endi if $data30 != @NULL@ then return -1 endi if $data40 != @67108864.000000000@ then return -1 endi if $data50 != @2235879388560037013354446848.000000000@ then return -1 endi if $data60 != @-2235879388560037013354446848.000000000@ then return -1 endi print execute sql select pow(c2,c1) from tb1; sql_error select pow(c2,c1) from tb1; print execute sql select pow(c2,c2) from tb1; sql select pow(c2,c2) from tb1; if $data00 != @1.000000000@ then return -1 endi if $data10 != @NULL@ then return -1 endi if $data20 != @4.000000000@ then return -1 endi if $data30 != @NULL@ then return -1 endi if $data40 != @256.000000000@ then return -1 endi if $data50 != @1524307411995722675302034438441039929638133977529255166488930956750631981496706568536830801887788243768717590100078636207586147400582763177366354597171395424352865739982333218252608952069997640848048552956054564019622410252548018541775390307932677684494157475792027648.000000000@ then return -1 endi if $data60 != @-0.000000000@ then return -1 endi print execute sql select pow(c2,c3) from tb1; sql select pow(c2,c3) 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 != @NULL@ then return -1 endi if $data40 != @256.000000000@ then return -1 endi if $data50 != @inf@ then return -1 endi if $data60 != @-0.000000000@ then return -1 endi print execute sql select pow(c2,c4) from tb1; sql select pow(c2,c4) from tb1; if $data00 != @1.000000000@ then return -1 endi if $data10 != @NULL@ then return -1 endi if $data20 != @4.000000000@ then return -1 endi if $data30 != @NULL@ then return -1 endi if $data40 != @256.000000000@ then return -1 endi if $data50 != @inf@ then return -1 endi if $data60 != @-0.000000000@ then return -1 endi print execute sql select pow(c2,c5) from tb1; sql select pow(c2,c5) 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 != @NULL@ then return -1 endi if $data40 != @256.000000000@ then return -1 endi if $data50 != @inf@ then return -1 endi if $data60 != @0.000000000@ then return -1 endi print execute sql select pow(c2,c6) from tb1; sql select pow(c2,c6) from tb1; if $data00 != @1.000000000@ then return -1 endi if $data10 != @NULL@ then return -1 endi if $data20 != @4.000000000@ then return -1 endi if $data30 != @NULL@ then return -1 endi if $data40 != @256.000000000@ then return -1 endi if $data50 != @inf@ then return -1 endi if $data60 != @0.000000000@ then return -1 endi print execute sql select pow(c2,c7) from tb1; sql select pow(c2,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 != @NULL@ then return -1 endi if $data40 != @256.000000000@ then return -1 endi if $data50 != @inf@ then return -1 endi if $data60 != @0.000000000@ then return -1 endi print execute sql select pow(c2,c8) from tb1; sql_error select pow(c2,c8) from tb1; print execute sql select pow(c2,c9) from tb1; sql_error select pow(c2,c9) from tb1; print execute sql select pow(c2,c10) from tb1; sql select pow(c2,c10) from tb1; if $data00 != @1.000000000@ then return -1 endi if $data10 != @NULL@ then return -1 endi if $data20 != @4.000000000@ then return -1 endi if $data30 != @NULL@ then return -1 endi if $data40 != @256.000000000@ then return -1 endi if $data50 != @inf@ then return -1 endi if $data60 != @1.000000000@ then return -1 endi print execute sql select pow(c2,c11) from tb1; sql select pow(c2,c11) 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 != @NULL@ then return -1 endi if $data40 != @256.000000000@ then return -1 endi if $data50 != @inf@ then return -1 endi if $data60 != @1.000000000@ then return -1 endi print execute sql select pow(c2,c12) from tb1; sql select pow(c2,c12) from tb1; if $data00 != @1.000000000@ then return -1 endi if $data10 != @NULL@ then return -1 endi if $data20 != @4.000000000@ then return -1 endi if $data30 != @NULL@ then return -1 endi if $data40 != @256.000000000@ then return -1 endi if $data50 != @inf@ then return -1 endi if $data60 != @1.000000000@ then return -1 endi print execute sql select pow(c2,c13) from tb1; sql select pow(c2,c13) 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 != @NULL@ then return -1 endi if $data40 != @256.000000000@ then return -1 endi if $data50 != @inf@ then return -1 endi if $data60 != @1.000000000@ then return -1 endi print execute sql select pow(c2,12345678900000000000000000) from tb1; sql_error select pow(c2,12345678900000000000000000) from tb1; print execute sql select distinct pow(c2,123) from tb1; sql_error select distinct pow(c2,123) from tb1; print execute sql select pow(c2,t1) from stb1; sql_error select pow(c2,t1) from stb1; print execute sql select pow(c2,c1),avg(c3) from tb1; sql_error select pow(c2,c1),avg(c3) from tb1; print execute sql select pow(c2,c1),top(c3,1) from tb1; sql_error select pow(c2,c1),top(c3,1) from tb1; print execute sql select pow(c2,c2+c3) from tb1 session(ts, 1s); sql_error select pow(c2,c2+c3) from tb1 session(ts, 1s); print execute sql select pow(c2,c2+c3) from tb1 STATE_WINDOW(c1); sql_error select pow(c2,c2+c3) from tb1 STATE_WINDOW(c1); print execute sql select pow(c2,c2+c3) from tb1 interval(1s) sliding(1s) fill(NULL); sql_error select pow(c2,c2+c3) from tb1 interval(1s) sliding(1s) fill(NULL); print execute sql select pow(c2,c2+c3) from stb1 group by t1; sql_error select pow(c2,c2+c3) from stb1 group by t1; print execute sql select pow(c2,c2+c3) from stb1 group by ts; sql_error select pow(c2,c2+c3) from stb1 group by ts; print execute sql select pow(c2,c2+c3) from stb1 group by c1; sql_error select pow(c2,c2+c3) from stb1 group by c1; print execute sql select pow(c2,c2+c3) from stb1 group by tbname; sql_error select pow(c2,c2+c3) from stb1 group by tbname; print execute sql select pow(c2,c2+c3) from tb1 order by c2; sql_error select pow(c2,c2+c3) from tb1 order by c2; print execute sql select pow(c2,c8),pow(c2,c9) from tbn; sql_error select pow(c2,c8),pow(c2,c9) from tbn; print execute sql select pow(c2,ts) from (select avg(c2) as a from stb1 interval(1s)); sql_error select pow(c2,ts) from (select avg(c2) as a from stb1 interval(1s)); print execute sql select pow(c2,a) from (select pow(c2,c2) as a from tb1); sql_error select pow(c2,a) from (select pow(c2,c2) as a from tb1); print execute sql select pow(c2,"abc") from tb1; sql_error select pow(c2,"abc") from tb1; print execute sql select pow(c2,c2 + c3) from tb1; sql select pow(c2,c2 + c3) 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 != @NULL@ then return -1 endi if $data40 != @65536.000000000@ then return -1 endi if $data50 != @inf@ then return -1 endi if $data60 != @0.000000000@ then return -1 endi print execute sql select pow(c2,(c2 + c3)) from tb1; sql select pow(c2,(c2 + c3)) 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 != @NULL@ then return -1 endi if $data40 != @65536.000000000@ then return -1 endi if $data50 != @inf@ then return -1 endi if $data60 != @0.000000000@ then return -1 endi print execute sql select pow(c2,(c2 * c3)+c4-6) from tb1; sql select pow(c2,(c2 * c3)+c4-6) 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 != @NULL@ then return -1 endi if $data40 != @268435456.000000000@ then return -1 endi if $data50 != @inf@ then return -1 endi if $data60 != @0.000000000@ then return -1 endi print execute sql select pow(c2,11)+c2 from tb1; sql select pow(c2,11)+c2 from tb1; if $data00 != @2.000000000@ then return -1 endi if $data10 != @NULL@ then return -1 endi if $data20 != @2050.000000000@ then return -1 endi if $data30 != @NULL@ then return -1 endi if $data40 != @4194308.000000000@ then return -1 endi if $data50 != @138624799340320985710592.000000000@ then return -1 endi if $data60 != @-138624799340320985710592.000000000@ then return -1 endi print execute sql select pow(c2,c1)+c2 from tb1; sql_error select pow(c2,c1)+c2 from tb1; print execute sql select pow(c2,c2)+11 from tb1; sql select pow(c2,c2)+11 from tb1; if $data00 != @12.000000000@ then return -1 endi if $data10 != @NULL@ then return -1 endi if $data20 != @15.000000000@ then return -1 endi if $data30 != @NULL@ then return -1 endi if $data40 != @267.000000000@ then return -1 endi if $data50 != @1524307411995722675302034438441039929638133977529255166488930956750631981496706568536830801887788243768717590100078636207586147400582763177366354597171395424352865739982333218252608952069997640848048552956054564019622410252548018541775390307932677684494157475792027648.000000000@ then return -1 endi if $data60 != @11.000000000@ then return -1 endi print execute sql select pow(c2,c1),c1,c2 from tb1; sql_error select pow(c2,c1),c1,c2 from tb1; print execute sql select pow(c2,c1),t1,ts,tbname,_C0,_c0 from tb1; sql_error select pow(c2,c1),t1,ts,tbname,_C0,_c0 from tb1; print execute sql select pow(c2,c1),floor(c3) from tb1; sql_error select pow(c2,c1),floor(c3) from tb1; print execute sql select pow(c2,c1),pow(c2,c2+c3) from tb1; sql_error select pow(c2,c1),pow(c2,c2+c3) from tb1; print execute sql select pow(c2,c2+c3) from tb1 where c2 is not null and c3 is not null; sql select pow(c2,c2+c3) from tb1 where c2 is not null and c3 is not null; if $data00 != @1.000000000@ then return -1 endi if $data10 != @65536.000000000@ then return -1 endi if $data20 != @inf@ then return -1 endi if $data30 != @0.000000000@ then return -1 endi print execute sql select pow(c2,c2) from tb1 order by ts desc; sql select pow(c2,c2) from tb1 order by ts desc; if $data00 != @-0.000000000@ then return -1 endi if $data10 != @1524307411995722675302034438441039929638133977529255166488930956750631981496706568536830801887788243768717590100078636207586147400582763177366354597171395424352865739982333218252608952069997640848048552956054564019622410252548018541775390307932677684494157475792027648.000000000@ then return -1 endi if $data20 != @256.000000000@ then return -1 endi if $data30 != @NULL@ then return -1 endi if $data40 != @4.000000000@ then return -1 endi if $data50 != @NULL@ then return -1 endi if $data60 != @1.000000000@ then return -1 endi print execute sql select pow(c2,c2+c3) from tb1 order by ts desc; sql select pow(c2,c2+c3) from tb1 order by ts desc; if $data00 != @0.000000000@ then return -1 endi if $data10 != @inf@ then return -1 endi if $data20 != @65536.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 != @1.000000000@ then return -1 endi print execute sql select pow(c2,c2+c3) from tb1 order by ts desc limit 3 offset 2; sql select pow(c2,c2+c3) from tb1 order by ts desc limit 3 offset 2; if $data00 != @65536.000000000@ then return -1 endi if $data10 != @NULL@ then return -1 endi if $data20 != @NULL@ then return -1 endi print execute sql select pow(c2,c2) from stb1; sql select pow(c2,c2) from stb1; if $data00 != @1.000000000@ then return -1 endi if $data10 != @NULL@ then return -1 endi if $data20 != @4.000000000@ then return -1 endi if $data30 != @NULL@ then return -1 endi if $data40 != @256.000000000@ then return -1 endi if $data50 != @1524307411995722675302034438441039929638133977529255166488930956750631981496706568536830801887788243768717590100078636207586147400582763177366354597171395424352865739982333218252608952069997640848048552956054564019622410252548018541775390307932677684494157475792027648.000000000@ then return -1 endi if $data60 != @-0.000000000@ then return -1 endi if $data70 != @1.000000000@ then return -1 endi if $data80 != @4.000000000@ then return -1 endi if $data90 != @27.000000000@ then return -1 endi print execute sql select pow(c2,c2) from stb1 order by ts desc; sql select pow(c2,c2) from stb1 order by ts desc; if $data00 != @823543.000000000@ then if $data00 != @-0.000000000@ then return -1 endi endi if $data20 != @46656.000000000@ then if $data20 != @1524307411995722675302034438441039929638133977529255166488930956750631981496706568536830801887788243768717590100078636207586147400582763177366354597171395424352865739982333218252608952069997640848048552956054564019622410252548018541775390307932677684494157475792027648.000000000@ then return -1 endi endi if $data40 != @3125.000000000@ then if $data40 != @256.000000000@ then return -1 endi endi if $data60 != @256.000000000@ then if $data60 != @NULL@ then return -1 endi endi if $data80 != @27.000000000@ then if $data80 != @4.000000000@ then return -1 endi endi print execute sql select pow(c2,c4),t1 from stb1 order by ts desc; sql select pow(c2,c4),t1 from stb1 order by ts desc; if $data00 != @823543.000000000@ then if $data00 != @-0.000000000@ then return -1 endi endi if $data01 != @2@ then if $data01 != @1@ then return -1 endi endi if $data20 != @46656.000000000@ then if $data20 != @inf@ then return -1 endi endi if $data21 != @2@ then if $data21 != @1@ then return -1 endi endi if $data40 != @3125.000000000@ then if $data40 != @256.000000000@ then return -1 endi endi if $data41 != @2@ then if $data41 != @1@ then return -1 endi endi if $data60 != @256.000000000@ then if $data60 != @NULL@ then return -1 endi endi if $data61 != @2@ then if $data61 != @1@ then return -1 endi endi if $data80 != @9.000000000@ then if $data80 != @4.000000000@ then return -1 endi endi if $data81 != @2@ then if $data81 != @1@ then return -1 endi endi print execute sql select pow(c2,c3),tbname from stb1; sql select pow(c2,c3),tbname from stb1; if $data00 != @1.000000000@ 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 != @NULL@ then return -1 endi if $data31 != @tb1@ then return -1 endi if $data40 != @256.000000000@ then return -1 endi if $data41 != @tb1@ then return -1 endi if $data50 != @inf@ then return -1 endi if $data51 != @tb1@ then return -1 endi if $data60 != @-0.000000000@ then return -1 endi if $data61 != @tb1@ then return -1 endi if $data70 != @1.000000000@ then return -1 endi if $data71 != @tb2@ then return -1 endi if $data80 != @4.000000000@ then return -1 endi if $data81 != @tb2@ then return -1 endi if $data90 != @27.000000000@ then return -1 endi if $data91 != @tb2@ then return -1 endi print execute sql select pow(c2,c3),tbname from stb1 where t1 > 1; sql select pow(c2,c3),tbname from stb1 where t1 > 1; if $data00 != @1.000000000@ then return -1 endi if $data01 != @tb2@ then return -1 endi if $data10 != @4.000000000@ then return -1 endi if $data11 != @tb2@ then return -1 endi if $data20 != @27.000000000@ then return -1 endi if $data21 != @tb2@ then return -1 endi if $data30 != @256.000000000@ then return -1 endi if $data31 != @tb2@ then return -1 endi if $data40 != @3125.000000000@ then return -1 endi if $data41 != @tb2@ then return -1 endi if $data50 != @46656.000000000@ then return -1 endi if $data51 != @tb2@ then return -1 endi if $data60 != @823543.000000000@ then return -1 endi if $data61 != @tb2@ then return -1 endi print execute sql select pow(c2,c8),pow(c2,c9) from tbn; sql_error select pow(c2,c8),pow(c2,c9) from tbn; print execute sql select pow(c2,c8),pow(c2,c9) from tbn order by ts desc; sql_error select pow(c2,c8),pow(c2,c9) from tbn order by ts desc; print execute sql select pow(c2,pow(c2,c8)) from tbn; sql_error select pow(c2,pow(c2,c8)) from tbn; print execute sql select pow(c2,a) from (select avg(c2) as a from stb1 interval(1s)); sql_error select pow(c2,a) from (select avg(c2) as a from stb1 interval(1s)); print execute sql select pow(c2,c2) from (select * from stb1); sql select pow(c2,c2) from (select * from stb1); if $data00 != @1.000000000@ then return -1 endi if $data10 != @NULL@ then return -1 endi if $data20 != @4.000000000@ then return -1 endi if $data30 != @NULL@ then return -1 endi if $data40 != @256.000000000@ then return -1 endi if $data50 != @1524307411995722675302034438441039929638133977529255166488930956750631981496706568536830801887788243768717590100078636207586147400582763177366354597171395424352865739982333218252608952069997640848048552956054564019622410252548018541775390307932677684494157475792027648.000000000@ then return -1 endi if $data60 != @-0.000000000@ then return -1 endi if $data70 != @1.000000000@ then return -1 endi if $data80 != @4.000000000@ then return -1 endi if $data90 != @27.000000000@ then return -1 endi print execute sql select pow(c2,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_error select pow(c2,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)); print execute sql select pow(c2,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_error select pow(c2,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; print execute sql select pow(c2,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_error select pow(c2,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; print execute sql select pow(c2,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_error select pow(c2,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; print execute sql select pow(c2,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_error select pow(c2,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; print execute sql select pow(c2,a) from (select pow(c2,c2) as a from tb1); sql_error select pow(c2,a) from (select pow(c2,c2) as a from tb1); print execute sql select pow(c2,tb1.c3),pow(c2,tb2.c3) from tb1,tb2 where tb1.ts=tb2.ts; sql_error select pow(c2,tb1.c3),pow(c2,tb2.c3) from tb1,tb2 where tb1.ts=tb2.ts; print execute sql select pow(c2,c3) from tb1 union all select pow(c2,c3) from tb2; sql select pow(c2,c3) from tb1 union all select pow(c2,c3) from tb2; if $data00 != @1.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 != @256.000000000@ then return -1 endi if $data50 != @inf@ then return -1 endi if $data60 != @-0.000000000@ then return -1 endi if $data70 != @1.000000000@ then return -1 endi if $data80 != @4.000000000@ then return -1 endi if $data90 != @27.000000000@ then return -1 endi