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/develop-test/2-query/scalar_expression.py
Shuduo Sang 387f2eb8bf
test: distinguish nan and none (#11533) 
* test: distinguish nan and none

[TD-14736]

* modify test framework for datetime

* fix 2-query/math_funcs.py
2022-04-15 19:26:39 +08:00

889 lines
39 KiB
Python
Raw Permalink Blame History

import sys
from util.log import *
from util.cases import *
from util.sql import *
from util.dnodes import tdDnodes
from math import inf, nan
class TDTestCase:
def caseDescription(self):
"""
case1<shenglian zhou>: [TD-14123]: fix failed test on arm64 by converting from sim tst to python test to overcome NaN value and its string representation
case2<shenglian zhou>: [TD-14565]: log function default base param e
"""
return
def init(self, conn, logSql):
tdLog.debug("start to execute %s" % __file__)
tdSql.init(conn.cursor(), logSql)
self._conn = conn
def restartTaosd(self, index=1, dbname="db"):
tdDnodes.stop(index)
tdDnodes.startWithoutSleep(index)
tdSql.execute(f"use db0")
def run(self):
print("running {}".format(__file__))
tdSql.execute("drop database if exists db0")
tdSql.execute("create database if not exists db0")
tdSql.execute("use db0")
tdSql.execute(
"create table st0 (ts timestamp, c1 int, c2 float, c3 bigint, c4 smallint, c5 tinyint, c6 double, c7 bool, c8 nchar(5), c9 binary(10)) TAGS (tgcol int);"
)
tdSql.execute("create table ct0 using st0 tags( 0 );")
tdSql.execute(
"insert into ct0 values (1601481600000 , 0 , 0.25 , 0 , 0 , 0 , 0.25 , 0 , 0 , 0 );"
)
for i in range(1, 50):
tdSql.execute(
"insert into ct0 values ({}, {}, {}, {}, {}, {}, {}, {}, {}, {});".format(
1601481600000 + i * 60000, i, i, i, i, i, i, i, i, i
)
)
tdSql.execute("create table ct1 using st0 tags( 1 );")
tdSql.execute(
"insert into ct1 values (1601481600000 , 0 , 0.25 , 0 , 0 , 0 , 0.25 , 0 , 0 , 0 );"
)
for i in range(1, 50):
tdSql.execute(
"insert into ct1 values ({}, {}, {}, {}, {}, {}, {}, {}, {}, {});".format(
1601481600000 + i * 60000, i, i, i, i, i, i, i, i, i
)
)
tdSql.execute(
"insert into ct1 values (1601484420000 , 47 , 47 , 47 , 47 , 47 , 47 , 47 , 47 , 47 );"
)
tdSql.execute(
"insert into ct1 values (1601484480000 , 48 , 48 , 48 , 48 , 48 , 48 , 48 , 48 , 48 );"
)
tdSql.execute(
"insert into ct1 values (1601484540000 , 49 , 49 , 49 , 49 , 49 , 49 , 49 , 49 , 49 );"
)
tdSql.query("select floor(3.0)+ceil(4.0) from ct0;")
tdSql.checkRows(50)
for i in range(0, 50):
tdSql.checkData(i, 0, 7.0)
tdSql.query("select sum(c1)+3.0+4.0 from st0;")
tdSql.checkRows(1)
tdSql.checkData(0, 0, 2457.0)
tdSql.query("select sin(log(avg(c1))+3)%4 from st0;")
tdSql.checkRows(1)
tdSql.checkData(0, 0, -0.08441162350373656)
tdSql.query("select sin(log(avg(c1),sum(c2))+3)%4 from st0;")
tdSql.checkRows(1)
tdSql.checkData(0, 0, -0.26507428560248714)
tdSql.query("select log(pow(length(concat('3','4')),2),c2) from st0;")
tdSql.checkRows(100)
tdSql.checkData(0, 0, -1.0)
tdSql.checkData(1, 0, inf)
tdSql.checkData(2, 0, 2.0)
tdSql.checkData(3, 0, 1.2618595071429148)
tdSql.checkData(4, 0, 1.0)
tdSql.checkData(5, 0, 0.8613531161467861)
tdSql.checkData(6, 0, 0.7737056144690831)
tdSql.checkData(7, 0, 0.7124143742160444)
tdSql.checkData(8, 0, 0.6666666666666667)
tdSql.checkData(9, 0, 0.6309297535714574)
tdSql.checkData(10, 0, 0.6020599913279623)
tdSql.checkData(11, 0, 0.5781296526357756)
tdSql.checkData(12, 0, 0.5578858913022596)
tdSql.checkData(13, 0, 0.5404763088546395)
tdSql.checkData(14, 0, 0.5252990700743871)
tdSql.checkData(15, 0, 0.511916049619631)
tdSql.checkData(16, 0, 0.5)
tdSql.checkData(17, 0, 0.489301084236452)
tdSql.checkData(18, 0, 0.4796249331362629)
tdSql.checkData(19, 0, 0.4708178267332765)
tdSql.checkData(20, 0, 0.46275642631951835)
tdSql.checkData(21, 0, 0.455340497393906)
tdSql.checkData(22, 0, 0.4484876484351508)
tdSql.checkData(23, 0, 0.4421294589150075)
tdSql.checkData(24, 0, 0.4362085839710631)
tdSql.checkData(25, 0, 0.43067655807339306)
tdSql.checkData(26, 0, 0.4254921071067263)
tdSql.checkData(27, 0, 0.42061983571430495)
tdSql.checkData(28, 0, 0.4160291953530189)
tdSql.checkData(29, 0, 0.4116936649208689)
tdSql.checkData(30, 0, 0.40759009418101233)
tdSql.checkData(31, 0, 0.4036981731641997)
tdSql.checkData(32, 0, 0.39999999999999997)
tdSql.checkData(33, 0, 0.39647972634112105)
tdSql.checkData(34, 0, 0.39312326446564516)
tdSql.checkData(35, 0, 0.3899180437875726)
tdSql.checkData(36, 0, 0.3868528072345416)
tdSql.checkData(37, 0, 0.3839174400131203)
tdSql.checkData(38, 0, 0.3811028248535468)
tdSql.checkData(39, 0, 0.37840071903374006)
tdSql.checkData(40, 0, 0.37580364941821515)
tdSql.checkData(41, 0, 0.3733048224778867)
tdSql.checkData(42, 0, 0.3708980468307378)
tdSql.checkData(43, 0, 0.36857766629741234)
tdSql.checkData(44, 0, 0.36633850182726724)
tdSql.checkData(45, 0, 0.3641758009398765)
tdSql.checkData(46, 0, 0.3620851935600804)
tdSql.checkData(47, 0, 0.3600626533133853)
tdSql.checkData(48, 0, 0.3581044635020827)
tdSql.checkData(49, 0, 0.3562071871080222)
tdSql.checkData(50, 0, -1.0)
tdSql.checkData(51, 0, inf)
tdSql.checkData(52, 0, 2.0)
tdSql.checkData(53, 0, 1.2618595071429148)
tdSql.checkData(54, 0, 1.0)
tdSql.checkData(55, 0, 0.8613531161467861)
tdSql.checkData(56, 0, 0.7737056144690831)
tdSql.checkData(57, 0, 0.7124143742160444)
tdSql.checkData(58, 0, 0.6666666666666667)
tdSql.checkData(59, 0, 0.6309297535714574)
tdSql.checkData(60, 0, 0.6020599913279623)
tdSql.checkData(61, 0, 0.5781296526357756)
tdSql.checkData(62, 0, 0.5578858913022596)
tdSql.checkData(63, 0, 0.5404763088546395)
tdSql.checkData(64, 0, 0.5252990700743871)
tdSql.checkData(65, 0, 0.511916049619631)
tdSql.checkData(66, 0, 0.5)
tdSql.checkData(67, 0, 0.489301084236452)
tdSql.checkData(68, 0, 0.4796249331362629)
tdSql.checkData(69, 0, 0.4708178267332765)
tdSql.checkData(70, 0, 0.46275642631951835)
tdSql.checkData(71, 0, 0.455340497393906)
tdSql.checkData(72, 0, 0.4484876484351508)
tdSql.checkData(73, 0, 0.4421294589150075)
tdSql.checkData(74, 0, 0.4362085839710631)
tdSql.checkData(75, 0, 0.43067655807339306)
tdSql.checkData(76, 0, 0.4254921071067263)
tdSql.checkData(77, 0, 0.42061983571430495)
tdSql.checkData(78, 0, 0.4160291953530189)
tdSql.checkData(79, 0, 0.4116936649208689)
tdSql.checkData(80, 0, 0.40759009418101233)
tdSql.checkData(81, 0, 0.4036981731641997)
tdSql.checkData(82, 0, 0.39999999999999997)
tdSql.checkData(83, 0, 0.39647972634112105)
tdSql.checkData(84, 0, 0.39312326446564516)
tdSql.checkData(85, 0, 0.3899180437875726)
tdSql.checkData(86, 0, 0.3868528072345416)
tdSql.checkData(87, 0, 0.3839174400131203)
tdSql.checkData(88, 0, 0.3811028248535468)
tdSql.checkData(89, 0, 0.37840071903374006)
tdSql.checkData(90, 0, 0.37580364941821515)
tdSql.checkData(91, 0, 0.3733048224778867)
tdSql.checkData(92, 0, 0.3708980468307378)
tdSql.checkData(93, 0, 0.36857766629741234)
tdSql.checkData(94, 0, 0.36633850182726724)
tdSql.checkData(95, 0, 0.3641758009398765)
tdSql.checkData(96, 0, 0.3620851935600804)
tdSql.checkData(97, 0, 0.3600626533133853)
tdSql.checkData(98, 0, 0.3581044635020827)
tdSql.checkData(99, 0, 0.3562071871080222)
tdSql.query("select log(pow(length(concat('3','4')),2)) from st0;")
tdSql.checkRows(100)
tdSql.checkData(0, 0, 1.3862943611198906)
tdSql.checkData(1, 0, 1.3862943611198906)
tdSql.checkData(2, 0, 1.3862943611198906)
tdSql.checkData(3, 0, 1.3862943611198906)
tdSql.checkData(4, 0, 1.3862943611198906)
tdSql.checkData(5, 0, 1.3862943611198906)
tdSql.checkData(6, 0, 1.3862943611198906)
tdSql.checkData(7, 0, 1.3862943611198906)
tdSql.checkData(8, 0, 1.3862943611198906)
tdSql.checkData(9, 0, 1.3862943611198906)
tdSql.checkData(10, 0, 1.3862943611198906)
tdSql.checkData(11, 0, 1.3862943611198906)
tdSql.checkData(12, 0, 1.3862943611198906)
tdSql.checkData(13, 0, 1.3862943611198906)
tdSql.checkData(14, 0, 1.3862943611198906)
tdSql.checkData(15, 0, 1.3862943611198906)
tdSql.checkData(16, 0, 1.3862943611198906)
tdSql.checkData(17, 0, 1.3862943611198906)
tdSql.checkData(18, 0, 1.3862943611198906)
tdSql.checkData(19, 0, 1.3862943611198906)
tdSql.checkData(20, 0, 1.3862943611198906)
tdSql.checkData(21, 0, 1.3862943611198906)
tdSql.checkData(22, 0, 1.3862943611198906)
tdSql.checkData(23, 0, 1.3862943611198906)
tdSql.checkData(24, 0, 1.3862943611198906)
tdSql.checkData(25, 0, 1.3862943611198906)
tdSql.checkData(26, 0, 1.3862943611198906)
tdSql.checkData(27, 0, 1.3862943611198906)
tdSql.checkData(28, 0, 1.3862943611198906)
tdSql.checkData(29, 0, 1.3862943611198906)
tdSql.checkData(30, 0, 1.3862943611198906)
tdSql.checkData(31, 0, 1.3862943611198906)
tdSql.checkData(32, 0, 1.3862943611198906)
tdSql.checkData(33, 0, 1.3862943611198906)
tdSql.checkData(34, 0, 1.3862943611198906)
tdSql.checkData(35, 0, 1.3862943611198906)
tdSql.checkData(36, 0, 1.3862943611198906)
tdSql.checkData(37, 0, 1.3862943611198906)
tdSql.checkData(38, 0, 1.3862943611198906)
tdSql.checkData(39, 0, 1.3862943611198906)
tdSql.checkData(40, 0, 1.3862943611198906)
tdSql.checkData(41, 0, 1.3862943611198906)
tdSql.checkData(42, 0, 1.3862943611198906)
tdSql.checkData(43, 0, 1.3862943611198906)
tdSql.checkData(44, 0, 1.3862943611198906)
tdSql.checkData(45, 0, 1.3862943611198906)
tdSql.checkData(46, 0, 1.3862943611198906)
tdSql.checkData(47, 0, 1.3862943611198906)
tdSql.checkData(48, 0, 1.3862943611198906)
tdSql.checkData(49, 0, 1.3862943611198906)
tdSql.checkData(50, 0, 1.3862943611198906)
tdSql.checkData(51, 0, 1.3862943611198906)
tdSql.checkData(52, 0, 1.3862943611198906)
tdSql.checkData(53, 0, 1.3862943611198906)
tdSql.checkData(54, 0, 1.3862943611198906)
tdSql.checkData(55, 0, 1.3862943611198906)
tdSql.checkData(56, 0, 1.3862943611198906)
tdSql.checkData(57, 0, 1.3862943611198906)
tdSql.checkData(58, 0, 1.3862943611198906)
tdSql.checkData(59, 0, 1.3862943611198906)
tdSql.checkData(60, 0, 1.3862943611198906)
tdSql.checkData(61, 0, 1.3862943611198906)
tdSql.checkData(62, 0, 1.3862943611198906)
tdSql.checkData(63, 0, 1.3862943611198906)
tdSql.checkData(64, 0, 1.3862943611198906)
tdSql.checkData(65, 0, 1.3862943611198906)
tdSql.checkData(66, 0, 1.3862943611198906)
tdSql.checkData(67, 0, 1.3862943611198906)
tdSql.checkData(68, 0, 1.3862943611198906)
tdSql.checkData(69, 0, 1.3862943611198906)
tdSql.checkData(70, 0, 1.3862943611198906)
tdSql.checkData(71, 0, 1.3862943611198906)
tdSql.checkData(72, 0, 1.3862943611198906)
tdSql.checkData(73, 0, 1.3862943611198906)
tdSql.checkData(74, 0, 1.3862943611198906)
tdSql.checkData(75, 0, 1.3862943611198906)
tdSql.checkData(76, 0, 1.3862943611198906)
tdSql.checkData(77, 0, 1.3862943611198906)
tdSql.checkData(78, 0, 1.3862943611198906)
tdSql.checkData(79, 0, 1.3862943611198906)
tdSql.checkData(80, 0, 1.3862943611198906)
tdSql.checkData(81, 0, 1.3862943611198906)
tdSql.checkData(82, 0, 1.3862943611198906)
tdSql.checkData(83, 0, 1.3862943611198906)
tdSql.checkData(84, 0, 1.3862943611198906)
tdSql.checkData(85, 0, 1.3862943611198906)
tdSql.checkData(86, 0, 1.3862943611198906)
tdSql.checkData(87, 0, 1.3862943611198906)
tdSql.checkData(88, 0, 1.3862943611198906)
tdSql.checkData(89, 0, 1.3862943611198906)
tdSql.checkData(90, 0, 1.3862943611198906)
tdSql.checkData(91, 0, 1.3862943611198906)
tdSql.checkData(92, 0, 1.3862943611198906)
tdSql.checkData(93, 0, 1.3862943611198906)
tdSql.checkData(94, 0, 1.3862943611198906)
tdSql.checkData(95, 0, 1.3862943611198906)
tdSql.checkData(96, 0, 1.3862943611198906)
tdSql.checkData(97, 0, 1.3862943611198906)
tdSql.checkData(98, 0, 1.3862943611198906)
tdSql.checkData(99, 0, 1.3862943611198906)
tdSql.query(
"select round(log(pow(length(concat('3','4')),2),c2)+floor(c3))+2 from st0;"
)
tdSql.checkRows(100)
tdSql.checkData(0, 0, 1.0)
tdSql.checkData(1, 0, inf)
tdSql.checkData(2, 0, 6.0)
tdSql.checkData(3, 0, 6.0)
tdSql.checkData(4, 0, 7.0)
tdSql.checkData(5, 0, 8.0)
tdSql.checkData(6, 0, 9.0)
tdSql.checkData(7, 0, 10.0)
tdSql.checkData(8, 0, 11.0)
tdSql.checkData(9, 0, 12.0)
tdSql.checkData(10, 0, 13.0)
tdSql.checkData(11, 0, 14.0)
tdSql.checkData(12, 0, 15.0)
tdSql.checkData(13, 0, 16.0)
tdSql.checkData(14, 0, 17.0)
tdSql.checkData(15, 0, 18.0)
tdSql.checkData(16, 0, 19.0)
tdSql.checkData(17, 0, 19.0)
tdSql.checkData(18, 0, 20.0)
tdSql.checkData(19, 0, 21.0)
tdSql.checkData(20, 0, 22.0)
tdSql.checkData(21, 0, 23.0)
tdSql.checkData(22, 0, 24.0)
tdSql.checkData(23, 0, 25.0)
tdSql.checkData(24, 0, 26.0)
tdSql.checkData(25, 0, 27.0)
tdSql.checkData(26, 0, 28.0)
tdSql.checkData(27, 0, 29.0)
tdSql.checkData(28, 0, 30.0)
tdSql.checkData(29, 0, 31.0)
tdSql.checkData(30, 0, 32.0)
tdSql.checkData(31, 0, 33.0)
tdSql.checkData(32, 0, 34.0)
tdSql.checkData(33, 0, 35.0)
tdSql.checkData(34, 0, 36.0)
tdSql.checkData(35, 0, 37.0)
tdSql.checkData(36, 0, 38.0)
tdSql.checkData(37, 0, 39.0)
tdSql.checkData(38, 0, 40.0)
tdSql.checkData(39, 0, 41.0)
tdSql.checkData(40, 0, 42.0)
tdSql.checkData(41, 0, 43.0)
tdSql.checkData(42, 0, 44.0)
tdSql.checkData(43, 0, 45.0)
tdSql.checkData(44, 0, 46.0)
tdSql.checkData(45, 0, 47.0)
tdSql.checkData(46, 0, 48.0)
tdSql.checkData(47, 0, 49.0)
tdSql.checkData(48, 0, 50.0)
tdSql.checkData(49, 0, 51.0)
tdSql.checkData(50, 0, 1.0)
tdSql.checkData(51, 0, inf)
tdSql.checkData(52, 0, 6.0)
tdSql.checkData(53, 0, 6.0)
tdSql.checkData(54, 0, 7.0)
tdSql.checkData(55, 0, 8.0)
tdSql.checkData(56, 0, 9.0)
tdSql.checkData(57, 0, 10.0)
tdSql.checkData(58, 0, 11.0)
tdSql.checkData(59, 0, 12.0)
tdSql.checkData(60, 0, 13.0)
tdSql.checkData(61, 0, 14.0)
tdSql.checkData(62, 0, 15.0)
tdSql.checkData(63, 0, 16.0)
tdSql.checkData(64, 0, 17.0)
tdSql.checkData(65, 0, 18.0)
tdSql.checkData(66, 0, 19.0)
tdSql.checkData(67, 0, 19.0)
tdSql.checkData(68, 0, 20.0)
tdSql.checkData(69, 0, 21.0)
tdSql.checkData(70, 0, 22.0)
tdSql.checkData(71, 0, 23.0)
tdSql.checkData(72, 0, 24.0)
tdSql.checkData(73, 0, 25.0)
tdSql.checkData(74, 0, 26.0)
tdSql.checkData(75, 0, 27.0)
tdSql.checkData(76, 0, 28.0)
tdSql.checkData(77, 0, 29.0)
tdSql.checkData(78, 0, 30.0)
tdSql.checkData(79, 0, 31.0)
tdSql.checkData(80, 0, 32.0)
tdSql.checkData(81, 0, 33.0)
tdSql.checkData(82, 0, 34.0)
tdSql.checkData(83, 0, 35.0)
tdSql.checkData(84, 0, 36.0)
tdSql.checkData(85, 0, 37.0)
tdSql.checkData(86, 0, 38.0)
tdSql.checkData(87, 0, 39.0)
tdSql.checkData(88, 0, 40.0)
tdSql.checkData(89, 0, 41.0)
tdSql.checkData(90, 0, 42.0)
tdSql.checkData(91, 0, 43.0)
tdSql.checkData(92, 0, 44.0)
tdSql.checkData(93, 0, 45.0)
tdSql.checkData(94, 0, 46.0)
tdSql.checkData(95, 0, 47.0)
tdSql.checkData(96, 0, 48.0)
tdSql.checkData(97, 0, 49.0)
tdSql.checkData(98, 0, 50.0)
tdSql.checkData(99, 0, 51.0)
tdSql.query(
"select round(log(pow(length(concat('3','4')),2))+floor(c3))+2 from st0;"
)
tdSql.checkRows(100)
tdSql.checkData(0, 0, 3.0)
tdSql.checkData(1, 0, 4.0)
tdSql.checkData(2, 0, 5.0)
tdSql.checkData(3, 0, 6.0)
tdSql.checkData(4, 0, 7.0)
tdSql.checkData(5, 0, 8.0)
tdSql.checkData(6, 0, 9.0)
tdSql.checkData(7, 0, 10.0)
tdSql.checkData(8, 0, 11.0)
tdSql.checkData(9, 0, 12.0)
tdSql.checkData(10, 0, 13.0)
tdSql.checkData(11, 0, 14.0)
tdSql.checkData(12, 0, 15.0)
tdSql.checkData(13, 0, 16.0)
tdSql.checkData(14, 0, 17.0)
tdSql.checkData(15, 0, 18.0)
tdSql.checkData(16, 0, 19.0)
tdSql.checkData(17, 0, 20.0)
tdSql.checkData(18, 0, 21.0)
tdSql.checkData(19, 0, 22.0)
tdSql.checkData(20, 0, 23.0)
tdSql.checkData(21, 0, 24.0)
tdSql.checkData(22, 0, 25.0)
tdSql.checkData(23, 0, 26.0)
tdSql.checkData(24, 0, 27.0)
tdSql.checkData(25, 0, 28.0)
tdSql.checkData(26, 0, 29.0)
tdSql.checkData(27, 0, 30.0)
tdSql.checkData(28, 0, 31.0)
tdSql.checkData(29, 0, 32.0)
tdSql.checkData(30, 0, 33.0)
tdSql.checkData(31, 0, 34.0)
tdSql.checkData(32, 0, 35.0)
tdSql.checkData(33, 0, 36.0)
tdSql.checkData(34, 0, 37.0)
tdSql.checkData(35, 0, 38.0)
tdSql.checkData(36, 0, 39.0)
tdSql.checkData(37, 0, 40.0)
tdSql.checkData(38, 0, 41.0)
tdSql.checkData(39, 0, 42.0)
tdSql.checkData(40, 0, 43.0)
tdSql.checkData(41, 0, 44.0)
tdSql.checkData(42, 0, 45.0)
tdSql.checkData(43, 0, 46.0)
tdSql.checkData(44, 0, 47.0)
tdSql.checkData(45, 0, 48.0)
tdSql.checkData(46, 0, 49.0)
tdSql.checkData(47, 0, 50.0)
tdSql.checkData(48, 0, 51.0)
tdSql.checkData(49, 0, 52.0)
tdSql.checkData(50, 0, 3.0)
tdSql.checkData(51, 0, 4.0)
tdSql.checkData(52, 0, 5.0)
tdSql.checkData(53, 0, 6.0)
tdSql.checkData(54, 0, 7.0)
tdSql.checkData(55, 0, 8.0)
tdSql.checkData(56, 0, 9.0)
tdSql.checkData(57, 0, 10.0)
tdSql.checkData(58, 0, 11.0)
tdSql.checkData(59, 0, 12.0)
tdSql.checkData(60, 0, 13.0)
tdSql.checkData(61, 0, 14.0)
tdSql.checkData(62, 0, 15.0)
tdSql.checkData(63, 0, 16.0)
tdSql.checkData(64, 0, 17.0)
tdSql.checkData(65, 0, 18.0)
tdSql.checkData(66, 0, 19.0)
tdSql.checkData(67, 0, 20.0)
tdSql.checkData(68, 0, 21.0)
tdSql.checkData(69, 0, 22.0)
tdSql.checkData(70, 0, 23.0)
tdSql.checkData(71, 0, 24.0)
tdSql.checkData(72, 0, 25.0)
tdSql.checkData(73, 0, 26.0)
tdSql.checkData(74, 0, 27.0)
tdSql.checkData(75, 0, 28.0)
tdSql.checkData(76, 0, 29.0)
tdSql.checkData(77, 0, 30.0)
tdSql.checkData(78, 0, 31.0)
tdSql.checkData(79, 0, 32.0)
tdSql.checkData(80, 0, 33.0)
tdSql.checkData(81, 0, 34.0)
tdSql.checkData(82, 0, 35.0)
tdSql.checkData(83, 0, 36.0)
tdSql.checkData(84, 0, 37.0)
tdSql.checkData(85, 0, 38.0)
tdSql.checkData(86, 0, 39.0)
tdSql.checkData(87, 0, 40.0)
tdSql.checkData(88, 0, 41.0)
tdSql.checkData(89, 0, 42.0)
tdSql.checkData(90, 0, 43.0)
tdSql.checkData(91, 0, 44.0)
tdSql.checkData(92, 0, 45.0)
tdSql.checkData(93, 0, 46.0)
tdSql.checkData(94, 0, 47.0)
tdSql.checkData(95, 0, 48.0)
tdSql.checkData(96, 0, 49.0)
tdSql.checkData(97, 0, 50.0)
tdSql.checkData(98, 0, 51.0)
tdSql.checkData(99, 0, 52.0)
tdSql.query(
"select sin(pow(c1,log(c2,2))+pow(c2,2)) as val from ct0 union all select pow(c4,2)+tan(sin(c5)/cos(c6)) as val from ct1;"
)
tdSql.checkRows(100)
tdSql.checkData(0, 0, nan)
tdSql.checkData(1, 0, 0.9092974268256817)
tdSql.checkData(2, 0, -0.27941549819892586)
tdSql.checkData(3, 0, 0.8433250578156978)
tdSql.checkData(4, 0, 0.5514266812416906)
tdSql.checkData(5, 0, -0.8406066116666611)
tdSql.checkData(6, 0, 0.43616107578365054)
tdSql.checkData(7, 0, 0.8974981847584117)
tdSql.checkData(8, 0, -0.8859527784925297)
tdSql.checkData(9, 0, 0.42947071474131504)
tdSql.checkData(10, 0, -0.4990148939921768)
tdSql.checkData(11, 0, -0.9668503083455382)
tdSql.checkData(12, 0, -0.37127069611623675)
tdSql.checkData(13, 0, 0.2583602129593735)
tdSql.checkData(14, 0, -0.34510090189538883)
tdSql.checkData(15, 0, 0.8660995395285155)
tdSql.checkData(16, 0, 0.6937252720798969)
tdSql.checkData(17, 0, -0.992591182028628)
tdSql.checkData(18, 0, -0.9291960033052914)
tdSql.checkData(19, 0, -0.011614784632622178)
tdSql.checkData(20, 0, -0.4106856453154767)
tdSql.checkData(21, 0, -0.36067689504566286)
tdSql.checkData(22, 0, 0.9703087105252133)
tdSql.checkData(23, 0, 0.3329834227491301)
tdSql.checkData(24, 0, -0.7486629772768763)
tdSql.checkData(25, 0, -0.971394847828127)
tdSql.checkData(26, 0, 0.5985902145855062)
tdSql.checkData(27, 0, -0.49186655944242286)
tdSql.checkData(28, 0, -0.4105290272382008)
tdSql.checkData(29, 0, -0.202908293443662)
tdSql.checkData(30, 0, -0.9672568013002486)
tdSql.checkData(31, 0, -0.9144905798912761)
tdSql.checkData(32, 0, -0.930013601079518)
tdSql.checkData(33, 0, 0.004918394988330845)
tdSql.checkData(34, 0, 0.720122562285698)
tdSql.checkData(35, 0, 0.931470218951081)
tdSql.checkData(36, 0, 0.8941486584814015)
tdSql.checkData(37, 0, 0.6498985856147372)
tdSql.checkData(38, 0, -0.9337541085366605)
tdSql.checkData(39, 0, -0.7860584458249767)
tdSql.checkData(40, 0, 0.9097616965457492)
tdSql.checkData(41, 0, 0.9262772442878136)
tdSql.checkData(42, 0, 0.9002636423705703)
tdSql.checkData(43, 0, 0.9333612649834834)
tdSql.checkData(44, 0, 0.08098252188677987)
tdSql.checkData(45, 0, -0.2669453821977269)
tdSql.checkData(46, 0, -0.9864147915539295)
tdSql.checkData(47, 0, 0.7905555341403578)
tdSql.checkData(48, 0, 0.9930380419415296)
tdSql.checkData(49, 0, -0.11973938558937497)
tdSql.checkData(50, 0, 0.0)
tdSql.checkData(51, 0, 75.68593339876413)
tdSql.checkData(52, 0, 5.417928575505387)
tdSql.checkData(53, 0, 8.85648005221507)
tdSql.checkData(54, 0, 18.282204450191365)
tdSql.checkData(55, 0, 24.756425180209273)
tdSql.checkData(56, 0, 35.7004910910186)
tdSql.checkData(57, 0, 50.188813241198766)
tdSql.checkData(58, 0, 63.43204170645191)
tdSql.checkData(59, 0, 80.51408573049088)
tdSql.checkData(60, 0, 100.75762114788726)
tdSql.checkData(61, 0, 121.24877416559158)
tdSql.checkData(62, 0, 143.26187154057212)
tdSql.checkData(63, 0, 169.49921715003558)
tdSql.checkData(64, 0, 197.43268735470073)
tdSql.checkData(65, 0, 223.84781294184071)
tdSql.checkData(66, 0, 256.31002912578884)
tdSql.checkData(67, 0, 289.36766325453783)
tdSql.checkData(68, 0, 321.83943972533865)
tdSql.checkData(69, 0, 361.1527613871425)
tdSql.checkData(70, 0, 398.72830803672844)
tdSql.checkData(71, 0, 417.9185722713414)
tdSql.checkData(72, 0, 484.00885188723004)
tdSql.checkData(73, 0, 471.3913348423639)
tdSql.checkData(74, 0, 577.5805869142416)
tdSql.checkData(75, 0, 624.8656743315343)
tdSql.checkData(76, 0, 678.4187022341146)
tdSql.checkData(77, 0, 728.8671148549121)
tdSql.checkData(78, 0, 783.7108972216736)
tdSql.checkData(79, 0, 842.2274126544997)
tdSql.checkData(80, 0, 899.877243006616)
tdSql.checkData(81, 0, 960.5271464519064)
tdSql.checkData(82, 0, 1024.7777181923664)
tdSql.checkData(83, 0, 1089.0854157079946)
tdSql.checkData(84, 0, 1155.2807954785546)
tdSql.checkData(85, 0, 1225.5127742681332)
tdSql.checkData(86, 0, 1305.6263061095037)
tdSql.checkData(87, 0, 1367.8826349729482)
tdSql.checkData(88, 0, 1444.32066897418)
tdSql.checkData(89, 0, 1521.5116974949854)
tdSql.checkData(90, 0, 1597.9486330581901)
tdSql.checkData(91, 0, 1681.1620533335488)
tdSql.checkData(92, 0, 1762.8611973159218)
tdSql.checkData(93, 0, 1835.2137045408574)
tdSql.checkData(94, 0, 1936.0177065493942)
tdSql.checkData(95, 0, 2004.599358732067)
tdSql.checkData(96, 0, 2117.763602992286)
tdSql.checkData(97, 0, 2208.874824726169)
tdSql.checkData(98, 0, 2306.5731210183926)
tdSql.checkData(99, 0, 2400.9686738603973)
tdSql.query(
"select sin(pow(c1,log(c2))+pow(c2,2)) as val from ct0 union all select pow(c4,2)+tan(sin(c5)/cos(c6)) as val from ct1;"
)
tdSql.checkRows(100)
tdSql.checkData(0, 0, nan)
tdSql.checkData(1, 0, 0.9092974268256817)
tdSql.checkData(2, 0, -0.618143416955856)
tdSql.checkData(3, 0, -0.2212557848433586)
tdSql.checkData(4, 0, -0.7460971214044105)
tdSql.checkData(5, 0, 0.592800037732941)
tdSql.checkData(6, 0, -0.8906573525446361)
tdSql.checkData(7, 0, -0.9099160274536024)
tdSql.checkData(8, 0, 0.9538272638464387)
tdSql.checkData(9, 0, -0.9870736916693152)
tdSql.checkData(10, 0, -0.7678397236409038)
tdSql.checkData(11, 0, 0.9987895951483741)
tdSql.checkData(12, 0, 0.6508715058131205)
tdSql.checkData(13, 0, 0.27310147774290205)
tdSql.checkData(14, 0, -0.852597740468949)
tdSql.checkData(15, 0, 0.35731340778818926)
tdSql.checkData(16, 0, -0.9981208983068915)
tdSql.checkData(17, 0, 0.23713034837959204)
tdSql.checkData(18, 0, -0.9227979044693351)
tdSql.checkData(19, 0, 0.7969587979292067)
tdSql.checkData(20, 0, -0.9894078111821204)
tdSql.checkData(21, 0, 0.5159266172394235)
tdSql.checkData(22, 0, 0.04665947694609208)
tdSql.checkData(23, 0, -0.9057268036004363)
tdSql.checkData(24, 0, 0.5081537719119912)
tdSql.checkData(25, 0, 0.13392418253128227)
tdSql.checkData(26, 0, 0.22117745004778874)
tdSql.checkData(27, 0, 0.3454954775028113)
tdSql.checkData(28, 0, 0.5242670110408245)
tdSql.checkData(29, 0, 0.8951019564578349)
tdSql.checkData(30, 0, 0.9881770927793502)
tdSql.checkData(31, 0, 0.7074846709788886)
tdSql.checkData(32, 0, 0.9954576249796087)
tdSql.checkData(33, 0, -0.7704946306359923)
tdSql.checkData(34, 0, 0.9966097580600035)
tdSql.checkData(35, 0, -0.03188573219367)
tdSql.checkData(36, 0, 0.9672274483362059)
tdSql.checkData(37, 0, -0.5524968695809724)
tdSql.checkData(38, 0, 0.4230579655135496)
tdSql.checkData(39, 0, 0.21369691105494243)
tdSql.checkData(40, 0, -0.46608214968746425)
tdSql.checkData(41, 0, -0.2069391679125316)
tdSql.checkData(42, 0, -0.978130009430021)
tdSql.checkData(43, 0, -0.7145841372258956)
tdSql.checkData(44, 0, -0.07829036190548645)
tdSql.checkData(45, 0, -0.5852465890666977)
tdSql.checkData(46, 0, -0.6043735013959997)
tdSql.checkData(47, 0, 0.4866796582369138)
tdSql.checkData(48, 0, 0.06632187104835804)
tdSql.checkData(49, 0, 0.9288185068522878)
tdSql.checkData(50, 0, 0.0)
tdSql.checkData(51, 0, 75.68593339876413)
tdSql.checkData(52, 0, 5.417928575505387)
tdSql.checkData(53, 0, 8.85648005221507)
tdSql.checkData(54, 0, 18.282204450191365)
tdSql.checkData(55, 0, 24.756425180209273)
tdSql.checkData(56, 0, 35.7004910910186)
tdSql.checkData(57, 0, 50.188813241198766)
tdSql.checkData(58, 0, 63.43204170645191)
tdSql.checkData(59, 0, 80.51408573049088)
tdSql.checkData(60, 0, 100.75762114788726)
tdSql.checkData(61, 0, 121.24877416559158)
tdSql.checkData(62, 0, 143.26187154057212)
tdSql.checkData(63, 0, 169.49921715003558)
tdSql.checkData(64, 0, 197.43268735470073)
tdSql.checkData(65, 0, 223.84781294184071)
tdSql.checkData(66, 0, 256.31002912578884)
tdSql.checkData(67, 0, 289.36766325453783)
tdSql.checkData(68, 0, 321.83943972533865)
tdSql.checkData(69, 0, 361.1527613871425)
tdSql.checkData(70, 0, 398.72830803672844)
tdSql.checkData(71, 0, 417.9185722713414)
tdSql.checkData(72, 0, 484.00885188723004)
tdSql.checkData(73, 0, 471.3913348423639)
tdSql.checkData(74, 0, 577.5805869142416)
tdSql.checkData(75, 0, 624.8656743315343)
tdSql.checkData(76, 0, 678.4187022341146)
tdSql.checkData(77, 0, 728.8671148549121)
tdSql.checkData(78, 0, 783.7108972216736)
tdSql.checkData(79, 0, 842.2274126544997)
tdSql.checkData(80, 0, 899.877243006616)
tdSql.checkData(81, 0, 960.5271464519064)
tdSql.checkData(82, 0, 1024.7777181923664)
tdSql.checkData(83, 0, 1089.0854157079946)
tdSql.checkData(84, 0, 1155.2807954785546)
tdSql.checkData(85, 0, 1225.5127742681332)
tdSql.checkData(86, 0, 1305.6263061095037)
tdSql.checkData(87, 0, 1367.8826349729482)
tdSql.checkData(88, 0, 1444.32066897418)
tdSql.checkData(89, 0, 1521.5116974949854)
tdSql.checkData(90, 0, 1597.9486330581901)
tdSql.checkData(91, 0, 1681.1620533335488)
tdSql.checkData(92, 0, 1762.8611973159218)
tdSql.checkData(93, 0, 1835.2137045408574)
tdSql.checkData(94, 0, 1936.0177065493942)
tdSql.checkData(95, 0, 2004.599358732067)
tdSql.checkData(96, 0, 2117.763602992286)
tdSql.checkData(97, 0, 2208.874824726169)
tdSql.checkData(98, 0, 2306.5731210183926)
tdSql.checkData(99, 0, 2400.9686738603973)
tdSql.query("select asin(c1) from st0 limit 1;")
tdSql.checkRows(1)
tdSql.checkData(0, 0, 0.0)
tdSql.query("select pow(c1,2) from st0 limit 1 offset 2;;")
tdSql.checkRows(1)
tdSql.checkData(0, 0, 4.0)
tdSql.query("select cos(c1) from db0.ct0, db0.ct1 where ct0.ts==ct1.ts;")
tdSql.checkRows(50)
tdSql.checkData(0, 0, 1.0)
tdSql.checkData(1, 0, 0.5403023058681398)
tdSql.checkData(2, 0, -0.4161468365471424)
tdSql.checkData(3, 0, -0.9899924966004454)
tdSql.checkData(4, 0, -0.6536436208636119)
tdSql.checkData(5, 0, 0.28366218546322625)
tdSql.checkData(6, 0, 0.960170286650366)
tdSql.checkData(7, 0, 0.7539022543433046)
tdSql.checkData(8, 0, -0.14550003380861354)
tdSql.checkData(9, 0, -0.9111302618846769)
tdSql.checkData(10, 0, -0.8390715290764524)
tdSql.checkData(11, 0, 0.004425697988050785)
tdSql.checkData(12, 0, 0.8438539587324921)
tdSql.checkData(13, 0, 0.9074467814501962)
tdSql.checkData(14, 0, 0.1367372182078336)
tdSql.checkData(15, 0, -0.7596879128588213)
tdSql.checkData(16, 0, -0.9576594803233847)
tdSql.checkData(17, 0, -0.27516333805159693)
tdSql.checkData(18, 0, 0.6603167082440802)
tdSql.checkData(19, 0, 0.9887046181866692)
tdSql.checkData(20, 0, 0.40808206181339196)
tdSql.checkData(21, 0, -0.5477292602242684)
tdSql.checkData(22, 0, -0.9999608263946371)
tdSql.checkData(23, 0, -0.5328330203333975)
tdSql.checkData(24, 0, 0.424179007336997)
tdSql.checkData(25, 0, 0.9912028118634736)
tdSql.checkData(26, 0, 0.6469193223286404)
tdSql.checkData(27, 0, -0.2921388087338362)
tdSql.checkData(28, 0, -0.9626058663135666)
tdSql.checkData(29, 0, -0.7480575296890003)
tdSql.checkData(30, 0, 0.15425144988758405)
tdSql.checkData(31, 0, 0.9147423578045313)
tdSql.checkData(32, 0, 0.8342233605065102)
tdSql.checkData(33, 0, -0.013276747223059479)
tdSql.checkData(34, 0, -0.8485702747846052)
tdSql.checkData(35, 0, -0.9036922050915067)
tdSql.checkData(36, 0, -0.12796368962740468)
tdSql.checkData(37, 0, 0.7654140519453434)
tdSql.checkData(38, 0, 0.9550736440472949)
tdSql.checkData(39, 0, 0.26664293235993725)
tdSql.checkData(40, 0, -0.6669380616522619)
tdSql.checkData(41, 0, -0.9873392775238264)
tdSql.checkData(42, 0, -0.39998531498835127)
tdSql.checkData(43, 0, 0.5551133015206257)
tdSql.checkData(44, 0, 0.9998433086476912)
tdSql.checkData(45, 0, 0.5253219888177297)
tdSql.checkData(46, 0, -0.4321779448847783)
tdSql.checkData(47, 0, -0.9923354691509287)
tdSql.checkData(48, 0, -0.6401443394691997)
tdSql.checkData(49, 0, 0.3005925437436371)
tdSql.query(
"select sin(sin(sin(sin(sin(sin(sin(sin(sin(sin(sin(sin(sin(sin(sin(sin(c1)))))))))))))))) from st0;"
)
tdSql.checkRows(100)
tdSql.checkData(0, 0, 0.0)
tdSql.checkData(1, 0, 0.38515571309652635)
tdSql.checkData(2, 0, 0.3902026038089464)
tdSql.checkData(3, 0, 0.13455542224130787)
tdSql.checkData(4, 0, -0.3769735598744493)
tdSql.checkData(5, 0, -0.39322796903554574)
tdSql.checkData(6, 0, -0.23651996268319414)
tdSql.checkData(7, 0, 0.3636586143033131)
tdSql.checkData(8, 0, 0.3948481297132482)
tdSql.checkData(9, 0, 0.3013035615379907)
tdSql.checkData(10, 0, -0.3415979020470687)
tdSql.checkData(11, 0, -0.3953760693679444)
tdSql.checkData(12, 0, -0.33980128729652753)
tdSql.checkData(13, 0, 0.30435222656468974)
tdSql.checkData(14, 0, 0.39491114169715646)
tdSql.checkData(15, 0, 0.3625854118079003)
tdSql.checkData(16, 0, -0.24157669718552427)
tdSql.checkData(17, 0, -0.3933659195685728)
tdSql.checkData(18, 0, -0.37631897787570007)
tdSql.checkData(19, 0, 0.14207823704465328)
tdSql.checkData(20, 0, 0.39044261434523814)
tdSql.checkData(21, 0, 0.3847512959295267)
tdSql.checkData(22, 0, -0.008849576117906611)
tdSql.checkData(23, 0, -0.3855481500830306)
tdSql.checkData(24, 0, -0.38995484687725573)
tdSql.checkData(25, 0, -0.126893408273143)
tdSql.checkData(26, 0, 0.37760858396391034)
tdSql.checkData(27, 0, 0.39308462128198374)
tdSql.checkData(28, 0, 0.23131327316607625)
tdSql.checkData(29, 0, -0.3646985418138878)
tdSql.checkData(30, 0, -0.3947809161937072)
tdSql.checkData(31, 0, -0.29815291606002575)
tdSql.checkData(32, 0, 0.3433365642562851)
tdSql.checkData(33, 0, 0.39537224788827796)
tdSql.checkData(34, 0, 0.3379446735775925)
tdSql.checkData(35, 0, -0.3073019994396687)
tdSql.checkData(36, 0, -0.3949699977540669)
tdSql.checkData(37, 0, -0.3614777744074771)
tdSql.checkData(38, 0, 0.24648579565525397)
tdSql.checkData(39, 0, 0.39349857640819885)
tdSql.checkData(40, 0, 0.37564419916566116)
tdSql.checkData(41, 0, -0.14945748476886428)
tdSql.checkData(42, 0, -0.3906750702498718)
tdSql.checkData(43, 0, -0.3843345435654991)
tdSql.checkData(44, 0, 0.017688072907053588)
tdSql.checkData(45, 0, 0.3859289492584567)
tdSql.checkData(46, 0, 0.38969914464525074)
tdSql.checkData(47, 0, 0.11909715912089874)
tdSql.checkData(48, 0, -0.3782246656581614)
tdSql.checkData(49, 0, -0.392935768393244)
tdSql.checkData(50, 0, 0.0)
tdSql.checkData(51, 0, 0.38515571309652635)
tdSql.checkData(52, 0, 0.3902026038089464)
tdSql.checkData(53, 0, 0.13455542224130787)
tdSql.checkData(54, 0, -0.3769735598744493)
tdSql.checkData(55, 0, -0.39322796903554574)
tdSql.checkData(56, 0, -0.23651996268319414)
tdSql.checkData(57, 0, 0.3636586143033131)
tdSql.checkData(58, 0, 0.3948481297132482)
tdSql.checkData(59, 0, 0.3013035615379907)
tdSql.checkData(60, 0, -0.3415979020470687)
tdSql.checkData(61, 0, -0.3953760693679444)
tdSql.checkData(62, 0, -0.33980128729652753)
tdSql.checkData(63, 0, 0.30435222656468974)
tdSql.checkData(64, 0, 0.39491114169715646)
tdSql.checkData(65, 0, 0.3625854118079003)
tdSql.checkData(66, 0, -0.24157669718552427)
tdSql.checkData(67, 0, -0.3933659195685728)
tdSql.checkData(68, 0, -0.37631897787570007)
tdSql.checkData(69, 0, 0.14207823704465328)
tdSql.checkData(70, 0, 0.39044261434523814)
tdSql.checkData(71, 0, 0.3847512959295267)
tdSql.checkData(72, 0, -0.008849576117906611)
tdSql.checkData(73, 0, -0.3855481500830306)
tdSql.checkData(74, 0, -0.38995484687725573)
tdSql.checkData(75, 0, -0.126893408273143)
tdSql.checkData(76, 0, 0.37760858396391034)
tdSql.checkData(77, 0, 0.39308462128198374)
tdSql.checkData(78, 0, 0.23131327316607625)
tdSql.checkData(79, 0, -0.3646985418138878)
tdSql.checkData(80, 0, -0.3947809161937072)
tdSql.checkData(81, 0, -0.29815291606002575)
tdSql.checkData(82, 0, 0.3433365642562851)
tdSql.checkData(83, 0, 0.39537224788827796)
tdSql.checkData(84, 0, 0.3379446735775925)
tdSql.checkData(85, 0, -0.3073019994396687)
tdSql.checkData(86, 0, -0.3949699977540669)
tdSql.checkData(87, 0, -0.3614777744074771)
tdSql.checkData(88, 0, 0.24648579565525397)
tdSql.checkData(89, 0, 0.39349857640819885)
tdSql.checkData(90, 0, 0.37564419916566116)
tdSql.checkData(91, 0, -0.14945748476886428)
tdSql.checkData(92, 0, -0.3906750702498718)
tdSql.checkData(93, 0, -0.3843345435654991)
tdSql.checkData(94, 0, 0.017688072907053588)
tdSql.checkData(95, 0, 0.3859289492584567)
tdSql.checkData(96, 0, 0.38969914464525074)
tdSql.checkData(97, 0, 0.11909715912089874)
tdSql.checkData(98, 0, -0.3782246656581614)
tdSql.checkData(99, 0, -0.392935768393244)
tdSql.execute("drop database db0")
def stop(self):
tdSql.close()
tdLog.success("%s successfully executed" % __file__)
tdCases.addWindows(__file__, TDTestCase())
tdCases.addLinux(__file__, TDTestCase())
Reference in a new issue View git blame Copy permalink