sleep 100
sql connect
sql use db

print execute sql select cos(*) from tb1;
sql_error select cos(*) from tb1;
print execute sql select cos(*) from tb1;
sql_error select cos(*) from tb1;
print execute sql select cos(*) from tb1;
sql_error select cos(*) from tb1;
print execute sql select cos(*) from tb1;
sql_error select cos(*) from tb1;
print execute sql select cos(*) as a from tb1;
sql_error select cos(*) as a from tb1;
print execute sql select cos(*) + 1 as a from tb1;
sql_error select cos(*) + 1 as a from tb1;
print execute sql select cos(tb1.*) + 1 as a from tb1;
sql_error select cos(tb1.*) + 1 as a from tb1;
print execute sql select cos(*) from tb1;
sql_error select cos(*) from tb1;
print execute sql select cos(c1) from tb1;
sql_error select cos(c1) from tb1;
print execute sql select cos(c1) from tb1;
sql_error select cos(c1) from tb1;
print execute sql select cos(c1 + c2) from tb1;
sql_error select cos(c1 + c2) from tb1;
print execute sql select cos(13) from tb1;
sql select cos(13) from tb1;
if $data00 != @0.907446781@ then
  return -1 
endi
if $data10 != @0.907446781@ then
  return -1 
endi
if $data20 != @0.907446781@ then
  return -1 
endi
if $data30 != @0.907446781@ then
  return -1 
endi
if $data40 != @0.907446781@ then
  return -1 
endi
if $data50 != @0.907446781@ then
  return -1 
endi
if $data60 != @0.907446781@ then
  return -1 
endi
print execute sql select cos(c1) from tb1;
sql_error select cos(c1) from tb1;
print execute sql select cos(c2) from tb1;
sql select cos(c2) from tb1;
if $data00 != @0.540302306@ then
  return -1 
endi
if $data10 != @NULL@ then
  return -1 
endi
if $data20 != @-0.416146837@ then
  return -1 
endi
if $data30 != @NULL@ then
  return -1 
endi
if $data40 != @-0.653643621@ then
  return -1 
endi
if $data50 != @0.232359102@ then
  return -1 
endi
if $data60 != @0.232359102@ then
  return -1 
endi
print execute sql select cos(c3) from tb1;
sql select cos(c3) from tb1;
if $data00 != @0.540302306@ then
  return -1 
endi
if $data10 != @NULL@ then
  return -1 
endi
if $data20 != @NULL@ then
  return -1 
endi
if $data30 != @-0.989992497@ then
  return -1 
endi
if $data40 != @-0.653643621@ then
  return -1 
endi
if $data50 != @0.982263352@ then
  return -1 
endi
if $data60 != @0.982263352@ then
  return -1 
endi
print execute sql select cos(c4) from tb1;
sql select cos(c4) from tb1;
if $data00 != @0.540302306@ then
  return -1 
endi
if $data10 != @NULL@ then
  return -1 
endi
if $data20 != @-0.416146837@ then
  return -1 
endi
if $data30 != @NULL@ then
  return -1 
endi
if $data40 != @-0.653643621@ then
  return -1 
endi
if $data50 != @-0.688836692@ then
  return -1 
endi
if $data60 != @-0.688836692@ then
  return -1 
endi
print execute sql select cos(c5) from tb1;
sql select cos(c5) from tb1;
if $data00 != @0.540302306@ then
  return -1 
endi
if $data10 != @NULL@ then
  return -1 
endi
if $data20 != @NULL@ then
  return -1 
endi
if $data30 != @-0.989992497@ then
  return -1 
endi
if $data40 != @-0.653643621@ then
  return -1 
endi
if $data50 != @0.011800077@ then
  return -1 
endi
if $data60 != @0.011800077@ then
  return -1 
endi
print execute sql select cos(c6) from tb1;
sql select cos(c6) from tb1;
if $data00 != @0.540302306@ then
  return -1 
endi
if $data10 != @NULL@ then
  return -1 
endi
if $data20 != @-0.416146837@ then
  return -1 
endi
if $data30 != @NULL@ then
  return -1 
endi
if $data40 != @-0.653643621@ then
  return -1 
endi
if $data50 != @0.853021040@ then
  return -1 
