modules/calcite/src/test/sql/function/numeric/test_trigo.test

# name: test/sql/function/numeric/test_trigo.test
# description: Test trigonometric function
# group: [numeric]

statement ok
CREATE TABLE numbers(n DOUBLE)

statement ok
INSERT INTO numbers VALUES (-42),(-1),(0), (1), (42), (NULL)

query I
SELECT cast(SIN(n::tinyint)*1000 as bigint) FROM numbers ORDER BY n NULLS LAST
----
917
-841
0
841
-917
NULL

query I
SELECT cast(SIN(n::smallint)*1000 as bigint) FROM numbers ORDER BY n NULLS LAST
----
917
-841
0
841
-917
NULL

query I
SELECT cast(SIN(n::integer)*1000 as bigint) FROM numbers ORDER BY n NULLS LAST
----
917
-841
0
841
-917
NULL

query I
SELECT cast(SIN(n::bigint)*1000 as bigint) FROM numbers ORDER BY n NULLS LAST
----
917
-841
0
841
-917
NULL

query I
SELECT cast(SIN(n::float)*1000 as bigint) FROM numbers ORDER BY n NULLS LAST
----
917
-841
0
841
-917
NULL

query I
SELECT cast(SIN(n::double)*1000 as bigint) FROM numbers ORDER BY n NULLS LAST
----
917
-841
0
841
-917
NULL

query I
SELECT cast(COS(n::tinyint)*1000 as bigint) FROM numbers ORDER BY n NULLS LAST
----
-400
540
1000
540
-400
NULL

query I
SELECT cast(COS(n::smallint)*1000 as bigint) FROM numbers ORDER BY n NULLS LAST
----
-400
540
1000
540
-400
NULL

query I
SELECT cast(COS(n::integer)*1000 as bigint) FROM numbers ORDER BY n NULLS LAST
----
-400
540
1000
540
-400
NULL

query I
SELECT cast(COS(n::bigint)*1000 as bigint) FROM numbers ORDER BY n NULLS LAST
----
-400
540
1000
540
-400
NULL

query I
SELECT cast(COS(n::float)*1000 as bigint) FROM numbers ORDER BY n NULLS LAST
----
-400
540
1000
540
-400
NULL

query I
SELECT cast(COS(n::double)*1000 as bigint) FROM numbers ORDER BY n NULLS LAST
----
-400
540
1000
540
-400
NULL

query I
SELECT cast(TAN(n::tinyint)*1000 as bigint) FROM numbers ORDER BY n NULLS LAST
----
-2291
-1557
0
1557
2291
NULL

query I
SELECT cast(TAN(n::smallint)*1000 as bigint) FROM numbers ORDER BY n NULLS LAST
----
-2291
-1557
0
1557
2291
NULL

query I
SELECT cast(TAN(n::integer)*1000 as bigint) FROM numbers ORDER BY n NULLS LAST
----
-2291
-1557
0
1557
2291
NULL

query I
SELECT cast(TAN(n::bigint)*1000 as bigint) FROM numbers ORDER BY n NULLS LAST
----
-2291
-1557
0
1557
2291
NULL

query I
SELECT cast(TAN(n::float)*1000 as bigint) FROM numbers ORDER BY n NULLS LAST
----
-2291
-1557
0
1557
2291
NULL

query I
SELECT cast(TAN(n::double)*1000 as bigint) FROM numbers ORDER BY n NULLS LAST
----
-2291
-1557
0
1557
2291
NULL

query I
SELECT cast(ATAN(n::tinyint)*1000 as bigint) FROM numbers ORDER BY n NULLS LAST
----
-1547
-785
0
785
1547
NULL

query I
SELECT cast(ATAN(n::smallint)*1000 as bigint) FROM numbers ORDER BY n NULLS LAST
----
-1547
-785
0
785
1547
NULL

query I
SELECT cast(ATAN(n::integer)*1000 as bigint) FROM numbers ORDER BY n NULLS LAST
----
-1547
-785
0
785
1547
NULL

query I
SELECT cast(ATAN(n::bigint)*1000 as bigint) FROM numbers ORDER BY n NULLS LAST
----
-1547
-785
0
785
1547
NULL

query I
SELECT cast(ATAN(n::float)*1000 as bigint) FROM numbers ORDER BY n NULLS LAST
----
-1547
-785
0
785
1547
NULL

query I
SELECT cast(ATAN(n::double)*1000 as bigint) FROM numbers ORDER BY n NULLS LAST
----
-1547
-785
0
785
1547
NULL

