Changeset: 997ff4fa7a7f for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=997ff4fa7a7f Added Files: sql/test/SQLancer/Tests/sqlancer07.stable.err.int128 sql/test/SQLancer/Tests/sqlancer07.stable.out.int128 Modified Files: sql/test/SQLancer/Tests/sqlancer07.stable.err Branch: octbugs Log Message:
Added 128 vs no-128 output diffs (62 lines): diff --git a/sql/test/SQLancer/Tests/sqlancer07.stable.err b/sql/test/SQLancer/Tests/sqlancer07.stable.err --- a/sql/test/SQLancer/Tests/sqlancer07.stable.err +++ b/sql/test/SQLancer/Tests/sqlancer07.stable.err @@ -21,11 +21,11 @@ ERROR = !SELECT: relation name "t0" spec CODE = 42000 MAPI = (monetdb) /var/tmp/mtest-195720/.s.monetdb.38351 QUERY = INSERT INTO t1(c0) VALUES((0.6548429615298178*0.3050008736497528)/(0.5061323979270875)); --error, scale too large -ERROR = !Scale (48) overflows type +ERROR = !Scale (34) overflows type CODE = 42000 MAPI = (monetdb) /var/tmp/mtest-57059/.s.monetdb.30988 QUERY = INSERT INTO t1(c0) VALUES(((((COALESCE(0.6548429615298178, 0.20317629894456002))*(COALESCE(0.3050008736497528, 0.2277902039419617))))/(0.5061323979270875))); --error, scale too large -ERROR = !Scale (49) overflows type +ERROR = !Scale (34) overflows type CODE = 42000 MAPI = (monetdb) /var/tmp/mtest-23025/.s.monetdb.36001 QUERY = SELECT 1 FROM t2, t0 WHERE (SELECT 1 UNION SELECT 2) > 0; @@ -48,10 +48,6 @@ MAPI = (monetdb) /var/tmp/mtest-446274/ QUERY = PREPARE SELECT DISTINCT ?, CAST(CASE least(?, r'weHtU') WHEN ? THEN ? WHEN ? THEN ? WHEN (VALUES (?)) THEN r'G' ELSE ? END AS DATE) WHERE (?) IS NOT NULL LIMIT 519007555986016405; ERROR = !Cannot have a parameter (?) for IS NOT NULL operator CODE = 42000 -MAPI = (monetdb) /var/tmp/mtest-61040/.s.monetdb.35917 -QUERY = SELECT CAST(((24829)+(((0.9767751031140547)*(0.7479400824095245)))) AS DOUBLE) IS NULL; -ERROR = !overflow in conversion to DECIMAL(18,18). -CODE = 22003 # 10:16:14 > # 10:16:14 > "Done." diff --git a/sql/test/SQLancer/Tests/sqlancer07.stable.err b/sql/test/SQLancer/Tests/sqlancer07.stable.err.int128 copy from sql/test/SQLancer/Tests/sqlancer07.stable.err copy to sql/test/SQLancer/Tests/sqlancer07.stable.err.int128 --- a/sql/test/SQLancer/Tests/sqlancer07.stable.err +++ b/sql/test/SQLancer/Tests/sqlancer07.stable.err.int128 @@ -48,10 +48,6 @@ MAPI = (monetdb) /var/tmp/mtest-446274/ QUERY = PREPARE SELECT DISTINCT ?, CAST(CASE least(?, r'weHtU') WHEN ? THEN ? WHEN ? THEN ? WHEN (VALUES (?)) THEN r'G' ELSE ? END AS DATE) WHERE (?) IS NOT NULL LIMIT 519007555986016405; ERROR = !Cannot have a parameter (?) for IS NOT NULL operator CODE = 42000 -MAPI = (monetdb) /var/tmp/mtest-61040/.s.monetdb.35917 -QUERY = SELECT CAST(((24829)+(((0.9767751031140547)*(0.7479400824095245)))) AS DOUBLE) IS NULL; -ERROR = !overflow in conversion to DECIMAL(18,18). -CODE = 22003 # 10:16:14 > # 10:16:14 > "Done." diff --git a/sql/test/SQLancer/Tests/sqlancer07.stable.out b/sql/test/SQLancer/Tests/sqlancer07.stable.out.int128 copy from sql/test/SQLancer/Tests/sqlancer07.stable.out copy to sql/test/SQLancer/Tests/sqlancer07.stable.out.int128 --- a/sql/test/SQLancer/Tests/sqlancer07.stable.out +++ b/sql/test/SQLancer/Tests/sqlancer07.stable.out.int128 @@ -461,6 +461,12 @@ stdout of test 'sqlancer07` in directory % 5 # length [ false ] #ROLLBACK; +#SELECT CAST(((24829)+(((0.9767751031140547)*(0.7479400824095245)))) AS DOUBLE) IS NULL; +% .%3 # table_name +% %3 # name +% boolean # type +% 5 # length +[ false ] # 10:16:14 > # 10:16:14 > "Done." _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