endi
if $data60 != @0.853021040@ then
  return -1 
endi
print execute sql select cos(c7) from tb1;
sql select cos(c7) from tb1;
if $data00 != @0.540302306@ then
  return -1 
endi
if $data10 != @NULL@ then
  return -1 
endi
if $data20 != @NULL@ then
  return -1 
endi
if $data30 != @-0.989992497@ then
  return -1 
endi
if $data40 != @-0.653643621@ then
  return -1 
endi
if $data50 != @0.488025633@ then
  return -1 
endi
if $data60 != @0.488025633@ then
  return -1 
endi
print execute sql select cos(c8) from tb1;
sql_error select cos(c8) from tb1;
print execute sql select cos(c9) from tb1;
sql_error select cos(c9) from tb1;
print execute sql select cos(c10) from tb1;
sql select cos(c10) from tb1;
if $data00 != @0.540302306@ then
  return -1 
endi
if $data10 != @NULL@ then
  return -1 
endi
if $data20 != @-0.416146837@ then
  return -1 
endi
if $data30 != @NULL@ then
  return -1 
endi
if $data40 != @-0.653643621@ then
  return -1 
endi
if $data50 != @-0.892018495@ then
  return -1 
endi
if $data60 != @1.000000000@ then
  return -1 
endi
print execute sql select cos(c11) from tb1;
sql select cos(c11) from tb1;
if $data00 != @0.540302306@ then
  return -1 
endi
if $data10 != @NULL@ then
  return -1 
endi
if $data20 != @NULL@ then
  return -1 
endi
if $data30 != @-0.989992497@ then
  return -1 
endi
if $data40 != @-0.653643621@ then
  return -1 
endi
if $data50 != @0.929682584@ then
  return -1 
endi
if $data60 != @1.000000000@ then
  return -1 
endi
print execute sql select cos(c12) from tb1;
sql select cos(c12) from tb1;
if $data00 != @0.540302306@ then
  return -1 
endi
if $data10 != @NULL@ then
  return -1 
endi
if $data20 != @-0.416146837@ then
  return -1 
endi
if $data30 != @NULL@ then
  return -1 
endi
if $data40 != @-0.653643621@ then
  return -1 
endi
if $data50 != @-0.051008024@ then
  return -1 
endi
if $data60 != @1.000000000@ then
  return -1 
endi
print execute sql select cos(c13) from tb1;
sql select cos(c13) from tb1;
if $data00 != @0.540302306@ then
  return -1 
endi
if $data10 != @NULL@ then
  return -1 
endi
if $data20 != @NULL@ then
  return -1 
endi
if $data30 != @-0.989992497@ then
  return -1 
endi
if $data40 != @-0.653643621@ then
  return -1 
endi
if $data50 != @0.011800077@ then
  return -1 
endi
if $data60 != @1.000000000@ then
  return -1 
endi
print execute sql select cos(12345678900000000000000000) from tb1;
sql_error select cos(12345678900000000000000000) from tb1;
print execute sql select distinct cos(123) from tb1;
sql_error select distinct cos(123) from tb1;
print execute sql select cos(t1) from stb1;
sql_error select cos(t1) from stb1;
print execute sql select cos(c1),avg(c3) from tb1;
sql_error select cos(c1),avg(c3) from tb1;
print execute sql select cos(c1),top(c3,1) from tb1;
sql_error select cos(c1),top(c3,1) from tb1;
print execute sql select cos(c2+c3) from tb1 session(ts, 1s);
sql_error select cos(c2+c3) from tb1 session(ts, 1s);
print execute sql select cos(c2+c3) from tb1 STATE_WINDOW(c1);
sql_error select cos(c2+c3) from tb1 STATE_WINDOW(c1);
print execute sql select cos(c2+c3) from tb1 interval(1s) sliding(1s) fill(NULL);
sql_error select cos(c2+c3) from tb1 interval(1s) sliding(1s) fill(NULL);
print execute sql select cos(c2+c3) from stb1 group by t1;
sql_error select cos(c2+c3) from stb1 group by t1;
print execute sql select cos(c2+c3) from stb1 group by ts;
sql_error select cos(c2+c3) from stb1 group by ts;
print execute sql select cos(c2+c3) from stb1 group by c1;
sql_error select cos(c2+c3) from stb1 group by c1;
print execute sql select cos(c2+c3) from stb1 group by tbname;
sql_error select cos(c2+c3) from stb1 group by tbname;
print execute sql select cos(c2+c3) from tb1 order by c2;
sql_error select cos(c2+c3) from tb1 order by c2;
print execute sql select cos(c8),cos(c9) from tbn;
sql_error select cos(c8),cos(c9) from tbn;
print execute sql select cos(ts) from (select avg(c2) as a from stb1 interval(1s));
sql_error select cos(ts) from (select avg(c2) as a from stb1 interval(1s));
print execute sql select cos(a) from (select cos(c2) as a from tb1);
sql select cos(a) from (select cos(c2) as a from tb1);
if $data00 != @0.857553216@ then
  return -1 