query I
SELECT cast(ASIN(n::tinyint)*1000 as bigint) FROM numbers  WHERE n between -1 and 1 ORDER BY n
----
-1571
0
1571

query I
SELECT cast(ASIN(n::smallint)*1000 as bigint) FROM numbers  WHERE n between -1 and 1 ORDER BY n
----
-1571
0
1571

query I
SELECT cast(ASIN(n::integer)*1000 as bigint) FROM numbers  WHERE n between -1 and 1 ORDER BY n
----
-1571
0
1571

query I
SELECT cast(ASIN(n::bigint)*1000 as bigint) FROM numbers  WHERE n between -1 and 1 ORDER BY n
----
-1571
0
1571

query I
SELECT cast(ASIN(n::float)*1000 as bigint) FROM numbers  WHERE n between -1 and 1 ORDER BY n
----
-1571
0
1571

query I
SELECT cast(ASIN(n::double)*1000 as bigint) FROM numbers  WHERE n between -1 and 1 ORDER BY n
----
-1571
0
1571

query I
SELECT cast(ACOS(n::tinyint)*1000 as bigint) FROM numbers  WHERE n between -1 and 1 ORDER BY n
----
3142
1571
0

query I
SELECT cast(ACOS(n::smallint)*1000 as bigint) FROM numbers  WHERE n between -1 and 1 ORDER BY n
----
3142
1571
0

query I
SELECT cast(ACOS(n::integer)*1000 as bigint) FROM numbers  WHERE n between -1 and 1 ORDER BY n
----
3142
1571
0

query I
SELECT cast(ACOS(n::bigint)*1000 as bigint) FROM numbers  WHERE n between -1 and 1 ORDER BY n
----
3142
1571
0

query I
SELECT cast(ACOS(n::float)*1000 as bigint) FROM numbers  WHERE n between -1 and 1 ORDER BY n
----
3142
1571
0

query I
SELECT cast(ACOS(n::double)*1000 as bigint) FROM numbers  WHERE n between -1 and 1 ORDER BY n
----
3142
1571
0

statement error
SELECT cast(ASIN(n)*1000 as bigint) FROM numbers ORDER BY n

query I
SELECT cast(COT(n::tinyint)*1000 as bigint) FROM numbers  WHERE n > 0.1 OR N < -0.1 ORDER BY n
----
-436
-642
642
436

query I
SELECT cast(COT(n::smallint)*1000 as bigint) FROM numbers  WHERE n > 0.1 OR N < -0.1 ORDER BY n
----
-436
-642
642
436

query I
SELECT cast(COT(n::integer)*1000 as bigint) FROM numbers  WHERE n > 0.1 OR N < -0.1 ORDER BY n
----
-436
-642
642
436

query I
SELECT cast(COT(n::bigint)*1000 as bigint) FROM numbers  WHERE n > 0.1 OR N < -0.1 ORDER BY n
----
-436
-642
642
436

query I
SELECT cast(COT(n::float)*1000 as bigint) FROM numbers  WHERE n > 0.1 OR N < -0.1 ORDER BY n
----
-436
-642
642
436

query I
SELECT cast(COT(n::double)*1000 as bigint) FROM numbers  WHERE n > 0.1 OR N < -0.1 ORDER BY n
----
-436
-642
642
436

query I
SELECT cast(ATAN2(n::tinyint, 42)*1000 as bigint) FROM numbers ORDER BY n NULLS LAST
----
-785
-24
0
24
785
NULL

query I
SELECT cast(ATAN2(n::smallint, 42)*1000 as bigint) FROM numbers ORDER BY n NULLS LAST
----
-785
-24
0
24
785
NULL

query I
SELECT cast(ATAN2(n::integer, 42)*1000 as bigint) FROM numbers ORDER BY n NULLS LAST
----
-785
-24
0
24
785
NULL

query I
SELECT cast(ATAN2(n::bigint, 42)*1000 as bigint) FROM numbers ORDER BY n NULLS LAST
----
-785
-24
0
24
785
NULL

query I
SELECT cast(ATAN2(n::float, 42)*1000 as bigint) FROM numbers ORDER BY n NULLS LAST
----
-785
-24
0
24
785
NULL

query I
SELECT cast(ATAN2(n::double, 42)*1000 as bigint) FROM numbers ORDER BY n NULLS LAST
----
-785
-24
0
24
785
NULL