MonetDB: Oct2020 - Make test more deterministic

[Pedro Ferreira]

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

Make test more deterministic


diffs (39 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
@@ -293,11 +293,11 @@ create view v21(vc0) as (values (greates
 create view v24(vc0) as (values (0.22)) with check option;
 
 select ((sum(all least(((((0.32)-(0.33))) -(0.43)), -(cast(3 as 
bigint)))))>>(least(cast(26 as bigint),
-cast(-507871984 as bigint)))), round(least(-342, 69), 
((((-33)%(-32)))*(((-32)&(-43))))) from v21
-join v18 on ((scale_down(+ (-290196938), scale_down(v18.vc0, 
null)))>(cast(((0.33)
+cast(-507871984 as bigint)))), 1 from v21
+join v18 on ((scale_down(v18.vc0, null))>(cast(((0.33)
 -(0.222)) as double))) inner join (select distinct 
replace(sql_min(rtrim(r'便竼E*P'),
-"concat"(r'?X', r'沈pJqd')), replace(r'w', r'95', r'580488485'), 
cast(((0.33827385)/(24413.0)) as string)) from v24
-where ((scale_down(v24.vc0, v24.vc0))=(scale_down(v24.vc0, v24.vc0)))) as sub0 
on ((least(342, v18.vc0))<>(round(v21.vc0, 107)))
+"concat"(r'?X', r'沈pJqd')), replace(r'w', r'95', r'580488485'), 
cast(((0.33827385)/(24413.0)) as string)) from v24)
+as sub0 on ((least(342, v18.vc0))<>(1))
 group by greatest(-432, ((24)|(32))), 
least(((((r'RJᦈ4[[h\340\272\246')like(r'9804')))and(not (false))),
 "isauuid"(cast(v18.vc0 as string(979))));
 ROLLBACK;
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
@@ -27,11 +27,12 @@ ERROR = !overflow in calculation 1XOR-92
 CODE  = 22003
 MAPI  = (monetdb) /var/tmp/mtest-346605/.s.monetdb.38453
 QUERY = select ((sum(all least(((((0.32)-(0.33))) -(0.43)), -(cast(3 as 
bigint)))))>>(least(cast(26 as bigint),
-        cast(-507871984 as bigint)))), round(least(-342, 69), 
((((-33)%(-32)))*(((-32)&(-43))))) from v21
-        join v18 on ((scale_down(+ (-290196938), scale_down(v18.vc0, 
null)))>(cast(((0.33)
+        cast(-507871984 as bigint)))), 1 from v21
+        join v18 on ((scale_down(v18.vc0, null))>(cast(((0.33)
         -(0.222)) as double))) inner join (select distinct 
replace(sql_min(rtrim(r'便竼E*P'),
-        "concat"(r'?X', r'沈pJqd')), replace(r'w', r'95', r'580488485'), 
cast(((0.33827385)/(24413.0)) as string)) from v24
-        where ((scale_down(v24.vc0, v24.vc0))=(scale_down(v24.vc0, v24.vc0)))) 
as sub0 on ((least(342, v18.vc0))<>(round(v21.vc0, 107)))
+        "concat"(r'?X', r'沈pJqd')), replace(r'w', r'95', r'580488485'), 
cast(((0.33827385)/(24413.0)) as string)) from v24)
+        as sub0 on ((least(342, v18.vc0))<>(1))
+        group by greatest(-432, ((24)|(32))), 
least(((((r'RJᦈ4[[h\340\272\246')like(r'9804')))and(not (false))),
 ERROR = !Argument 2 to round function cannot be null
 CODE  = 42000
 
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list