endi
if $data10 != @NULL@ then
  return -1 
endi
if $data20 != @0.914653326@ then
  return -1 
endi
if $data30 != @NULL@ then
  return -1 
endi
if $data40 != @0.793873449@ then
  return -1 
endi
if $data50 != @0.973125864@ then
  return -1 
endi
if $data60 != @0.973125864@ then
  return -1 
endi
print execute sql select cos("abc") from tb1;
sql_error select cos("abc") from tb1;
print execute sql select cos(c2 + c3) from tb1;
sql select cos(c2 + c3) from tb1;
if $data00 != @-0.416146837@ 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 != @-0.145500034@ then
  return -1 
endi
if $data50 != @0.045863318@ then
  return -1 
endi
if $data60 != @0.045863318@ then
  return -1 
endi
print execute sql select cos((c2 + c3)) from tb1;
sql select cos((c2 + c3)) from tb1;
if $data00 != @-0.416146837@ 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 != @-0.145500034@ then
  return -1 
endi
if $data50 != @0.045863318@ then
  return -1 
endi
if $data60 != @0.045863318@ then
  return -1 
endi
print execute sql select cos((c2 * c3)+c4-6) from tb1;
sql select cos((c2 * c3)+c4-6) from tb1;
if $data00 != @-0.653643621@ 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 != @0.136737218@ then
  return -1 
endi
if $data50 != @-0.996514711@ then
  return -1 
endi
if $data60 != @0.134138861@ then
  return -1 
endi
print execute sql select cos(11)+c2 from tb1;
sql select cos(11)+c2 from tb1;
if $data00 != @1.004425698@ then
  return -1 
endi
if $data10 != @NULL@ then
  return -1 
endi
if $data20 != @2.004425698@ then
  return -1 
endi
if $data30 != @NULL@ then
  return -1 
endi
if $data40 != @4.004425698@ then
  return -1 
endi
if $data50 != @127.004425698@ then
  return -1 
endi
if $data60 != @-126.995574302@ then
  return -1 
endi
print execute sql select cos(c1)+c2 from tb1;
sql_error select cos(c1)+c2 from tb1;
print execute sql select cos(c2)+11 from tb1;
sql select cos(c2)+11 from tb1;
if $data00 != @11.540302306@ then
  return -1 
endi
if $data10 != @NULL@ then
  return -1 
endi
if $data20 != @10.583853163@ then
  return -1 
endi
if $data30 != @NULL@ then
  return -1 
endi
if $data40 != @10.346356379@ then
  return -1 
endi
if $data50 != @11.232359102@ then
  return -1 
endi
if $data60 != @11.232359102@ then
  return -1 
endi
print execute sql select cos(c1),c1,c2 from tb1;
sql_error select cos(c1),c1,c2 from tb1;
print execute sql select cos(c1),t1,ts,tbname,_C0,_c0 from tb1;
sql_error select cos(c1),t1,ts,tbname,_C0,_c0 from tb1;
print execute sql select cos(c1),floor(c3) from tb1;
sql_error select cos(c1),floor(c3) from tb1;
print execute sql select cos(c1),cos(c2+c3) from tb1;
sql_error select cos(c1),cos(c2+c3) from tb1;
print execute sql select cos(c2+c3) from tb1 where c2 is not null and c3 is not null;
sql select cos(c2+c3) from tb1 where c2 is not null and c3 is not null;
if $data00 != @-0.416146837@ then
  return -1 
