MonetDB: Oct2020 - Reduce number sizes to eliminate overflow on ...

[Pedro Ferreira]

Changeset: 32e69e55a371 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=32e69e55a371
Modified Files:
        sql/test/SQLancer/Tests/sqlancer09.sql
        sql/test/SQLancer/Tests/sqlancer09.stable.err
Branch: Oct2020
Log Message:

Reduce number sizes to eliminate overflow on no-int128 platforms


diffs (37 lines):

diff --git a/sql/test/SQLancer/Tests/sqlancer09.sql 
b/sql/test/SQLancer/Tests/sqlancer09.sql
--- a/sql/test/SQLancer/Tests/sqlancer09.sql
+++ b/sql/test/SQLancer/Tests/sqlancer09.sql
@@ -348,8 +348,7 @@ 0.24326971  0.329
 10098  0.846
 
 ALTER TABLE t2 ADD CONSTRAINT "t2_c0_c1_fkey" FOREIGN KEY ("c0", "c1") 
REFERENCES "sys"."t2" ("c0", "c1");
-update t2 set c1 = 0.012427403386733981704992402228526771068572998046875 where 
(((t2.c0)%(t2.c1))) between symmetric 
-(coalesce(-1053775800, 991217471)) and (((0.6974006550632457)+(1832026960)));
+update t2 set c1 = 0.012 where (((t2.c0)%(t2.c1))) between symmetric 
(coalesce(-1053, 991)) and (((0.6974)+(183)));
 ROLLBACK;
 
 START TRANSACTION;
@@ -407,7 +406,7 @@ create or replace view v0(vc0, vc1, vc2)
 create or replace view v1(vc0, vc1) as (select 0.80, 'a');
 
 select 1 from v0, v1
-inner join (values (88), (3), (59)) as sub0 on true natural join 
+inner join (values (88), (3), (59)) as sub0 on true natural join
 (select distinct v0.vc0 from v1, v0 group by v0.vc1) as sub1
 where v0.vc0 = 0.06683239;
 
diff --git a/sql/test/SQLancer/Tests/sqlancer09.stable.err 
b/sql/test/SQLancer/Tests/sqlancer09.stable.err
--- a/sql/test/SQLancer/Tests/sqlancer09.stable.err
+++ b/sql/test/SQLancer/Tests/sqlancer09.stable.err
@@ -43,9 +43,8 @@ MAPI  = (monetdb) /var/tmp/mtest-164664/
 QUERY = values (round(-1.4999792343698102e+308, 15)),(1.2); --error, overflow?
 ERROR = !Overflow in round
 CODE  = 22003
-MAPI  = (monetdb) /var/tmp/mtest-24399/.s.monetdb.36745
-QUERY = update t2 set c1 = 
0.012427403386733981704992402228526771068572998046875 where (((t2.c0)%(t2.c1))) 
between symmetric 
-        (coalesce(-1053775800, 991217471)) and 
(((0.6974006550632457)+(1832026960)));
+MAPI  = (monetdb) /var/tmp/mtest-101740/.s.monetdb.35349
+QUERY = update t2 set c1 = 0.012 where (((t2.c0)%(t2.c1))) between symmetric 
(coalesce(-1053, 991)) and (((0.6974)+(183)));
 ERROR = !division by zero.
 CODE  = 22012
 MAPI  = (monetdb) /var/tmp/mtest-125379/.s.monetdb.32501
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list