MonetDB: Oct2020 - Use smaller decimal to avoid extra outputs

[Pedro Ferreira]

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

Use smaller decimal to avoid extra outputs


diffs (30 lines):

diff --git a/sql/test/SQLancer/Tests/sqlancer10.sql 
b/sql/test/SQLancer/Tests/sqlancer10.sql
--- a/sql/test/SQLancer/Tests/sqlancer10.sql
+++ b/sql/test/SQLancer/Tests/sqlancer10.sql
@@ -54,8 +54,8 @@ ROLLBACK;
 
 START TRANSACTION;
 create view v3(vc0, vc1) as (values (0.67,NULL),(18.50, 3),(0.70, 6));
-create view v7(vc0) as (values (8505133838.114197),(NULL));
-(select v3.vc0 from v3) intersect (select greatest('-1115800120', v7.vc0) from 
v7);
+create view v7(vc0) as (values (85.11),(NULL));
+(select v3.vc0 from v3) intersect (select greatest('-111', v7.vc0) from v7);
 ROLLBACK;
 
 START TRANSACTION;
diff --git a/sql/test/SQLancer/Tests/sqlancer10.stable.err 
b/sql/test/SQLancer/Tests/sqlancer10.stable.err
--- a/sql/test/SQLancer/Tests/sqlancer10.stable.err
+++ b/sql/test/SQLancer/Tests/sqlancer10.stable.err
@@ -5,9 +5,9 @@ stderr of test 'sqlancer10` in directory
 # 13:59:46 >  "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" 
"--host=/var/tmp/mtest-215607" "--port=30526"
 # 13:59:46 >  
 
-MAPI  = (monetdb) /var/tmp/mtest-485092/.s.monetdb.38732
-QUERY = (select v3.vc0 from v3) intersect (select greatest('-1115800120', 
v7.vc0) from v7);
-ERROR = !types char(18,0) and decimal(20,2) are not equal
+MAPI  = (monetdb) /var/tmp/mtest-16501/.s.monetdb.38249
+QUERY = (select v3.vc0 from v3) intersect (select greatest('-111', v7.vc0) 
from v7);
+ERROR = !types char(6,0) and decimal(8,2) are not equal
 CODE  = 42000
 
 # 13:59:46 >  
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list