endi
if $data10 != @-0.145500034@ then
  return -1 
endi
if $data20 != @0.045863318@ then
  return -1 
endi
if $data30 != @0.045863318@ then
  return -1 
endi
print execute sql select cos(c2) from tb1 order by ts desc;
sql select cos(c2) from tb1 order by ts desc;
if $data00 != @0.232359102@ then
  return -1 
endi
if $data10 != @0.232359102@ then
  return -1 
endi
if $data20 != @-0.653643621@ then
  return -1 
endi
if $data30 != @NULL@ then
  return -1 
endi
if $data40 != @-0.416146837@ then
  return -1 
endi
if $data50 != @NULL@ then
  return -1 
endi
if $data60 != @0.540302306@ then
  return -1 
endi
print execute sql select cos(c2+c3) from tb1 order by ts desc;
sql select cos(c2+c3) from tb1 order by ts desc;
if $data00 != @0.045863318@ then
  return -1 
endi
if $data10 != @0.045863318@ then
  return -1 
endi
if $data20 != @-0.145500034@ 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 != @-0.416146837@ then
  return -1 
endi
print execute sql select cos(c2+c3) from tb1 order by ts desc limit 3 offset 2;
sql select cos(c2+c3) from tb1 order by ts desc limit 3 offset 2;
if $data00 != @-0.145500034@ then
  return -1 
endi
if $data10 != @NULL@ then
  return -1 
endi
if $data20 != @NULL@ then
  return -1 
endi
print execute sql select cos(c2) from stb1;
sql select cos(c2) from stb1;
if $data00 != @0.540302306@ then
  return -1 
endi
if $data10 != @NULL@ then
  return -1 
endi
if $data20 != @-0.416146837@ then
  return -1 
endi
if $data30 != @NULL@ then
  return -1 
endi
if $data40 != @-0.653643621@ then
  return -1 
endi
if $data50 != @0.232359102@ then
  return -1 
endi
if $data60 != @0.232359102@ then
  return -1 
endi
if $data70 != @0.540302306@ then
  return -1 
endi
if $data80 != @-0.416146837@ then
  return -1 
endi
if $data90 != @-0.989992497@ then
  return -1 
endi
print execute sql select cos(c2) from stb1 order by ts desc;
sql select cos(c2) from stb1 order by ts desc;
if $data00 != @0.753902254@ then
  if $data00 != @0.232359102@ then
    return -1 
  endi
endi
if $data20 != @0.960170287@ then
  if $data20 != @0.232359102@ then
    return -1 
  endi
endi
if $data40 != @0.283662185@ then
  if $data40 != @-0.653643621@ then
    return -1 
  endi
endi
if $data60 != @-0.653643621@ then
  if $data60 != @NULL@ then
    return -1 
  endi
endi
if $data80 != @-0.989992497@ then
  if $data80 != @-0.416146837@ then
    return -1 
  endi
endi
print execute sql select cos(c4),t1 from stb1 order by ts desc;
sql select cos(c4),t1 from stb1 order by ts desc;
if $data00 != @0.753902254@ then
  if $data00 != @-0.688836692@ then
    return -1 
  endi
endi
if $data01 != @2@ then
  if $data01 != @1@ then
    return -1 
  endi
endi
if $data20 != @0.960170287@ then
  if $data20 != @-0.688836692@ then
    return -1 
  endi
endi
if $data21 != @2@ then
  if $data21 != @1@ then
    return -1 
  endi
endi
if $data40 != @0.283662185@ then
  if $data40 != @-0.653643621@ then
    return -1 
  endi
endi
if $data41 != @2@ then
  if $data41 != @1@ then
    return -1 
  endi
endi
if $data60 != @-0.653643621@ then
  if $data60 != @NULL@ then
    return -1 
  endi
endi
if $data61 != @2@ then
  if $data61 != @1@ then
    return -1 
  endi
endi
if $data80 != @-0.416146837@ then
  if $data80 != @-0.416146837@ then
    return -1 
  endi
endi
if $data81 != @2@ then
  if $data81 != @1@ then
    return -1 
  endi
