Changeset: 2f6ea508fc32 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=2f6ea508fc32
Modified Files:
sql/test/SQLancer/Tests/sqlancer02.sql
sql/test/SQLancer/Tests/sqlancer02.stable.err
sql/test/SQLancer/Tests/sqlancer02.stable.out
Branch: octbugs
Log Message:
Let the query run without error, the previously ambiguous batmmath.log call is
being done and there's no necessity to approve an OS specific error output
diffs (42 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer02.sql
b/sql/test/SQLancer/Tests/sqlancer02.sql
--- a/sql/test/SQLancer/Tests/sqlancer02.sql
+++ b/sql/test/SQLancer/Tests/sqlancer02.sql
@@ -241,5 +241,6 @@ ROLLBACK;
SELECT CASE 1 WHEN 1 THEN 'rr' WHEN ln(-2) THEN 'a' END FROM (values (1),(2))
as t0(c0);
-- rr
-- rr
-SELECT CASE 1 WHEN 3 THEN 'rr' WHEN ln(-2) THEN 'a' END FROM (values (1),(2))
as t0(c0);
- -- error, ln -2 cannot be computed
+SELECT CASE 1 WHEN 3 THEN 'rr' WHEN ln(c0) THEN 'a' END FROM (values
(1.2),(2.3)) as t0(c0);
+ -- NULL
+ -- NULL
diff --git a/sql/test/SQLancer/Tests/sqlancer02.stable.err
b/sql/test/SQLancer/Tests/sqlancer02.stable.err
--- a/sql/test/SQLancer/Tests/sqlancer02.stable.err
+++ b/sql/test/SQLancer/Tests/sqlancer02.stable.err
@@ -26,9 +26,6 @@ MAPI = (monetdb) /var/tmp/mtest-817278/
QUERY = SELECT 1 WHERE scale_up(CAST(0.89767724 AS REAL), 1); --error function
scale_up not available for real,tinyint
ERROR = !types real(24,0) and boolean(1,0) are not equal
CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-713199/.s.monetdb.36377
-QUERY = SELECT CASE 1 WHEN 3 THEN 'rr' WHEN ln(-2) THEN 'a' END FROM (values
(1),(2)) as t0(c0);
-ERROR = !Math exception: Numerical argument out of domain
# 17:04:12 >
# 17:04:12 > "Done."
diff --git a/sql/test/SQLancer/Tests/sqlancer02.stable.out
b/sql/test/SQLancer/Tests/sqlancer02.stable.out
--- a/sql/test/SQLancer/Tests/sqlancer02.stable.out
+++ b/sql/test/SQLancer/Tests/sqlancer02.stable.out
@@ -343,6 +343,13 @@ stdout of test 'sqlancer02` in directory
% 2 # length
[ "rr" ]
[ "rr" ]
+#SELECT CASE 1 WHEN 3 THEN 'rr' WHEN ln(c0) THEN 'a' END FROM (values
(1.2),(2.3)) as t0(c0);
+% .%4 # table_name
+% %4 # name
+% char # type
+% 2 # length
+[ NULL ]
+[ NULL ]
# 17:04:12 >
# 17:04:12 > "Done."
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
