Changeset: 71b5d1cc9297 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=71b5d1cc9297
Modified Files:
sql/common/sql_types.c
sql/test/SQLancer/Tests/sqlancer04.sql
sql/test/SQLancer/Tests/sqlancer04.stable.out
Branch: default
Log Message:
Making SQLancer happy. Added missing cbrt function in the SQL layer
diffs (48 lines):
diff --git a/sql/common/sql_types.c b/sql/common/sql_types.c
--- a/sql/common/sql_types.c
+++ b/sql/common/sql_types.c
@@ -1677,6 +1677,7 @@ sqltypeinit( sql_allocator *sa)
sql_create_func(sa, "cosh", "mmath", "cosh", FALSE, FALSE,
SCALE_FIX, 0, *t, 1, *t);
sql_create_func(sa, "tanh", "mmath", "tanh", FALSE, FALSE,
SCALE_FIX, 0, *t, 1, *t);
sql_create_func(sa, "sqrt", "mmath", "sqrt", FALSE, FALSE,
SCALE_FIX, 0, *t, 1, *t);
+ sql_create_func(sa, "cbrt", "mmath", "cbrt", FALSE, FALSE,
SCALE_FIX, 0, *t, 1, *t);
sql_create_func(sa, "exp", "mmath", "exp", FALSE, FALSE,
SCALE_FIX, 0, *t, 1, *t);
sql_create_func(sa, "log", "mmath", "log", FALSE, FALSE,
SCALE_FIX, 0, *t, 1, *t);
sql_create_func(sa, "ln", "mmath", "log", FALSE, FALSE,
SCALE_FIX, 0, *t, 1, *t);
diff --git a/sql/test/SQLancer/Tests/sqlancer04.sql
b/sql/test/SQLancer/Tests/sqlancer04.sql
--- a/sql/test/SQLancer/Tests/sqlancer04.sql
+++ b/sql/test/SQLancer/Tests/sqlancer04.sql
@@ -121,6 +121,9 @@ SELECT PROD(ALL 0.14) FROM t0 JOIN t1 ON
THEN (0.2) IN (0.3) END AS BOOLEAN) GROUP BY NOT (FALSE),
COALESCE(((COALESCE(2, 4, 1))<<(COALESCE(5, -6))), ((COALESCE(r'-8', -4,
6))|(COALESCE(-2, 3, 4, 5, -6))));
ROLLBACK;
+select cbrt(x) from (values (1), (8), (27)) as x(x);
+select cbrt(64);
+
START TRANSACTION;
CREATE TABLE "sys"."t0" ("c0" DATE,"c1" DOUBLE NOT NULL,"c2" DATE NOT NULL);
select 1 from t0 natural join (select 4 from t0) as sub0; --error, no columns
of tables 't0' and 'sub0' match
diff --git a/sql/test/SQLancer/Tests/sqlancer04.stable.out
b/sql/test/SQLancer/Tests/sqlancer04.stable.out
--- a/sql/test/SQLancer/Tests/sqlancer04.stable.out
+++ b/sql/test/SQLancer/Tests/sqlancer04.stable.out
@@ -117,6 +117,20 @@ stdout of test 'sqlancer04` in directory
% 24 # length
[ 0.002744 ]
#ROLLBACK;
+#select cbrt(x) from (values (1), (8), (27)) as x(x);
+% .%5 # table_name
+% %5 # name
+% double # type
+% 24 # length
+[ 1 ]
+[ 2 ]
+[ 3 ]
+#select cbrt(64);
+% .%2 # table_name
+% %2 # name
+% double # type
+% 24 # length
+[ 4 ]
# 09:44:50 >
# 09:44:50 > "Done."
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