endi
print execute sql select cos(c3),tbname from stb1;
sql select cos(c3),tbname from stb1;
if $data00 != @0.540302306@ 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 != @-0.989992497@ then
  return -1 
endi
if $data31 != @tb1@ then
  return -1 
endi
if $data40 != @-0.653643621@ then
  return -1 
endi
if $data41 != @tb1@ then
  return -1 
endi
if $data50 != @0.982263352@ then
  return -1 
endi
if $data51 != @tb1@ then
  return -1 
endi
if $data60 != @0.982263352@ then
  return -1 
endi
if $data61 != @tb1@ then
  return -1 
endi
if $data70 != @0.540302306@ then
  return -1 
endi
if $data71 != @tb2@ then
  return -1 
endi
if $data80 != @-0.416146837@ then
  return -1 
endi
if $data81 != @tb2@ then
  return -1 
endi
if $data90 != @-0.989992497@ then
  return -1 
endi
if $data91 != @tb2@ then
  return -1 
endi
print execute sql select cos(c3),tbname from stb1 where t1 > 1;
sql select cos(c3),tbname from stb1 where t1 > 1;
if $data00 != @0.540302306@ then
  return -1 
endi
if $data01 != @tb2@ then
  return -1 
endi
if $data10 != @-0.416146837@ then
  return -1 
endi
if $data11 != @tb2@ then
  return -1 
endi
if $data20 != @-0.989992497@ then
  return -1 
endi
if $data21 != @tb2@ then
  return -1 
endi
if $data30 != @-0.653643621@ then
  return -1 
endi
if $data31 != @tb2@ then
  return -1 
endi
if $data40 != @0.283662185@ then
  return -1 
endi
if $data41 != @tb2@ then
  return -1 
endi
if $data50 != @0.960170287@ then
  return -1 
endi
if $data51 != @tb2@ then
  return -1 
endi
if $data60 != @0.753902254@ then
  return -1 
endi
if $data61 != @tb2@ then
  return -1 
endi
print execute sql select cos(c8),cos(c9) from tbn;
sql_error select cos(c8),cos(c9) from tbn;
print execute sql select cos(c8),cos(c9) from tbn order by ts desc;
sql_error select cos(c8),cos(c9) from tbn order by ts desc;
print execute sql select cos(cos(c8)) from tbn;
sql_error select cos(cos(c8)) from tbn;
print execute sql select cos(a) from (select avg(c2) as a from stb1 interval(1s));
sql select cos(a) from (select avg(c2) as a from stb1 interval(1s));
if $data00 != @0.540302306@ then
  return -1 
endi
if $data10 != @-0.416146837@ then
  return -1 
endi
if $data20 != @-0.801143616@ then
  return -1 
endi
if $data30 != @-0.653643621@ then
  return -1 
endi
if $data40 != @-0.210795799@ then
  return -1 
endi
if $data50 != @-0.864543874@ then
  return -1 
endi
if $data60 != @-0.952412980@ then
  return -1 
endi
print execute sql select cos(c2) from (select * from stb1);
sql select cos(c2) from (select * from stb1);
if $data00 != @0.540302306@ then
  return -1 
endi
if $data10 != @NULL@ then
  return -1 
endi
if $data20 != @-0.416146837@ then
  return -1 
endi
if $data30 != @NULL@ then
  return -1 
endi
if $data40 != @-0.653643621@ then
  return -1 
endi
if $data50 != @0.232359102@ then
  return -1 
endi
if $data60 != @0.232359102@ then
  return -1 
endi
if $data70 != @0.540302306@ then
  return -1 
endi
if $data80 != @-0.416146837@ then
  return -1 
endi
if $data90 != @-0.989992497@ then
  return -1 
