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 checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list