modules/sql-engine/src/integrationTest/sql/group1/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
----
916
-841
0
841
-916
NULL

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

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

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

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

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

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

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

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

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

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

query I
SELECT cast(COS(n::double)*1000 as bigint) FROM numbers ORDER BY n NULLS LAST
----
-399
540
1000
540
-399
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
----
-1546
-785
0
785
1546
NULL

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

skipif ignite3
# https://issues.apache.org/jira/browse/IGNITE-18672
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
-23
0
23
785
NULL

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

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

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

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

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