endi
print execute sql select cos(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 cos(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 != @0.540302306@ then
  return -1 
endi
if $data10 != @-0.416146837@ then
  return -1 
endi
if $data20 != @-0.801143616@ then
  return -1 
endi
if $data30 != @-0.653643621@ then
  return -1 
endi
if $data40 != @-0.210795799@ then
  return -1 
endi
if $data50 != @-0.864543874@ then
  return -1 
endi
if $data60 != @-0.952412980@ 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 cos(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 cos(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 != @0.540302306@ then
  return -1 
endi
if $data10 != @-0.416146837@ then
  return -1 
endi
if $data20 != @-0.801143616@ then
  return -1 
endi
if $data30 != @-0.653643621@ then
  return -1 
endi
if $data40 != @-0.210795799@ then
  return -1 
endi
if $data50 != @-0.864543874@ then
  return -1 
endi
if $data60 != @-0.952412980@ 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 cos(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 cos(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 != @-0.952412980@ then
  return -1 
endi
if $data40 != @-0.864543874@ then
  return -1 
endi
if $data50 != @-0.210795799@ then
  return -1 
endi
if $data60 != @-0.653643621@ then
  return -1 
endi
if $data70 != @-0.801143616@ then
  return -1 
endi
if $data80 != @-0.416146837@ then
  return -1 
endi
if $data90 != @0.540302306@ then
  return -1 
endi
print execute sql select cos(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 cos(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 != @-0.864543874@ then
  return -1 
endi
if $data40 != @-0.210795799@ then
  return -1 
endi
if $data50 != @-0.653643621@ then
  return -1 
endi
if $data60 != @-0.801143616@ then
  return -1 
endi
if $data70 != @-0.416146837@ then
  return -1 
endi
if $data80 != @0.540302306@ then
  return -1 
endi
if $data90 != @-0.952412980@ then
  return -1 
endi
print execute sql select cos(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 cos(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 != @-0.952412980@ then
  return -1 
endi
if $data10 != @0.540302306@ then
  return -1 
endi
if $data20 != @-0.416146837@ then
  return -1 
endi
if $data30 != @-0.801143616@ then
  return -1 
endi
if $data40 != @-0.653643621@ then
  return -1 
endi
if $data50 != @-0.210795799@ then
  return -1 
endi
if $data60 != @-0.864543874@ 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 cos(a) from (select cos(c2) as a from tb1);
sql select cos(a) from (select cos(c2) as a from tb1);
if $data00 != @0.857553216@ then
  return -1 
endi
if $data10 != @NULL@ then
  return -1 
endi
if $data20 != @0.914653326@ then
  return -1 
endi
if $data30 != @NULL@ then
  return -1 
endi
if $data40 != @0.793873449@ then
  return -1 
endi
if $data50 != @0.973125864@ then
  return -1 
endi
if $data60 != @0.973125864@ then
  return -1 
endi
print execute sql select cos(tb1.c3),cos(tb2.c3) from tb1,tb2 where tb1.ts=tb2.ts;
sql select cos(tb1.c3),cos(tb2.c3) from tb1,tb2 where tb1.ts=tb2.ts;
if $data00 != @0.540302306@ then
  return -1 
endi
if $data01 != @0.540302306@ then
  return -1 
endi
if $data10 != @NULL@ then
  return -1 
endi
if $data11 != @-0.416146837@ then
  return -1 
endi
if $data20 != @NULL@ then
  return -1 
endi
if $data21 != @-0.989992497@ then
  return -1 
endi
if $data30 != @-0.989992497@ then
  return -1 
endi
if $data31 != @-0.653643621@ then
  return -1 
endi
if $data40 != @-0.653643621@ then
  return -1 
endi
if $data41 != @0.283662185@ then
  return -1 
endi
if $data50 != @0.982263352@ then
  return -1 
endi
if $data51 != @0.960170287@ then
  return -1 
endi
if $data60 != @0.982263352@ then
  return -1 
endi
if $data61 != @0.753902254@ then
  return -1 
endi
print execute sql select cos(c3) from tb1 union all select cos(c3) from tb2;
sql select cos(c3) from tb1 union all select cos(c3) from tb2;
if $data00 != @0.540302306@ then
  return -1 
endi
if $data10 != @NULL@ then
  return -1 
endi
if $data20 != @NULL@ then
  return -1 
endi
if $data30 != @-0.989992497@ then
  return -1 
endi
if $data40 != @-0.653643621@ then
  return -1 
endi
if $data50 != @0.982263352@ then
  return -1 
endi
if $data60 != @0.982263352@ then
  return -1 
endi
if $data70 != @0.540302306@ then
  return -1 
endi
if $data80 != @-0.416146837@ then
  return -1 
endi
if $data90 != @-0.989992497@ then
  return -1 
endi