This is an automated email from the ASF dual-hosted git repository.
gian pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/druid.git
The following commit(s) were added to refs/heads/master by this push:
new 43edfa366be Use 'trunc' to make certain tests more robust. (#18183)
43edfa366be is described below
commit 43edfa366be7cac5a2a7f16fa4f4a973c2cb2a9a
Author: Gian Merlino <[email protected]>
AuthorDate: Tue Jul 1 08:34:29 2025 -0700
Use 'trunc' to make certain tests more robust. (#18183)
Some queries involving trigonometric, exponential, or logarithmic
functions produce different results on different platforms. This change
uses 'trunc' to harmonize results across platforms.
---
.../array_sql_scalar_numeric_funcs.01.all.iq | 224 +++----
.../array_sql_scalar_numeric_funcs.02.all.iq | 670 +++++++++----------
.../qaUnnest/mv_sql_scalar_numeric_funcs.01.all.iq | 214 +++---
.../qaUnnest/mv_sql_scalar_numeric_funcs.02.all.iq | 736 ++++++++++-----------
4 files changed, 922 insertions(+), 922 deletions(-)
diff --git
a/quidem-ut/src/test/quidem/org.apache.druid.quidem.QTest/qaUnnest/array_sql_scalar_numeric_funcs.01.all.iq
b/quidem-ut/src/test/quidem/org.apache.druid.quidem.QTest/qaUnnest/array_sql_scalar_numeric_funcs.01.all.iq
index 3f6d3a6ed51..816032b5539 100644
---
a/quidem-ut/src/test/quidem/org.apache.druid.quidem.QTest/qaUnnest/array_sql_scalar_numeric_funcs.01.all.iq
+++
b/quidem-ut/src/test/quidem/org.apache.druid.quidem.QTest/qaUnnest/array_sql_scalar_numeric_funcs.01.all.iq
@@ -310,7 +310,7 @@ WHERE (s_int IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B4_C1_D2
#-------------------------------------------------------------------------
-SELECT exp(c)+exp(c) AS col
+SELECT trunc(exp(c),11)+trunc(exp(c),11) AS col
FROM test_unnest,
unnest(json_value(a_nested, '$[1]' RETURNING bigint array)) AS u(c)
WHERE (s_int IN (0,
@@ -319,19 +319,19 @@ WHERE (s_int IN (0,
OR s_int IS NULL)
AND ((exp(c)+exp(c))<99999
OR (exp(c)+exp(c)) IS NULL);
-+------------------+
-| col |
-+------------------+
-| 14.7781121978613 |
-| 14.7781121978613 |
-| 14.7781121978613 |
-| 5.43656365691809 |
-| 5.43656365691809 |
-| 5.43656365691809 |
-| |
-| |
-| |
-+------------------+
++----------------+
+| col |
++----------------+
+| 14.77811219786 |
+| 14.77811219786 |
+| 14.77811219786 |
+| 5.4365636569 |
+| 5.4365636569 |
+| 5.4365636569 |
+| |
+| |
+| |
++----------------+
(9 rows)
!ok
@@ -339,7 +339,7 @@ WHERE (s_int IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B4_C2_D2
#-------------------------------------------------------------------------
-SELECT exp(c+c) AS col
+SELECT trunc(exp(c+c),11) AS col
FROM test_unnest,
unnest(json_value(a_nested, '$[1]' RETURNING bigint array)) AS u(c)
WHERE (s_int IN (0,
@@ -348,19 +348,19 @@ WHERE (s_int IN (0,
OR s_int IS NULL)
AND (exp(c+c)<99999
OR exp(c+c) IS NULL);
-+--------------------+
-| col |
-+--------------------+
-| 54.598150033144236 |
-| 54.598150033144236 |
-| 54.598150033144236 |
-| 7.38905609893065 |
-| 7.38905609893065 |
-| 7.38905609893065 |
-| |
-| |
-| |
-+--------------------+
++----------------+
+| col |
++----------------+
+| 54.59815003314 |
+| 54.59815003314 |
+| 54.59815003314 |
+| 7.38905609893 |
+| 7.38905609893 |
+| 7.38905609893 |
+| |
+| |
+| |
++----------------+
(9 rows)
!ok
@@ -368,7 +368,7 @@ WHERE (s_int IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B4_C3_D2
#-------------------------------------------------------------------------
-SELECT exp(c)+exp(s_int) AS col
+SELECT trunc(exp(c),11)+trunc(exp(s_int),11) AS col
FROM test_unnest,
unnest(json_value(a_nested, '$[1]' RETURNING bigint array)) AS u(c)
WHERE (s_int IN (0,
@@ -377,19 +377,19 @@ WHERE (s_int IN (0,
OR s_int IS NULL)
AND ((exp(c)+exp(s_int))<99999
OR (exp(c)+exp(s_int)) IS NULL);
-+--------------------+
-| col |
-+--------------------+
-| 10.107337927389695 |
-| 10.107337927389695 |
-| 14.7781121978613 |
-| 5.43656365691809 |
-| |
-| |
-| |
-| |
-| |
-+--------------------+
++----------------+
+| col |
++----------------+
+| 10.10733792738 |
+| 10.10733792738 |
+| 14.77811219786 |
+| 5.4365636569 |
+| |
+| |
+| |
+| |
+| |
++----------------+
(9 rows)
!ok
@@ -397,7 +397,7 @@ WHERE (s_int IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B4_C4_D2
#-------------------------------------------------------------------------
-SELECT exp(c+s_int) AS col
+SELECT trunc(exp(c+s_int),11) AS col
FROM test_unnest,
unnest(json_value(a_nested, '$[1]' RETURNING bigint array)) AS u(c)
WHERE (s_int IN (0,
@@ -406,19 +406,19 @@ WHERE (s_int IN (0,
OR s_int IS NULL)
AND (exp(c+s_int)<99999
OR exp(c+s_int) IS NULL);
-+--------------------+
-| col |
-+--------------------+
-| 20.085536923187668 |
-| 20.085536923187668 |
-| 54.598150033144236 |
-| 7.38905609893065 |
-| |
-| |
-| |
-| |
-| |
-+--------------------+
++----------------+
+| col |
++----------------+
+| 20.08553692318 |
+| 20.08553692318 |
+| 54.59815003314 |
+| 7.38905609893 |
+| |
+| |
+| |
+| |
+| |
++----------------+
(9 rows)
!ok
@@ -542,7 +542,7 @@ WHERE (s_int IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B6_C1_D2
#-------------------------------------------------------------------------
-SELECT ln(c)+ln(c) AS col
+SELECT trunc(ln(c),11)+trunc(ln(c),11) AS col
FROM test_unnest,
unnest(json_value(a_nested, '$[1]' RETURNING bigint array)) AS u(c)
WHERE (s_int IN (0,
@@ -551,19 +551,19 @@ WHERE (s_int IN (0,
OR s_int IS NULL)
AND ((ln(c)+ln(c))<99999
OR (ln(c)+ln(c)) IS NULL);
-+--------------------+
-| col |
-+--------------------+
-| 0.0 |
-| 0.0 |
-| 0.0 |
-| 1.3862943611198906 |
-| 1.3862943611198906 |
-| 1.3862943611198906 |
-| |
-| |
-| |
-+--------------------+
++--------------+
+| col |
++--------------+
+| 0.0 |
+| 0.0 |
+| 0.0 |
+| 1.3862943611 |
+| 1.3862943611 |
+| 1.3862943611 |
+| |
+| |
+| |
++--------------+
(9 rows)
!ok
@@ -571,7 +571,7 @@ WHERE (s_int IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B6_C2_D2
#-------------------------------------------------------------------------
-SELECT ln(c+c) AS col
+SELECT trunc(ln(c+c),11) AS col
FROM test_unnest,
unnest(json_value(a_nested, '$[1]' RETURNING bigint array)) AS u(c)
WHERE (s_int IN (0,
@@ -580,19 +580,19 @@ WHERE (s_int IN (0,
OR s_int IS NULL)
AND (ln(c+c)<99999
OR ln(c+c) IS NULL);
-+--------------------+
-| col |
-+--------------------+
-| 0.6931471805599453 |
-| 0.6931471805599453 |
-| 0.6931471805599453 |
-| 1.3862943611198906 |
-| 1.3862943611198906 |
-| 1.3862943611198906 |
-| |
-| |
-| |
-+--------------------+
++---------------+
+| col |
++---------------+
+| 0.69314718055 |
+| 0.69314718055 |
+| 0.69314718055 |
+| 1.38629436111 |
+| 1.38629436111 |
+| 1.38629436111 |
+| |
+| |
+| |
++---------------+
(9 rows)
!ok
@@ -600,7 +600,7 @@ WHERE (s_int IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B6_C3_D2
#-------------------------------------------------------------------------
-SELECT ln(c)+ln(s_int) AS col
+SELECT trunc(ln(c),11)+trunc(ln(s_int),11) AS col
FROM test_unnest,
unnest(json_value(a_nested, '$[1]' RETURNING bigint array)) AS u(c)
WHERE (s_int IN (0,
@@ -609,19 +609,19 @@ WHERE (s_int IN (0,
OR s_int IS NULL)
AND ((ln(c)+ln(s_int))<99999
OR (ln(c)+ln(s_int)) IS NULL);
-+--------------------+
-| col |
-+--------------------+
-| 0.0 |
-| 0.6931471805599453 |
-| 0.6931471805599453 |
-| 1.3862943611198906 |
-| |
-| |
-| |
-| |
-| |
-+--------------------+
++---------------+
+| col |
++---------------+
+| 0.0 |
+| 0.69314718055 |
+| 0.69314718055 |
+| 1.3862943611 |
+| |
+| |
+| |
+| |
+| |
++---------------+
(9 rows)
!ok
@@ -629,7 +629,7 @@ WHERE (s_int IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B6_C4_D2
#-------------------------------------------------------------------------
-SELECT ln(c+s_int) AS col
+SELECT trunc(ln(c+s_int),11) AS col
FROM test_unnest,
unnest(json_value(a_nested, '$[1]' RETURNING bigint array)) AS u(c)
WHERE (s_int IN (0,
@@ -638,19 +638,19 @@ WHERE (s_int IN (0,
OR s_int IS NULL)
AND (ln(c+s_int)<99999
OR ln(c+s_int)<99999 IS NULL);
-+--------------------+
-| col |
-+--------------------+
-| 0.6931471805599453 |
-| 1.0986122886681098 |
-| 1.0986122886681098 |
-| 1.3862943611198906 |
-| |
-| |
-| |
-| |
-| |
-+--------------------+
++---------------+
+| col |
++---------------+
+| 0.69314718055 |
+| 1.09861228866 |
+| 1.09861228866 |
+| 1.38629436111 |
+| |
+| |
+| |
+| |
+| |
++---------------+
(9 rows)
!ok
diff --git
a/quidem-ut/src/test/quidem/org.apache.druid.quidem.QTest/qaUnnest/array_sql_scalar_numeric_funcs.02.all.iq
b/quidem-ut/src/test/quidem/org.apache.druid.quidem.QTest/qaUnnest/array_sql_scalar_numeric_funcs.02.all.iq
index 157e970320f..ccabffa63f8 100644
---
a/quidem-ut/src/test/quidem/org.apache.druid.quidem.QTest/qaUnnest/array_sql_scalar_numeric_funcs.02.all.iq
+++
b/quidem-ut/src/test/quidem/org.apache.druid.quidem.QTest/qaUnnest/array_sql_scalar_numeric_funcs.02.all.iq
@@ -33,7 +33,7 @@ WHERE (s_int IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B14_C1_D2
#-------------------------------------------------------------------------
-SELECT sin(c)+sin(c) AS col
+SELECT trunc(sin(c),11)+trunc(sin(c),11) AS col
FROM test_unnest,
unnest(json_value(a_nested, '$[1]' RETURNING bigint array)) AS u(c)
WHERE (s_int IN (0,
@@ -42,19 +42,19 @@ WHERE (s_int IN (0,
OR s_int IS NULL)
AND ((sin(c)+sin(c))<99999
OR (sin(c)+sin(c)) IS NULL);
-+--------------------+
-| col |
-+--------------------+
-| 1.682941969615793 |
-| 1.682941969615793 |
-| 1.682941969615793 |
-| 1.8185948536513634 |
-| 1.8185948536513634 |
-| 1.8185948536513634 |
-| |
-| |
-| |
-+--------------------+
++---------------+
+| col |
++---------------+
+| 1.6829419696 |
+| 1.6829419696 |
+| 1.6829419696 |
+| 1.81859485364 |
+| 1.81859485364 |
+| 1.81859485364 |
+| |
+| |
+| |
++---------------+
(9 rows)
!ok
@@ -62,7 +62,7 @@ WHERE (s_int IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B14_C2_D2
#-------------------------------------------------------------------------
-SELECT sin(c+c) AS col
+SELECT trunc(sin(c+c),11) AS col
FROM test_unnest,
unnest(json_value(a_nested, '$[1]' RETURNING bigint array)) AS u(c)
WHERE (s_int IN (0,
@@ -71,19 +71,19 @@ WHERE (s_int IN (0,
OR s_int IS NULL)
AND (sin(c+c)<99999
OR sin(c+c) IS NULL);
-+---------------------+
-| col |
-+---------------------+
-| -0.7568024953079282 |
-| -0.7568024953079282 |
-| -0.7568024953079282 |
-| 0.9092974268256817 |
-| 0.9092974268256817 |
-| 0.9092974268256817 |
-| |
-| |
-| |
-+---------------------+
++---------------+
+| col |
++---------------+
+| -0.7568024953 |
+| -0.7568024953 |
+| -0.7568024953 |
+| 0.90929742682 |
+| 0.90929742682 |
+| 0.90929742682 |
+| |
+| |
+| |
++---------------+
(9 rows)
!ok
@@ -91,7 +91,7 @@ WHERE (s_int IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B14_C3_D2
#-------------------------------------------------------------------------
-SELECT sin(c)+sin(s_int) AS col
+SELECT trunc(sin(c),11)+trunc(sin(s_int),11) AS col
FROM test_unnest,
unnest(json_value(a_nested, '$[1]' RETURNING bigint array)) AS u(c)
WHERE (s_int IN (0,
@@ -103,15 +103,15 @@ WHERE (s_int IN (0,
+--------------------+
| col |
+--------------------+
-| 1.682941969615793 |
-| 1.7507684116335782 |
-| 1.7507684116335782 |
-| 1.8185948536513634 |
| |
| |
| |
| |
| |
+| 1.6829419696 |
+| 1.7507684116200002 |
+| 1.7507684116200002 |
+| 1.81859485364 |
+--------------------+
(9 rows)
@@ -120,7 +120,7 @@ WHERE (s_int IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B14_C4_D2
#-------------------------------------------------------------------------
-SELECT sin(c+s_int) AS col
+SELECT trunc(sin(c+s_int),11) AS col
FROM test_unnest,
unnest(json_value(a_nested, '$[1]' RETURNING bigint array)) AS u(c)
WHERE (s_int IN (0,
@@ -129,19 +129,19 @@ WHERE (s_int IN (0,
OR s_int IS NULL)
AND (sin(c+s_int)<99999
OR sin(c+s_int)<99999 IS NULL);
-+---------------------+
-| col |
-+---------------------+
-| -0.7568024953079282 |
-| 0.1411200080598672 |
-| 0.1411200080598672 |
-| 0.9092974268256817 |
-| |
-| |
-| |
-| |
-| |
-+---------------------+
++---------------+
+| col |
++---------------+
+| -0.7568024953 |
+| 0.14112000805 |
+| 0.14112000805 |
+| 0.90929742682 |
+| |
+| |
+| |
+| |
+| |
++---------------+
(9 rows)
!ok
@@ -149,7 +149,7 @@ WHERE (s_int IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B15_C1_D2
#-------------------------------------------------------------------------
-SELECT cos(c)+cos(c) AS col
+SELECT trunc(cos(c),11)+trunc(cos(c),11) AS col
FROM test_unnest,
unnest(json_value(a_nested, '$[1]' RETURNING bigint array)) AS u(c)
WHERE (s_int IN (0,
@@ -158,19 +158,19 @@ WHERE (s_int IN (0,
OR s_int IS NULL)
AND ((cos(c)+cos(c))<99999
OR (cos(c)+cos(c)) IS NULL);
-+---------------------+
-| col |
-+---------------------+
-| -0.8322936730942848 |
-| -0.8322936730942848 |
-| -0.8322936730942848 |
-| 1.0806046117362795 |
-| 1.0806046117362795 |
-| 1.0806046117362795 |
-| |
-| |
-| |
-+---------------------+
++----------------+
+| col |
++----------------+
+| -0.83229367308 |
+| -0.83229367308 |
+| -0.83229367308 |
+| 1.08060461172 |
+| 1.08060461172 |
+| 1.08060461172 |
+| |
+| |
+| |
++----------------+
(9 rows)
!ok
@@ -178,7 +178,7 @@ WHERE (s_int IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B15_C2_D2
#-------------------------------------------------------------------------
-SELECT cos(c+c) AS col
+SELECT trunc(cos(c+c),11) AS col
FROM test_unnest,
unnest(json_value(a_nested, '$[1]' RETURNING bigint array)) AS u(c)
WHERE (s_int IN (0,
@@ -187,19 +187,19 @@ WHERE (s_int IN (0,
OR s_int IS NULL)
AND (cos(c+c)<99999
OR cos(c+c) IS NULL);
-+---------------------+
-| col |
-+---------------------+
-| -0.4161468365471424 |
-| -0.4161468365471424 |
-| -0.4161468365471424 |
-| -0.6536436208636119 |
-| -0.6536436208636119 |
-| -0.6536436208636119 |
-| |
-| |
-| |
-+---------------------+
++----------------+
+| col |
++----------------+
+| -0.41614683654 |
+| -0.41614683654 |
+| -0.41614683654 |
+| -0.65364362086 |
+| -0.65364362086 |
+| -0.65364362086 |
+| |
+| |
+| |
++----------------+
(9 rows)
!ok
@@ -207,7 +207,7 @@ WHERE (s_int IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B15_C3_D2
#-------------------------------------------------------------------------
-SELECT cos(c)+cos(s_int) AS col
+SELECT trunc(cos(c),11)+trunc(cos(s_int),11) AS col
FROM test_unnest,
unnest(json_value(a_nested, '$[1]' RETURNING bigint array)) AS u(c)
WHERE (s_int IN (0,
@@ -219,15 +219,15 @@ WHERE (s_int IN (0,
+---------------------+
| col |
+---------------------+
-| -0.8322936730942848 |
-| 0.12415546932099736 |
-| 0.12415546932099736 |
-| 1.0806046117362795 |
| |
| |
| |
| |
| |
+| -0.83229367308 |
+| 0.12415546932000004 |
+| 0.12415546932000004 |
+| 1.08060461172 |
+---------------------+
(9 rows)
@@ -236,7 +236,7 @@ WHERE (s_int IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B15_C4_D2
#-------------------------------------------------------------------------
-SELECT cos(c+s_int) AS col
+SELECT trunc(cos(c+s_int),11) AS col
FROM test_unnest,
unnest(json_value(a_nested, '$[1]' RETURNING bigint array)) AS u(c)
WHERE (s_int IN (0,
@@ -245,19 +245,19 @@ WHERE (s_int IN (0,
OR s_int IS NULL)
AND (cos(c+s_int)<99999
OR cos(c+s_int) IS NULL);
-+---------------------+
-| col |
-+---------------------+
-| -0.4161468365471424 |
-| -0.6536436208636119 |
-| -0.9899924966004454 |
-| -0.9899924966004454 |
-| |
-| |
-| |
-| |
-| |
-+---------------------+
++----------------+
+| col |
++----------------+
+| -0.41614683654 |
+| -0.65364362086 |
+| -0.9899924966 |
+| -0.9899924966 |
+| |
+| |
+| |
+| |
+| |
++----------------+
(9 rows)
!ok
@@ -265,7 +265,7 @@ WHERE (s_int IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B16_C1_D2
#-------------------------------------------------------------------------
-SELECT tan(c)+tan(c) AS col
+SELECT trunc(tan(c),11)+trunc(tan(c),11) AS col
FROM test_unnest,
unnest(json_value(a_nested, '$[1]' RETURNING bigint array)) AS u(c)
WHERE (s_int IN (0,
@@ -274,19 +274,19 @@ WHERE (s_int IN (0,
OR s_int IS NULL)
AND ((tan(c)+tan(c))<99999
OR (tan(c)+tan(c)) IS NULL);
-+--------------------+
-| col |
-+--------------------+
-| -4.370079726523038 |
-| -4.370079726523038 |
-| -4.370079726523038 |
-| 3.1148154493098046 |
-| 3.1148154493098046 |
-| 3.1148154493098046 |
-| |
-| |
-| |
-+--------------------+
++----------------+
+| col |
++----------------+
+| -4.37007972652 |
+| -4.37007972652 |
+| -4.37007972652 |
+| 3.1148154493 |
+| 3.1148154493 |
+| 3.1148154493 |
+| |
+| |
+| |
++----------------+
(9 rows)
!ok
@@ -294,7 +294,7 @@ WHERE (s_int IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B16_C2_D2
#-------------------------------------------------------------------------
-SELECT tan(c+c) AS col
+SELECT trunc(tan(c+c),11) AS col
FROM test_unnest,
unnest(json_value(a_nested, '$[1]' RETURNING bigint array)) AS u(c)
WHERE (s_int IN (0,
@@ -303,19 +303,19 @@ WHERE (s_int IN (0,
OR s_int IS NULL)
AND (tan(c+c)<99999
OR tan(c+c) IS NULL);
-+--------------------+
-| col |
-+--------------------+
-| -2.185039863261519 |
-| -2.185039863261519 |
-| -2.185039863261519 |
-| 1.1578212823495775 |
-| 1.1578212823495775 |
-| 1.1578212823495775 |
-| |
-| |
-| |
-+--------------------+
++----------------+
+| col |
++----------------+
+| -2.18503986326 |
+| -2.18503986326 |
+| -2.18503986326 |
+| 1.15782128234 |
+| 1.15782128234 |
+| 1.15782128234 |
+| |
+| |
+| |
++----------------+
(9 rows)
!ok
@@ -323,7 +323,7 @@ WHERE (s_int IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B16_C3_D2
#-------------------------------------------------------------------------
-SELECT tan(c)+tan(s_int) AS col
+SELECT trunc(tan(c),11)+trunc(tan(s_int),11) AS col
FROM test_unnest,
unnest(json_value(a_nested, '$[1]' RETURNING bigint array)) AS u(c)
WHERE (s_int IN (0,
@@ -335,15 +335,15 @@ WHERE (s_int IN (0,
+---------------------+
| col |
+---------------------+
-| -0.6276321386066166 |
-| -0.6276321386066166 |
-| -4.370079726523038 |
-| 3.1148154493098046 |
| |
| |
| |
| |
| |
+| -0.6276321386100001 |
+| -0.6276321386100001 |
+| -4.37007972652 |
+| 3.1148154493 |
+---------------------+
(9 rows)
@@ -352,7 +352,7 @@ WHERE (s_int IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B16_C4_D2
#-------------------------------------------------------------------------
-SELECT tan(c+s_int) AS col
+SELECT trunc(tan(c+s_int),11) AS col
FROM test_unnest,
unnest(json_value(a_nested, '$[1]' RETURNING bigint array)) AS u(c)
WHERE (s_int IN (0,
@@ -361,19 +361,19 @@ WHERE (s_int IN (0,
OR s_int IS NULL)
AND (tan(c+s_int)<99999
OR tan(c+s_int) IS NULL);
-+---------------------+
-| col |
-+---------------------+
-| -0.1425465430742778 |
-| -0.1425465430742778 |
-| -2.185039863261519 |
-| 1.1578212823495775 |
-| |
-| |
-| |
-| |
-| |
-+---------------------+
++----------------+
+| col |
++----------------+
+| -0.14254654307 |
+| -0.14254654307 |
+| -2.18503986326 |
+| 1.15782128234 |
+| |
+| |
+| |
+| |
+| |
++----------------+
(9 rows)
!ok
@@ -381,7 +381,7 @@ WHERE (s_int IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B17_C1_D2
#-------------------------------------------------------------------------
-SELECT cot(c)+cot(c) AS col
+SELECT trunc(cot(c),11)+trunc(cot(c),11) AS col
FROM test_unnest,
unnest(json_value(a_nested, '$[1]' RETURNING bigint array)) AS u(c)
WHERE (s_int IN (0,
@@ -390,19 +390,19 @@ WHERE (s_int IN (0,
OR s_int IS NULL)
AND ((cot(c)+cot(c))<99999
OR (cot(c)+cot(c)) IS NULL);
-+---------------------+
-| col |
-+---------------------+
-| -0.9153151087205715 |
-| -0.9153151087205715 |
-| -0.9153151087205715 |
-| 1.2841852318686615 |
-| 1.2841852318686615 |
-| 1.2841852318686615 |
-| |
-| |
-| |
-+---------------------+
++----------------+
+| col |
++----------------+
+| -0.91531510872 |
+| -0.91531510872 |
+| -0.91531510872 |
+| 1.28418523186 |
+| 1.28418523186 |
+| 1.28418523186 |
+| |
+| |
+| |
++----------------+
(9 rows)
!ok
@@ -410,7 +410,7 @@ WHERE (s_int IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B17_C2_D2
#-------------------------------------------------------------------------
-SELECT cot(c+c) AS col
+SELECT trunc(cot(c+c),11) AS col
FROM test_unnest,
unnest(json_value(a_nested, '$[1]' RETURNING bigint array)) AS u(c)
WHERE (s_int IN (0,
@@ -419,19 +419,19 @@ WHERE (s_int IN (0,
OR s_int IS NULL)
AND (cot(c+c)<99999
OR cot(c+c) IS NULL);
-+----------------------+
-| col |
-+----------------------+
-| -0.45765755436028577 |
-| -0.45765755436028577 |
-| -0.45765755436028577 |
-| 0.8636911544506167 |
-| 0.8636911544506167 |
-| 0.8636911544506167 |
-| |
-| |
-| |
-+----------------------+
++----------------+
+| col |
++----------------+
+| -0.45765755436 |
+| -0.45765755436 |
+| -0.45765755436 |
+| 0.86369115445 |
+| 0.86369115445 |
+| 0.86369115445 |
+| |
+| |
+| |
++----------------+
(9 rows)
!ok
@@ -439,7 +439,7 @@ WHERE (s_int IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B17_C3_D2
#-------------------------------------------------------------------------
-SELECT cot(c)+cot(s_int) AS col
+SELECT trunc(cot(c),11)+trunc(cot(s_int),11) AS col
FROM test_unnest,
unnest(json_value(a_nested, '$[1]' RETURNING bigint array)) AS u(c)
WHERE (s_int IN (0,
@@ -448,19 +448,19 @@ WHERE (s_int IN (0,
OR s_int IS NULL)
AND ((cot(c)+cot(s_int))<99999
OR (cot(c)+cot(s_int)) IS NULL);
-+---------------------+
-| col |
-+---------------------+
-| -0.9153151087205715 |
-| 0.184435061574045 |
-| 0.184435061574045 |
-| 1.2841852318686615 |
-| |
-| |
-| |
-| |
-| |
-+---------------------+
++----------------+
+| col |
++----------------+
+| -0.91531510872 |
+| 0.18443506157 |
+| 0.18443506157 |
+| 1.28418523186 |
+| |
+| |
+| |
+| |
+| |
++----------------+
(9 rows)
!ok
@@ -468,7 +468,7 @@ WHERE (s_int IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B17_C4_D2
#-------------------------------------------------------------------------
-SELECT cot(c+s_int) AS col
+SELECT trunc(cot(c+s_int),11) AS col
FROM test_unnest,
unnest(json_value(a_nested, '$[1]' RETURNING bigint array)) AS u(c)
WHERE (s_int IN (0,
@@ -477,19 +477,19 @@ WHERE (s_int IN (0,
OR s_int IS NULL)
AND (cot(c+s_int)<99999
OR cot(c+s_int) IS NULL);
-+----------------------+
-| col |
-+----------------------+
-| -0.45765755436028577 |
-| -7.015252551434534 |
-| -7.015252551434534 |
-| 0.8636911544506167 |
-| |
-| |
-| |
-| |
-| |
-+----------------------+
++----------------+
+| col |
++----------------+
+| -0.45765755436 |
+| -7.01525255143 |
+| -7.01525255143 |
+| 0.86369115445 |
+| |
+| |
+| |
+| |
+| |
++----------------+
(9 rows)
!ok
@@ -497,7 +497,7 @@ WHERE (s_int IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B18_C1_D2
#-------------------------------------------------------------------------
-SELECT asin(c)+asin(c) AS col
+SELECT trunc(asin(c),11)+trunc(asin(c),11) AS col
FROM test_unnest,
unnest(json_value(a_nested, '$[1]' RETURNING bigint array)) AS u(c)
WHERE (s_int IN (0,
@@ -506,16 +506,16 @@ WHERE (s_int IN (0,
OR s_int IS NULL)
AND ((asin(c)+asin(c))<99999
OR (asin(c)+asin(c)) IS NULL);
-+-------------------+
-| col |
-+-------------------+
-| 3.141592653589793 |
-| 3.141592653589793 |
-| 3.141592653589793 |
-| |
-| |
-| |
-+-------------------+
++---------------+
+| col |
++---------------+
+| 3.14159265358 |
+| 3.14159265358 |
+| 3.14159265358 |
+| |
+| |
+| |
++---------------+
(6 rows)
!ok
@@ -523,7 +523,7 @@ WHERE (s_int IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B18_C2_D2
#-------------------------------------------------------------------------
-SELECT asin(c+c) AS col
+SELECT trunc(asin(c+c),11) AS col
FROM test_unnest,
unnest(json_value(a_nested, '$[1]' RETURNING bigint array)) AS u(c)
WHERE (s_int IN (0,
@@ -546,7 +546,7 @@ WHERE (s_int IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B18_C3_D2
#-------------------------------------------------------------------------
-SELECT asin(c)+asin(s_int) AS col
+SELECT trunc(asin(c),11)+trunc(asin(s_int),11) AS col
FROM test_unnest,
unnest(json_value(a_nested, '$[1]' RETURNING bigint array)) AS u(c)
WHERE (s_int IN (0,
@@ -555,16 +555,16 @@ WHERE (s_int IN (0,
OR s_int IS NULL)
AND ((asin(c)+asin(s_int))<99999
OR (asin(c)+asin(s_int)) IS NULL);
-+-------------------+
-| col |
-+-------------------+
-| 3.141592653589793 |
-| |
-| |
-| |
-| |
-| |
-+-------------------+
++---------------+
+| col |
++---------------+
+| 3.14159265358 |
+| |
+| |
+| |
+| |
+| |
++---------------+
(6 rows)
!ok
@@ -572,7 +572,7 @@ WHERE (s_int IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B18_C4_D2
#-------------------------------------------------------------------------
-SELECT asin(c+s_int) AS col
+SELECT trunc(asin(c+s_int),11) AS col
FROM test_unnest,
unnest(json_value(a_nested, '$[1]' RETURNING bigint array)) AS u(c)
WHERE (s_int IN (0,
@@ -623,7 +623,7 @@ WHERE (s_int IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B19_C2_D2
#-------------------------------------------------------------------------
-SELECT acos(c+c) AS col
+SELECT trunc(acos(c+c),11) AS col
FROM test_unnest,
unnest(json_value(a_nested, '$[1]' RETURNING bigint array)) AS u(c)
WHERE (s_int IN (0,
@@ -672,7 +672,7 @@ WHERE (s_int IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B19_C4_D2
#-------------------------------------------------------------------------
-SELECT acos(c+s_int) AS col
+SELECT trunc(acos(c+s_int),11) AS col
FROM test_unnest,
unnest(json_value(a_nested, '$[1]' RETURNING bigint array)) AS u(c)
WHERE (s_int IN (0,
@@ -697,7 +697,7 @@ WHERE (s_int IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B20_C1_D2
#-------------------------------------------------------------------------
-SELECT atan(c)+atan(c) AS col
+SELECT trunc(atan(c),11)+trunc(atan(c),11) AS col
FROM test_unnest,
unnest(json_value(a_nested, '$[1]' RETURNING bigint array)) AS u(c)
WHERE (s_int IN (0,
@@ -706,19 +706,19 @@ WHERE (s_int IN (0,
OR s_int IS NULL)
AND ((atan(c)+atan(c))<99999
OR (atan(c)+atan(c)) IS NULL);
-+--------------------+
-| col |
-+--------------------+
-| 1.5707963267948966 |
-| 1.5707963267948966 |
-| 1.5707963267948966 |
-| 2.214297435588181 |
-| 2.214297435588181 |
-| 2.214297435588181 |
-| |
-| |
-| |
-+--------------------+
++---------------+
+| col |
++---------------+
+| 1.57079632678 |
+| 1.57079632678 |
+| 1.57079632678 |
+| 2.21429743558 |
+| 2.21429743558 |
+| 2.21429743558 |
+| |
+| |
+| |
++---------------+
(9 rows)
!ok
@@ -726,7 +726,7 @@ WHERE (s_int IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B20_C2_D2
#-------------------------------------------------------------------------
-SELECT atan(c+c) AS col
+SELECT trunc(atan(c+c),11) AS col
FROM test_unnest,
unnest(json_value(a_nested, '$[1]' RETURNING bigint array)) AS u(c)
WHERE (s_int IN (0,
@@ -735,19 +735,19 @@ WHERE (s_int IN (0,
OR s_int IS NULL)
AND (atan(c+c)<99999
OR atan(c+c) IS NULL);
-+--------------------+
-| col |
-+--------------------+
-| 1.1071487177940904 |
-| 1.1071487177940904 |
-| 1.1071487177940904 |
-| 1.3258176636680326 |
-| 1.3258176636680326 |
-| 1.3258176636680326 |
-| |
-| |
-| |
-+--------------------+
++---------------+
+| col |
++---------------+
+| 1.10714871779 |
+| 1.10714871779 |
+| 1.10714871779 |
+| 1.32581766366 |
+| 1.32581766366 |
+| 1.32581766366 |
+| |
+| |
+| |
++---------------+
(9 rows)
!ok
@@ -755,7 +755,7 @@ WHERE (s_int IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B20_C3_D2
#-------------------------------------------------------------------------
-SELECT atan(c)+atan(s_int) AS col
+SELECT trunc(atan(c),11)+trunc(atan(s_int),11) AS col
FROM test_unnest,
unnest(json_value(a_nested, '$[1]' RETURNING bigint array)) AS u(c)
WHERE (s_int IN (0,
@@ -764,19 +764,19 @@ WHERE (s_int IN (0,
OR s_int IS NULL)
AND ((atan(c)+atan(s_int))<99999
OR (atan(c)+atan(s_int)) IS NULL);
-+--------------------+
-| col |
-+--------------------+
-| 1.5707963267948966 |
-| 1.8925468811915387 |
-| 1.8925468811915387 |
-| 2.214297435588181 |
-| |
-| |
-| |
-| |
-| |
-+--------------------+
++---------------+
+| col |
++---------------+
+| 1.57079632678 |
+| 1.89254688118 |
+| 1.89254688118 |
+| 2.21429743558 |
+| |
+| |
+| |
+| |
+| |
++---------------+
(9 rows)
!ok
@@ -784,7 +784,7 @@ WHERE (s_int IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B20_C4_D2
#-------------------------------------------------------------------------
-SELECT atan(c+s_int) AS col
+SELECT trunc(atan(c+s_int),11) AS col
FROM test_unnest,
unnest(json_value(a_nested, '$[1]' RETURNING bigint array)) AS u(c)
WHERE (s_int IN (0,
@@ -793,19 +793,19 @@ WHERE (s_int IN (0,
OR s_int IS NULL)
AND (atan(c+s_int)<99999
OR atan(c+s_int) IS NULL);
-+--------------------+
-| col |
-+--------------------+
-| 1.1071487177940904 |
-| 1.2490457723982544 |
-| 1.2490457723982544 |
-| 1.3258176636680326 |
-| |
-| |
-| |
-| |
-| |
-+--------------------+
++---------------+
+| col |
++---------------+
+| 1.10714871779 |
+| 1.24904577239 |
+| 1.24904577239 |
+| 1.32581766366 |
+| |
+| |
+| |
+| |
+| |
++---------------+
(9 rows)
!ok
@@ -813,7 +813,7 @@ WHERE (s_int IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B21_C1_D2
#-------------------------------------------------------------------------
-SELECT atan2(c, 1)+atan2(c, 1) AS col
+SELECT trunc(atan2(c, 1),11)+trunc(atan2(c, 1),11) AS col
FROM test_unnest,
unnest(json_value(a_nested, '$[1]' RETURNING bigint array)) AS u(c)
WHERE (s_int IN (0,
@@ -822,19 +822,19 @@ WHERE (s_int IN (0,
OR s_int IS NULL)
AND ((atan2(c, 1)+atan2(c, 1))<99999
OR (atan2(c, 1)+atan2(c, 1)) IS NULL);
-+--------------------+
-| col |
-+--------------------+
-| 1.5707963267948966 |
-| 1.5707963267948966 |
-| 1.5707963267948966 |
-| 2.214297435588181 |
-| 2.214297435588181 |
-| 2.214297435588181 |
-| |
-| |
-| |
-+--------------------+
++---------------+
+| col |
++---------------+
+| 1.57079632678 |
+| 1.57079632678 |
+| 1.57079632678 |
+| 2.21429743558 |
+| 2.21429743558 |
+| 2.21429743558 |
+| |
+| |
+| |
++---------------+
(9 rows)
!ok
@@ -842,7 +842,7 @@ WHERE (s_int IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B21_C2_D2
#-------------------------------------------------------------------------
-SELECT atan2(c, c) AS col
+SELECT trunc(atan2(c, c),11) AS col
FROM test_unnest,
unnest(json_value(a_nested, '$[1]' RETURNING bigint array)) AS u(c)
WHERE (s_int IN (0,
@@ -851,19 +851,19 @@ WHERE (s_int IN (0,
OR s_int IS NULL)
AND (atan2(c, c)<99999
OR atan2(c, c) IS NULL);
-+--------------------+
-| col |
-+--------------------+
-| 0.7853981633974483 |
-| 0.7853981633974483 |
-| 0.7853981633974483 |
-| 0.7853981633974483 |
-| 0.7853981633974483 |
-| 0.7853981633974483 |
-| |
-| |
-| |
-+--------------------+
++---------------+
+| col |
++---------------+
+| 0.78539816339 |
+| 0.78539816339 |
+| 0.78539816339 |
+| 0.78539816339 |
+| 0.78539816339 |
+| 0.78539816339 |
+| |
+| |
+| |
++---------------+
(9 rows)
!ok
@@ -871,7 +871,7 @@ WHERE (s_int IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B21_C3_D2
#-------------------------------------------------------------------------
-SELECT atan2(c, 1)+atan2(s_int, 1) AS col
+SELECT trunc(atan2(c, 1),11)+trunc(atan2(s_int, 1),11) AS col
FROM test_unnest,
unnest(json_value(a_nested, '$[1]' RETURNING bigint array)) AS u(c)
WHERE (s_int IN (0,
@@ -880,19 +880,19 @@ WHERE (s_int IN (0,
OR s_int IS NULL)
AND ((atan2(c, 1)+atan2(s_int, 1))<99999
OR (atan2(c, 1)+atan2(s_int, 1)) IS NULL);
-+--------------------+
-| col |
-+--------------------+
-| 1.5707963267948966 |
-| 1.8925468811915387 |
-| 1.8925468811915387 |
-| 2.214297435588181 |
-| |
-| |
-| |
-| |
-| |
-+--------------------+
++---------------+
+| col |
++---------------+
+| 1.57079632678 |
+| 1.89254688118 |
+| 1.89254688118 |
+| 2.21429743558 |
+| |
+| |
+| |
+| |
+| |
++---------------+
(9 rows)
!ok
@@ -900,7 +900,7 @@ WHERE (s_int IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B21_C4_D2
#-------------------------------------------------------------------------
-SELECT atan2(c, s_int) AS col
+SELECT trunc(atan2(c, s_int),11) AS col
FROM test_unnest,
unnest(json_value(a_nested, '$[1]' RETURNING bigint array)) AS u(c)
WHERE (s_int IN (0,
@@ -909,19 +909,19 @@ WHERE (s_int IN (0,
OR s_int IS NULL)
AND (atan2(c, s_int)<99999
OR atan2(c, s_int) IS NULL);
-+--------------------+
-| col |
-+--------------------+
-| 0.4636476090008061 |
-| 0.7853981633974483 |
-| 0.7853981633974483 |
-| 1.1071487177940904 |
-| |
-| |
-| |
-| |
-| |
-+--------------------+
++---------------+
+| col |
++---------------+
+| 0.463647609 |
+| 0.78539816339 |
+| 0.78539816339 |
+| 1.10714871779 |
+| |
+| |
+| |
+| |
+| |
++---------------+
(9 rows)
!ok
diff --git
a/quidem-ut/src/test/quidem/org.apache.druid.quidem.QTest/qaUnnest/mv_sql_scalar_numeric_funcs.01.all.iq
b/quidem-ut/src/test/quidem/org.apache.druid.quidem.QTest/qaUnnest/mv_sql_scalar_numeric_funcs.01.all.iq
index c35d11c0793..f21f4b5b701 100644
---
a/quidem-ut/src/test/quidem/org.apache.druid.quidem.QTest/qaUnnest/mv_sql_scalar_numeric_funcs.01.all.iq
+++
b/quidem-ut/src/test/quidem/org.apache.druid.quidem.QTest/qaUnnest/mv_sql_scalar_numeric_funcs.01.all.iq
@@ -336,26 +336,26 @@ WHERE c_long IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B4_C1
#-------------------------------------------------------------------------
-SELECT exp(c)+exp(c) AS col
+SELECT trunc(exp(c), 11) + trunc(exp(c), 11) AS col
FROM test_unnest,
unnest(mv_to_array(c_mv_num_with_null_and_empty_val)) AS u(c)
WHERE c_long IN (0,
1,
2)
AND (exp(c)+exp(c))<>0;
-+--------------------+
-| col |
-+--------------------+
-| 14.7781121978613 |
-| 14.7781121978613 |
-| 14.7781121978613 |
-| 40.171073846375336 |
-| 40.171073846375336 |
-| 40.171073846375336 |
-| 5.43656365691809 |
-| 5.43656365691809 |
-| 5.43656365691809 |
-+--------------------+
++----------------+
+| col |
++----------------+
+| 14.77811219786 |
+| 14.77811219786 |
+| 14.77811219786 |
+| 40.17107384636 |
+| 40.17107384636 |
+| 40.17107384636 |
+| 5.4365636569 |
+| 5.4365636569 |
+| 5.4365636569 |
++----------------+
(9 rows)
!ok
@@ -363,26 +363,26 @@ WHERE c_long IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B4_C2
#-------------------------------------------------------------------------
-SELECT exp(c+c) AS col
+SELECT trunc(exp(c+c), 11) AS col
FROM test_unnest,
unnest(mv_to_array(c_mv_num_with_null_and_empty_val)) AS u(c)
WHERE c_long IN (0,
1,
2)
AND exp(c+c)<>0;
-+--------------------+
-| col |
-+--------------------+
-| 403.4287934927351 |
-| 403.4287934927351 |
-| 403.4287934927351 |
-| 54.598150033144236 |
-| 54.598150033144236 |
-| 54.598150033144236 |
-| 7.38905609893065 |
-| 7.38905609893065 |
-| 7.38905609893065 |
-+--------------------+
++-----------------+
+| col |
++-----------------+
+| 403.42879349273 |
+| 403.42879349273 |
+| 403.42879349273 |
+| 54.59815003314 |
+| 54.59815003314 |
+| 54.59815003314 |
+| 7.38905609893 |
+| 7.38905609893 |
+| 7.38905609893 |
++-----------------+
(9 rows)
!ok
@@ -390,26 +390,26 @@ WHERE c_long IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B4_C3
#-------------------------------------------------------------------------
-SELECT exp(c)+exp(c_long) AS col
+SELECT trunc(exp(c), 11)+trunc(exp(c_long), 11) AS col
FROM test_unnest,
unnest(mv_to_array(c_mv_num_with_null_and_empty_val)) AS u(c)
WHERE c_long IN (0,
1,
2)
AND (exp(c)+exp(c_long))<>0;
-+--------------------+
-| col |
-+--------------------+
-| 10.107337927389695 |
-| 10.107337927389695 |
-| 14.7781121978613 |
-| 21.085536923187668 |
-| 22.803818751646713 |
-| 27.47459302211832 |
-| 3.718281828459045 |
-| 5.43656365691809 |
-| 8.38905609893065 |
-+--------------------+
++----------------+
+| col |
++----------------+
+| 10.10733792738 |
+| 10.10733792738 |
+| 14.77811219786 |
+| 21.08553692318 |
+| 22.80381875163 |
+| 27.47459302211 |
+| 3.71828182845 |
+| 5.4365636569 |
+| 8.38905609893 |
++----------------+
(9 rows)
!ok
@@ -417,26 +417,26 @@ WHERE c_long IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B4_C4
#-------------------------------------------------------------------------
-SELECT exp(c+c_long) AS col
+SELECT trunc(exp(c+c_long), 11) AS col
FROM test_unnest,
unnest(mv_to_array(c_mv_num_with_null_and_empty_val)) AS u(c)
WHERE c_long IN (0,
1,
2)
AND exp(c+c_long)<>0;
-+--------------------+
-| col |
-+--------------------+
-| 148.4131591025766 |
-| 2.718281828459045 |
-| 20.085536923187668 |
-| 20.085536923187668 |
-| 20.085536923187668 |
-| 54.598150033144236 |
-| 54.598150033144236 |
-| 7.38905609893065 |
-| 7.38905609893065 |
-+--------------------+
++-----------------+
+| col |
++-----------------+
+| 148.41315910257 |
+| 2.71828182845 |
+| 20.08553692318 |
+| 20.08553692318 |
+| 20.08553692318 |
+| 54.59815003314 |
+| 54.59815003314 |
+| 7.38905609893 |
+| 7.38905609893 |
++-----------------+
(9 rows)
!ok
@@ -568,26 +568,26 @@ WHERE c_long IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B6_C1
#-------------------------------------------------------------------------
-SELECT ln(c)+ln(c) AS col
+SELECT trunc(ln(c),11)+trunc(ln(c),11) AS col
FROM test_unnest,
unnest(mv_to_array(c_mv_num_with_null_and_empty_val)) AS u(c)
WHERE c_long IN (0,
1,
2)
AND (ln(c)+ln(c))<>99999;
-+--------------------+
-| col |
-+--------------------+
-| 0.0 |
-| 0.0 |
-| 0.0 |
-| 1.3862943611198906 |
-| 1.3862943611198906 |
-| 1.3862943611198906 |
-| 2.1972245773362196 |
-| 2.1972245773362196 |
-| 2.1972245773362196 |
-+--------------------+
++---------------+
+| col |
++---------------+
+| 0.0 |
+| 0.0 |
+| 0.0 |
+| 1.3862943611 |
+| 1.3862943611 |
+| 1.3862943611 |
+| 2.19722457732 |
+| 2.19722457732 |
+| 2.19722457732 |
++---------------+
(9 rows)
!ok
@@ -595,26 +595,26 @@ WHERE c_long IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B6_C2
#-------------------------------------------------------------------------
-SELECT ln(c+c) AS col
+SELECT trunc(ln(c+c),11) AS col
FROM test_unnest,
unnest(mv_to_array(c_mv_num_with_null_and_empty_val)) AS u(c)
WHERE c_long IN (0,
1,
2)
AND ln(c+c)<>99999;
-+--------------------+
-| col |
-+--------------------+
-| 0.6931471805599453 |
-| 0.6931471805599453 |
-| 0.6931471805599453 |
-| 1.3862943611198906 |
-| 1.3862943611198906 |
-| 1.3862943611198906 |
-| 1.791759469228055 |
-| 1.791759469228055 |
-| 1.791759469228055 |
-+--------------------+
++---------------+
+| col |
++---------------+
+| 0.69314718055 |
+| 0.69314718055 |
+| 0.69314718055 |
+| 1.38629436111 |
+| 1.38629436111 |
+| 1.38629436111 |
+| 1.79175946922 |
+| 1.79175946922 |
+| 1.79175946922 |
++---------------+
(9 rows)
!ok
@@ -622,7 +622,7 @@ WHERE c_long IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B6_C3
#-------------------------------------------------------------------------
-SELECT ln(c)+ln(c_long) AS col
+SELECT trunc(ln(c),11)+trunc(ln(c_long),11) AS col
FROM test_unnest,
unnest(mv_to_array(c_mv_num_with_null_and_empty_val)) AS u(c)
WHERE c_long IN (0,
@@ -632,15 +632,15 @@ WHERE c_long IN (0,
+--------------------+
| col |
+--------------------+
-| -Infinity |
-| -Infinity |
-| -Infinity |
| 0.0 |
-| 0.6931471805599453 |
-| 0.6931471805599453 |
-| 1.0986122886681098 |
-| 1.3862943611198906 |
-| 1.791759469228055 |
+| -92233719.26993546 |
+| -92233719.67540057 |
+| -92233720.36854775 |
+| 0.69314718055 |
+| 0.69314718055 |
+| 1.09861228866 |
+| 1.3862943611 |
+| 1.79175946921 |
+--------------------+
(9 rows)
@@ -649,26 +649,26 @@ WHERE c_long IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B6_C4
#-------------------------------------------------------------------------
-SELECT ln(c+c_long) AS col
+SELECT trunc(ln(c+c_long),11) AS col
FROM test_unnest,
unnest(mv_to_array(c_mv_num_with_null_and_empty_val)) AS u(c)
WHERE c_long IN (0,
1,
2)
AND ln(c+c_long)<>99999;
-+--------------------+
-| col |
-+--------------------+
-| 0.0 |
-| 0.6931471805599453 |
-| 0.6931471805599453 |
-| 1.0986122886681098 |
-| 1.0986122886681098 |
-| 1.0986122886681098 |
-| 1.3862943611198906 |
-| 1.3862943611198906 |
-| 1.6094379124341003 |
-+--------------------+
++---------------+
+| col |
++---------------+
+| 0.0 |
+| 0.69314718055 |
+| 0.69314718055 |
+| 1.09861228866 |
+| 1.09861228866 |
+| 1.09861228866 |
+| 1.38629436111 |
+| 1.38629436111 |
+| 1.60943791243 |
++---------------+
(9 rows)
!ok
diff --git
a/quidem-ut/src/test/quidem/org.apache.druid.quidem.QTest/qaUnnest/mv_sql_scalar_numeric_funcs.02.all.iq
b/quidem-ut/src/test/quidem/org.apache.druid.quidem.QTest/qaUnnest/mv_sql_scalar_numeric_funcs.02.all.iq
index 4bab5fb3f7d..c90f8879637 100644
---
a/quidem-ut/src/test/quidem/org.apache.druid.quidem.QTest/qaUnnest/mv_sql_scalar_numeric_funcs.02.all.iq
+++
b/quidem-ut/src/test/quidem/org.apache.druid.quidem.QTest/qaUnnest/mv_sql_scalar_numeric_funcs.02.all.iq
@@ -33,26 +33,26 @@ WHERE c_long IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B14_C1
#-------------------------------------------------------------------------
-SELECT sin(c)+sin(c) AS col
+SELECT trunc(sin(c),11)+trunc(sin(c),11) AS col
FROM test_unnest,
unnest(mv_to_array(c_mv_num_with_null_and_empty_val)) AS u(c)
WHERE c_long IN (0,
1,
2)
AND (sin(c)+sin(c))<>99999;
-+--------------------+
-| col |
-+--------------------+
-| 0.2822400161197344 |
-| 0.2822400161197344 |
-| 0.2822400161197344 |
-| 1.682941969615793 |
-| 1.682941969615793 |
-| 1.682941969615793 |
-| 1.8185948536513634 |
-| 1.8185948536513634 |
-| 1.8185948536513634 |
-+--------------------+
++---------------+
+| col |
++---------------+
+| 0.2822400161 |
+| 0.2822400161 |
+| 0.2822400161 |
+| 1.6829419696 |
+| 1.6829419696 |
+| 1.6829419696 |
+| 1.81859485364 |
+| 1.81859485364 |
+| 1.81859485364 |
++---------------+
(9 rows)
!ok
@@ -60,26 +60,26 @@ WHERE c_long IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B14_C2
#-------------------------------------------------------------------------
-SELECT sin(c+c) AS col
+SELECT trunc(sin(c+c),11) AS col
FROM test_unnest,
unnest(mv_to_array(c_mv_num_with_null_and_empty_val)) AS u(c)
WHERE c_long IN (0,
1,
2)
AND sin(c+c)<>99999;
-+----------------------+
-| col |
-+----------------------+
-| -0.27941549819892586 |
-| -0.27941549819892586 |
-| -0.27941549819892586 |
-| -0.7568024953079282 |
-| -0.7568024953079282 |
-| -0.7568024953079282 |
-| 0.9092974268256817 |
-| 0.9092974268256817 |
-| 0.9092974268256817 |
-+----------------------+
++----------------+
+| col |
++----------------+
+| -0.27941549819 |
+| -0.27941549819 |
+| -0.27941549819 |
+| -0.7568024953 |
+| -0.7568024953 |
+| -0.7568024953 |
+| 0.90929742682 |
+| 0.90929742682 |
+| 0.90929742682 |
++----------------+
(9 rows)
!ok
@@ -87,7 +87,7 @@ WHERE c_long IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B14_C3
#-------------------------------------------------------------------------
-SELECT sin(c)+sin(c_long) AS col
+SELECT trunc(sin(c),11)+trunc(sin(c_long),11) AS col
FROM test_unnest,
unnest(mv_to_array(c_mv_num_with_null_and_empty_val)) AS u(c)
WHERE c_long IN (0,
@@ -97,15 +97,15 @@ WHERE c_long IN (0,
+--------------------+
| col |
+--------------------+
-| 0.1411200080598672 |
-| 0.8414709848078965 |
-| 0.9092974268256817 |
-| 0.9825909928677637 |
-| 1.0504174348855488 |
-| 1.682941969615793 |
-| 1.7507684116335782 |
-| 1.7507684116335782 |
-| 1.8185948536513634 |
+| 0.14112000805 |
+| 0.8414709848 |
+| 0.90929742682 |
+| 0.9825909928500001 |
+| 1.05041743487 |
+| 1.6829419696 |
+| 1.7507684116200002 |
+| 1.7507684116200002 |
+| 1.81859485364 |
+--------------------+
(9 rows)
@@ -114,26 +114,26 @@ WHERE c_long IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B14_C4
#-------------------------------------------------------------------------
-SELECT sin(c+c_long) AS col
+SELECT trunc(sin(c+c_long),11) AS col
FROM test_unnest,
unnest(mv_to_array(c_mv_num_with_null_and_empty_val)) AS u(c)
WHERE c_long IN (0,
1,
2)
AND sin(c+c_long)<>99999;
-+---------------------+
-| col |
-+---------------------+
-| -0.7568024953079282 |
-| -0.7568024953079282 |
-| -0.9589242746631385 |
-| 0.1411200080598672 |
-| 0.1411200080598672 |
-| 0.1411200080598672 |
-| 0.8414709848078965 |
-| 0.9092974268256817 |
-| 0.9092974268256817 |
-+---------------------+
++----------------+
+| col |
++----------------+
+| -0.7568024953 |
+| -0.7568024953 |
+| -0.95892427466 |
+| 0.14112000805 |
+| 0.14112000805 |
+| 0.14112000805 |
+| 0.8414709848 |
+| 0.90929742682 |
+| 0.90929742682 |
++----------------+
(9 rows)
!ok
@@ -141,26 +141,26 @@ WHERE c_long IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B15_C1
#-------------------------------------------------------------------------
-SELECT cos(c)+cos(c) AS col
+SELECT trunc(cos(c),11)+trunc(cos(c),11) AS col
FROM test_unnest,
unnest(mv_to_array(c_mv_num_with_null_and_empty_val)) AS u(c)
WHERE c_long IN (0,
1,
2)
AND (cos(c)+cos(c))<>99999;
-+---------------------+
-| col |
-+---------------------+
-| -0.8322936730942848 |
-| -0.8322936730942848 |
-| -0.8322936730942848 |
-| -1.9799849932008908 |
-| -1.9799849932008908 |
-| -1.9799849932008908 |
-| 1.0806046117362795 |
-| 1.0806046117362795 |
-| 1.0806046117362795 |
-+---------------------+
++----------------+
+| col |
++----------------+
+| -0.83229367308 |
+| -0.83229367308 |
+| -0.83229367308 |
+| -1.9799849932 |
+| -1.9799849932 |
+| -1.9799849932 |
+| 1.08060461172 |
+| 1.08060461172 |
+| 1.08060461172 |
++----------------+
(9 rows)
!ok
@@ -168,26 +168,26 @@ WHERE c_long IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B15_C2
#-------------------------------------------------------------------------
-SELECT cos(c+c) AS col
+SELECT trunc(cos(c+c), 11) AS col
FROM test_unnest,
unnest(mv_to_array(c_mv_num_with_null_and_empty_val)) AS u(c)
WHERE c_long IN (0,
1,
2)
AND cos(c+c)<>99999;
-+---------------------+
-| col |
-+---------------------+
-| -0.4161468365471424 |
-| -0.4161468365471424 |
-| -0.4161468365471424 |
-| -0.6536436208636119 |
-| -0.6536436208636119 |
-| -0.6536436208636119 |
-| 0.960170286650366 |
-| 0.960170286650366 |
-| 0.960170286650366 |
-+---------------------+
++----------------+
+| col |
++----------------+
+| -0.41614683654 |
+| -0.41614683654 |
+| -0.41614683654 |
+| -0.65364362086 |
+| -0.65364362086 |
+| -0.65364362086 |
+| 0.96017028665 |
+| 0.96017028665 |
+| 0.96017028665 |
++----------------+
(9 rows)
!ok
@@ -195,7 +195,7 @@ WHERE c_long IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B15_C3
#-------------------------------------------------------------------------
-SELECT cos(c)+cos(c_long) AS col
+SELECT trunc(cos(c),11)+trunc(cos(c_long),11) AS col
FROM test_unnest,
unnest(mv_to_array(c_mv_num_with_null_and_empty_val)) AS u(c)
WHERE c_long IN (0,
@@ -205,15 +205,15 @@ WHERE c_long IN (0,
+----------------------+
| col |
+----------------------+
-| -0.44969019073230565 |
-| -0.8322936730942848 |
-| -1.4061393331475878 |
-| 0.010007503399554585 |
-| 0.12415546932099736 |
-| 0.12415546932099736 |
-| 0.5838531634528576 |
-| 1.0806046117362795 |
-| 1.5403023058681398 |
+| -0.44969019073999994 |
+| -0.83229367308 |
+| -1.40613933314 |
+| 0.010007503400000006 |
+| 0.12415546932000004 |
+| 0.12415546932000004 |
+| 0.5838531634599999 |
+| 1.08060461172 |
+| 1.54030230586 |
+----------------------+
(9 rows)
@@ -222,26 +222,26 @@ WHERE c_long IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B15_C4
#-------------------------------------------------------------------------
-SELECT cos(c+c_long) AS col
+SELECT trunc(cos(c+c_long),11) AS col
FROM test_unnest,
unnest(mv_to_array(c_mv_num_with_null_and_empty_val)) AS u(c)
WHERE c_long IN (0,
1,
2)
AND cos(c+c_long)<>99999;
-+---------------------+
-| col |
-+---------------------+
-| -0.4161468365471424 |
-| -0.4161468365471424 |
-| -0.6536436208636119 |
-| -0.6536436208636119 |
-| -0.9899924966004454 |
-| -0.9899924966004454 |
-| -0.9899924966004454 |
-| 0.28366218546322625 |
-| 0.5403023058681398 |
-+---------------------+
++----------------+
+| col |
++----------------+
+| -0.41614683654 |
+| -0.41614683654 |
+| -0.65364362086 |
+| -0.65364362086 |
+| -0.9899924966 |
+| -0.9899924966 |
+| -0.9899924966 |
+| 0.28366218546 |
+| 0.54030230586 |
++----------------+
(9 rows)
!ok
@@ -249,26 +249,26 @@ WHERE c_long IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B16_C1
#-------------------------------------------------------------------------
-SELECT tan(c)+tan(c) AS col
+SELECT trunc(tan(c),11)+trunc(tan(c),11) AS col
FROM test_unnest,
unnest(mv_to_array(c_mv_num_with_null_and_empty_val)) AS u(c)
WHERE c_long IN (0,
1,
2)
AND (tan(c)+tan(c))<>99999;
-+---------------------+
-| col |
-+---------------------+
-| -0.2850930861485556 |
-| -0.2850930861485556 |
-| -0.2850930861485556 |
-| -4.370079726523038 |
-| -4.370079726523038 |
-| -4.370079726523038 |
-| 3.1148154493098046 |
-| 3.1148154493098046 |
-| 3.1148154493098046 |
-+---------------------+
++----------------+
+| col |
++----------------+
+| -0.28509308614 |
+| -0.28509308614 |
+| -0.28509308614 |
+| -4.37007972652 |
+| -4.37007972652 |
+| -4.37007972652 |
+| 3.1148154493 |
+| 3.1148154493 |
+| 3.1148154493 |
++----------------+
(9 rows)
!ok
@@ -276,26 +276,26 @@ WHERE c_long IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B16_C2
#-------------------------------------------------------------------------
-SELECT tan(c+c) AS col
+SELECT trunc(tan(c+c),11) AS col
FROM test_unnest,
unnest(mv_to_array(c_mv_num_with_null_and_empty_val)) AS u(c)
WHERE c_long IN (0,
1,
2)
AND tan(c+c)<>99999;
-+----------------------+
-| col |
-+----------------------+
-| -0.29100619138474915 |
-| -0.29100619138474915 |
-| -0.29100619138474915 |
-| -2.185039863261519 |
-| -2.185039863261519 |
-| -2.185039863261519 |
-| 1.1578212823495775 |
-| 1.1578212823495775 |
-| 1.1578212823495775 |
-+----------------------+
++----------------+
+| col |
++----------------+
+| -0.29100619138 |
+| -0.29100619138 |
+| -0.29100619138 |
+| -2.18503986326 |
+| -2.18503986326 |
+| -2.18503986326 |
+| 1.15782128234 |
+| 1.15782128234 |
+| 1.15782128234 |
++----------------+
(9 rows)
!ok
@@ -303,7 +303,7 @@ WHERE c_long IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B16_C3
#-------------------------------------------------------------------------
-SELECT tan(c)+tan(c_long) AS col
+SELECT trunc(tan(c),11)+trunc(tan(c_long),11) AS col
FROM test_unnest,
unnest(mv_to_array(c_mv_num_with_null_and_empty_val)) AS u(c)
WHERE c_long IN (0,
@@ -313,15 +313,15 @@ WHERE c_long IN (0,
+---------------------+
| col |
+---------------------+
-| -0.1425465430742778 |
-| -0.6276321386066166 |
-| -0.6276321386066166 |
-| -2.185039863261519 |
-| -2.3275864063357967 |
-| -4.370079726523038 |
-| 1.4148611815806245 |
-| 1.5574077246549023 |
-| 3.1148154493098046 |
+| -0.14254654307 |
+| -0.6276321386100001 |
+| -0.6276321386100001 |
+| -2.18503986326 |
+| -2.32758640633 |
+| -4.37007972652 |
+| 1.41486118158 |
+| 1.55740772465 |
+| 3.1148154493 |
+---------------------+
(9 rows)
@@ -330,26 +330,26 @@ WHERE c_long IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B16_C4
#-------------------------------------------------------------------------
-SELECT tan(c+c_long) AS col
+SELECT trunc(tan(c+c_long),11) AS col
FROM test_unnest,
unnest(mv_to_array(c_mv_num_with_null_and_empty_val)) AS u(c)
WHERE c_long IN (0,
1,
2)
AND tan(c+c_long)<>99999;
-+---------------------+
-| col |
-+---------------------+
-| -0.1425465430742778 |
-| -0.1425465430742778 |
-| -0.1425465430742778 |
-| -2.185039863261519 |
-| -2.185039863261519 |
-| -3.380515006246586 |
-| 1.1578212823495775 |
-| 1.1578212823495775 |
-| 1.5574077246549023 |
-+---------------------+
++----------------+
+| col |
++----------------+
+| -0.14254654307 |
+| -0.14254654307 |
+| -0.14254654307 |
+| -2.18503986326 |
+| -2.18503986326 |
+| -3.38051500624 |
+| 1.15782128234 |
+| 1.15782128234 |
+| 1.55740772465 |
++----------------+
(9 rows)
!ok
@@ -357,26 +357,26 @@ WHERE c_long IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B17_C1
#-------------------------------------------------------------------------
-SELECT cot(c)+cot(c) AS col
+SELECT trunc(cot(c),11)+trunc(cot(c),11) AS col
FROM test_unnest,
unnest(mv_to_array(c_mv_num_with_null_and_empty_val)) AS u(c)
WHERE c_long IN (0,
1,
2)
AND (cot(c)+cot(c))<>99999;
-+---------------------+
-| col |
-+---------------------+
-| -0.9153151087205715 |
-| -0.9153151087205715 |
-| -0.9153151087205715 |
-| -14.030505102869068 |
-| -14.030505102869068 |
-| -14.030505102869068 |
-| 1.2841852318686615 |
-| 1.2841852318686615 |
-| 1.2841852318686615 |
-+---------------------+
++-----------------+
+| col |
++-----------------+
+| -0.91531510872 |
+| -0.91531510872 |
+| -0.91531510872 |
+| -14.03050510286 |
+| -14.03050510286 |
+| -14.03050510286 |
+| 1.28418523186 |
+| 1.28418523186 |
+| 1.28418523186 |
++-----------------+
(9 rows)
!ok
@@ -384,26 +384,26 @@ WHERE c_long IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B17_C2
#-------------------------------------------------------------------------
-SELECT cot(c+c) AS col
+SELECT trunc(cot(c+c),11) AS col
FROM test_unnest,
unnest(mv_to_array(c_mv_num_with_null_and_empty_val)) AS u(c)
WHERE c_long IN (0,
1,
2)
AND cot(c+c)<>99999;
-+----------------------+
-| col |
-+----------------------+
-| -0.45765755436028577 |
-| -0.45765755436028577 |
-| -0.45765755436028577 |
-| -3.436353004180128 |
-| -3.436353004180128 |
-| -3.436353004180128 |
-| 0.8636911544506167 |
-| 0.8636911544506167 |
-| 0.8636911544506167 |
-+----------------------+
++----------------+
+| col |
++----------------+
+| -0.45765755436 |
+| -0.45765755436 |
+| -0.45765755436 |
+| -3.43635300418 |
+| -3.43635300418 |
+| -3.43635300418 |
+| 0.86369115445 |
+| 0.86369115445 |
+| 0.86369115445 |
++----------------+
(9 rows)
!ok
@@ -411,7 +411,7 @@ WHERE c_long IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B17_C3
#-------------------------------------------------------------------------
-SELECT cot(c)+cot(c_long) AS col
+SELECT trunc(cot(c),11)+trunc(cot(c_long),11) AS col
FROM test_unnest,
unnest(mv_to_array(c_mv_num_with_null_and_empty_val)) AS u(c)
WHERE c_long IN (0,
@@ -421,15 +421,15 @@ WHERE c_long IN (0,
+---------------------+
| col |
+---------------------+
-| -0.9153151087205715 |
-| -6.373159935500203 |
-| -7.47291010579482 |
-| 0.184435061574045 |
-| 0.184435061574045 |
-| 1.2841852318686615 |
-| Infinity |
-| Infinity |
-| Infinity |
+| -0.91531510872 |
+| -6.3731599354999995 |
+| -7.47291010579 |
+| 0.18443506157 |
+| 0.18443506157 |
+| 1.28418523186 |
+| 92233713.3532952 |
+| 92233719.91089019 |
+| 92233721.01064037 |
+---------------------+
(9 rows)
@@ -438,26 +438,26 @@ WHERE c_long IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B17_C4
#-------------------------------------------------------------------------
-SELECT cot(c+c_long) AS col
+SELECT trunc(cot(c+c_long),11) AS col
FROM test_unnest,
unnest(mv_to_array(c_mv_num_with_null_and_empty_val)) AS u(c)
WHERE c_long IN (0,
1,
2)
AND cot(c+c_long)<>99999;
-+----------------------+
-| col |
-+----------------------+
-| -0.2958129155327455 |
-| -0.45765755436028577 |
-| -0.45765755436028577 |
-| -7.015252551434534 |
-| -7.015252551434534 |
-| -7.015252551434534 |
-| 0.6420926159343308 |
-| 0.8636911544506167 |
-| 0.8636911544506167 |
-+----------------------+
++----------------+
+| col |
++----------------+
+| -0.29581291553 |
+| -0.45765755436 |
+| -0.45765755436 |
+| -7.01525255143 |
+| -7.01525255143 |
+| -7.01525255143 |
+| 0.64209261593 |
+| 0.86369115445 |
+| 0.86369115445 |
++----------------+
(9 rows)
!ok
@@ -465,26 +465,26 @@ WHERE c_long IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B18_C1
#-------------------------------------------------------------------------
-SELECT asin(c)+asin(c) AS col
+SELECT trunc(asin(c),11)+trunc(asin(c),11) AS col
FROM test_unnest,
unnest(mv_to_array(c_mv_num_with_null_and_empty_val)) AS u(c)
WHERE c_long IN (0,
1,
2)
AND (asin(c)+asin(c))<>99999;
-+-------------------+
-| col |
-+-------------------+
-| 3.141592653589793 |
-| 3.141592653589793 |
-| 3.141592653589793 |
-| NaN |
-| NaN |
-| NaN |
-| NaN |
-| NaN |
-| NaN |
-+-------------------+
++---------------+
+| col |
++---------------+
+| 0.0 |
+| 0.0 |
+| 0.0 |
+| 0.0 |
+| 0.0 |
+| 0.0 |
+| 3.14159265358 |
+| 3.14159265358 |
+| 3.14159265358 |
++---------------+
(9 rows)
!ok
@@ -519,26 +519,26 @@ WHERE c_long IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B18_C3
#-------------------------------------------------------------------------
-SELECT asin(c)+asin(c_long) AS col
+SELECT trunc(asin(c),11)+trunc(asin(c_long),11) AS col
FROM test_unnest,
unnest(mv_to_array(c_mv_num_with_null_and_empty_val)) AS u(c)
WHERE c_long IN (0,
1,
2)
AND (asin(c)+asin(c_long))<>99999;
-+--------------------+
-| col |
-+--------------------+
-| 1.5707963267948966 |
-| 3.141592653589793 |
-| NaN |
-| NaN |
-| NaN |
-| NaN |
-| NaN |
-| NaN |
-| NaN |
-+--------------------+
++---------------+
+| col |
++---------------+
+| 0.0 |
+| 0.0 |
+| 0.0 |
+| 0.0 |
+| 1.57079632679 |
+| 1.57079632679 |
+| 1.57079632679 |
+| 1.57079632679 |
+| 3.14159265358 |
++---------------+
(9 rows)
!ok
@@ -546,26 +546,26 @@ WHERE c_long IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B18_C4
#-------------------------------------------------------------------------
-SELECT asin(c+c_long) AS col
+SELECT trunc(asin(c+c_long),11) AS col
FROM test_unnest,
unnest(mv_to_array(c_mv_num_with_null_and_empty_val)) AS u(c)
WHERE c_long IN (0,
1,
2)
AND asin(c+c_long)<>99999;
-+--------------------+
-| col |
-+--------------------+
-| 1.5707963267948966 |
-| NaN |
-| NaN |
-| NaN |
-| NaN |
-| NaN |
-| NaN |
-| NaN |
-| NaN |
-+--------------------+
++---------------+
+| col |
++---------------+
+| 0.0 |
+| 0.0 |
+| 0.0 |
+| 0.0 |
+| 0.0 |
+| 0.0 |
+| 0.0 |
+| 0.0 |
+| 1.57079632679 |
++---------------+
(9 rows)
!ok
@@ -627,26 +627,26 @@ WHERE c_long IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B19_C3
#-------------------------------------------------------------------------
-SELECT acos(c)+acos(c_long) AS col
+SELECT trunc(acos(c),11)+trunc(acos(c_long),11) AS col
FROM test_unnest,
unnest(mv_to_array(c_mv_num_with_null_and_empty_val)) AS u(c)
WHERE c_long IN (0,
1,
2)
AND (acos(c)+acos(c_long))<>99999;
-+--------------------+
-| col |
-+--------------------+
-| 0.0 |
-| 1.5707963267948966 |
-| NaN |
-| NaN |
-| NaN |
-| NaN |
-| NaN |
-| NaN |
-| NaN |
-+--------------------+
++---------------+
+| col |
++---------------+
+| 0.0 |
+| 0.0 |
+| 0.0 |
+| 0.0 |
+| 0.0 |
+| 0.0 |
+| 1.57079632679 |
+| 1.57079632679 |
+| 1.57079632679 |
++---------------+
(9 rows)
!ok
@@ -681,26 +681,26 @@ WHERE c_long IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B20_C1
#-------------------------------------------------------------------------
-SELECT atan(c)+atan(c) AS col
+SELECT trunc(atan(c),11)+trunc(atan(c),11) AS col
FROM test_unnest,
unnest(mv_to_array(c_mv_num_with_null_and_empty_val)) AS u(c)
WHERE c_long IN (0,
1,
2)
AND (atan(c)+atan(c))<>99999;
-+--------------------+
-| col |
-+--------------------+
-| 1.5707963267948966 |
-| 1.5707963267948966 |
-| 1.5707963267948966 |
-| 2.214297435588181 |
-| 2.214297435588181 |
-| 2.214297435588181 |
-| 2.498091544796509 |
-| 2.498091544796509 |
-| 2.498091544796509 |
-+--------------------+
++---------------+
+| col |
++---------------+
+| 1.57079632678 |
+| 1.57079632678 |
+| 1.57079632678 |
+| 2.21429743558 |
+| 2.21429743558 |
+| 2.21429743558 |
+| 2.49809154478 |
+| 2.49809154478 |
+| 2.49809154478 |
++---------------+
(9 rows)
!ok
@@ -708,26 +708,26 @@ WHERE c_long IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B20_C2
#-------------------------------------------------------------------------
-SELECT atan(c+c) AS col
+SELECT trunc(atan(c+c),11) AS col
FROM test_unnest,
unnest(mv_to_array(c_mv_num_with_null_and_empty_val)) AS u(c)
WHERE c_long IN (0,
1,
2)
AND atan(c+c)<>99999;
-+--------------------+
-| col |
-+--------------------+
-| 1.1071487177940904 |
-| 1.1071487177940904 |
-| 1.1071487177940904 |
-| 1.3258176636680326 |
-| 1.3258176636680326 |
-| 1.3258176636680326 |
-| 1.4056476493802699 |
-| 1.4056476493802699 |
-| 1.4056476493802699 |
-+--------------------+
++---------------+
+| col |
++---------------+
+| 1.10714871779 |
+| 1.10714871779 |
+| 1.10714871779 |
+| 1.32581766366 |
+| 1.32581766366 |
+| 1.32581766366 |
+| 1.40564764938 |
+| 1.40564764938 |
+| 1.40564764938 |
++---------------+
(9 rows)
!ok
@@ -735,7 +735,7 @@ WHERE c_long IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B20_C3
#-------------------------------------------------------------------------
-SELECT atan(c)+atan(c_long) AS col
+SELECT trunc(atan(c),11)+trunc(atan(c_long),11) AS col
FROM test_unnest,
unnest(mv_to_array(c_mv_num_with_null_and_empty_val)) AS u(c)
WHERE c_long IN (0,
@@ -745,15 +745,15 @@ WHERE c_long IN (0,
+--------------------+
| col |
+--------------------+
-| 0.7853981633974483 |
-| 1.1071487177940904 |
-| 1.2490457723982544 |
-| 1.5707963267948966 |
-| 1.8925468811915387 |
-| 1.8925468811915387 |
-| 2.0344439357957027 |
-| 2.214297435588181 |
-| 2.356194490192345 |
+| 0.78539816339 |
+| 1.10714871779 |
+| 1.24904577239 |
+| 1.57079632678 |
+| 1.89254688118 |
+| 1.89254688118 |
+| 2.0344439357799997 |
+| 2.21429743558 |
+| 2.35619449018 |
+--------------------+
(9 rows)
@@ -762,26 +762,26 @@ WHERE c_long IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B20_C4
#-------------------------------------------------------------------------
-SELECT atan(c+c_long) AS col
+SELECT trunc(atan(c+c_long),11) AS col
FROM test_unnest,
unnest(mv_to_array(c_mv_num_with_null_and_empty_val)) AS u(c)
WHERE c_long IN (0,
1,
2)
AND atan(c+c_long)<>99999;
-+--------------------+
-| col |
-+--------------------+
-| 0.7853981633974483 |
-| 1.1071487177940904 |
-| 1.1071487177940904 |
-| 1.2490457723982544 |
-| 1.2490457723982544 |
-| 1.2490457723982544 |
-| 1.3258176636680326 |
-| 1.3258176636680326 |
-| 1.373400766945016 |
-+--------------------+
++---------------+
+| col |
++---------------+
+| 0.78539816339 |
+| 1.10714871779 |
+| 1.10714871779 |
+| 1.24904577239 |
+| 1.24904577239 |
+| 1.24904577239 |
+| 1.32581766366 |
+| 1.32581766366 |
+| 1.37340076694 |
++---------------+
(9 rows)
!ok
@@ -789,26 +789,26 @@ WHERE c_long IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B21_C1
#-------------------------------------------------------------------------
-SELECT atan2(c, 1)+atan2(c, 1) AS col
+SELECT trunc(atan2(c, 1),11)+trunc(atan2(c, 1),11) AS col
FROM test_unnest,
unnest(mv_to_array(c_mv_num_with_null_and_empty_val)) AS u(c)
WHERE c_long IN (0,
1,
2)
AND (atan2(c, 1)+atan2(c, 1))<>99999;
-+--------------------+
-| col |
-+--------------------+
-| 1.5707963267948966 |
-| 1.5707963267948966 |
-| 1.5707963267948966 |
-| 2.214297435588181 |
-| 2.214297435588181 |
-| 2.214297435588181 |
-| 2.498091544796509 |
-| 2.498091544796509 |
-| 2.498091544796509 |
-+--------------------+
++---------------+
+| col |
++---------------+
+| 1.57079632678 |
+| 1.57079632678 |
+| 1.57079632678 |
+| 2.21429743558 |
+| 2.21429743558 |
+| 2.21429743558 |
+| 2.49809154478 |
+| 2.49809154478 |
+| 2.49809154478 |
++---------------+
(9 rows)
!ok
@@ -816,26 +816,26 @@ WHERE c_long IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B21_C2
#-------------------------------------------------------------------------
-SELECT atan2(c, c) AS col
+SELECT trunc(atan2(c, c),11) AS col
FROM test_unnest,
unnest(mv_to_array(c_mv_num_with_null_and_empty_val)) AS u(c)
WHERE c_long IN (0,
1,
2)
AND atan2(c, c)<>99999;
-+--------------------+
-| col |
-+--------------------+
-| 0.7853981633974483 |
-| 0.7853981633974483 |
-| 0.7853981633974483 |
-| 0.7853981633974483 |
-| 0.7853981633974483 |
-| 0.7853981633974483 |
-| 0.7853981633974483 |
-| 0.7853981633974483 |
-| 0.7853981633974483 |
-+--------------------+
++---------------+
+| col |
++---------------+
+| 0.78539816339 |
+| 0.78539816339 |
+| 0.78539816339 |
+| 0.78539816339 |
+| 0.78539816339 |
+| 0.78539816339 |
+| 0.78539816339 |
+| 0.78539816339 |
+| 0.78539816339 |
++---------------+
(9 rows)
!ok
@@ -843,7 +843,7 @@ WHERE c_long IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B21_C3
#-------------------------------------------------------------------------
-SELECT atan2(c, 1)+atan2(c_long, 1) AS col
+SELECT trunc(atan2(c, 1),11)+trunc(atan2(c_long, 1),11) AS col
FROM test_unnest,
unnest(mv_to_array(c_mv_num_with_null_and_empty_val)) AS u(c)
WHERE c_long IN (0,
@@ -853,15 +853,15 @@ WHERE c_long IN (0,
+--------------------+
| col |
+--------------------+
-| 0.7853981633974483 |
-| 1.1071487177940904 |
-| 1.2490457723982544 |
-| 1.5707963267948966 |
-| 1.8925468811915387 |
-| 1.8925468811915387 |
-| 2.0344439357957027 |
-| 2.214297435588181 |
-| 2.356194490192345 |
+| 0.78539816339 |
+| 1.10714871779 |
+| 1.24904577239 |
+| 1.57079632678 |
+| 1.89254688118 |
+| 1.89254688118 |
+| 2.0344439357799997 |
+| 2.21429743558 |
+| 2.35619449018 |
+--------------------+
(9 rows)
@@ -870,26 +870,26 @@ WHERE c_long IN (0,
#-------------------------------------------------------------------------
# TESTCASE: test_scalar_numeric_funcs TEST_ID: A1_B21_C4
#-------------------------------------------------------------------------
-SELECT atan2(c, c_long) AS col
+SELECT trunc(atan2(c, c_long),11) AS col
FROM test_unnest,
unnest(mv_to_array(c_mv_num_with_null_and_empty_val)) AS u(c)
WHERE c_long IN (0,
1,
2)
AND atan2(c, c_long)<>99999;
-+--------------------+
-| col |
-+--------------------+
-| 0.4636476090008061 |
-| 0.7853981633974483 |
-| 0.7853981633974483 |
-| 0.982793723247329 |
-| 1.1071487177940904 |
-| 1.2490457723982544 |
-| 1.5707963267948966 |
-| 1.5707963267948966 |
-| 1.5707963267948966 |
-+--------------------+
++---------------+
+| col |
++---------------+
+| 0.463647609 |
+| 0.78539816339 |
+| 0.78539816339 |
+| 0.98279372324 |
+| 1.10714871779 |
+| 1.24904577239 |
+| 1.57079632679 |
+| 1.57079632679 |
+| 1.57079632679 |
++---------------+
(9 rows)
!ok
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
