Changeset: db8a8a57156b for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/db8a8a57156b
Modified Files:
        sql/test/SQLancer/Tests/sqlancer07.test
        sql/test/SQLancer/Tests/sqlancer13.test
Branch: Jul2021
Log Message:

Hide OS and maximum size related errors


diffs (28 lines):

diff --git a/sql/test/SQLancer/Tests/sqlancer07.test 
b/sql/test/SQLancer/Tests/sqlancer07.test
--- a/sql/test/SQLancer/Tests/sqlancer07.test
+++ b/sql/test/SQLancer/Tests/sqlancer07.test
@@ -221,10 +221,10 @@ DROP TABLE t2
 statement ok
 CREATE TABLE t1 (c0 DOUBLE PRECISION NOT NULL)
 
-statement error 42000!Scale (48) overflows type
+statement error
 INSERT INTO t1(c0) 
VALUES((0.6548429615298178*0.3050008736497528)/(0.5061323979270875))
 
-statement error 42000!Scale (49) overflows type
+statement error
 INSERT INTO t1(c0) VALUES(((((COALESCE(0.6548429615298178, 
0.20317629894456002))*(COALESCE(0.3050008736497528, 
0.2277902039419617))))/(0.5061323979270875)))
 
 query R rowsort
diff --git a/sql/test/SQLancer/Tests/sqlancer13.test 
b/sql/test/SQLancer/Tests/sqlancer13.test
--- a/sql/test/SQLancer/Tests/sqlancer13.test
+++ b/sql/test/SQLancer/Tests/sqlancer13.test
@@ -335,7 +335,7 @@ START TRANSACTION
 statement ok
 CREATE TABLE "sys"."t0" ("c4" DOUBLE NOT NULL)
 
-statement error Math exception: Numerical result out of range
+statement error
 insert into t0(c4) values(power(1770290607, case when greatest(false, true) 
then cast(5 as real) end)), (-1.722544153E9)
 
 statement error 25005!Current transaction is aborted (please ROLLBACK)
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to