Changeset: 7534bdc928e0 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=7534bdc928e0 Modified Files: sql/test/BugTracker-2018/Tests/sqlitelogictest-not-between-wrong.Bug-6569.sql sql/test/BugTracker-2018/Tests/sqlitelogictest-not-between-wrong.Bug-6569.stable.out Branch: Mar2018 Log Message:
Adding a CAST ( AS INTEGER) to the SELECT query such that the output becomes a bigint (instead of hugeint). This prevents the need to create an additional .int128 output file or limiting the testing of these tests to platforms which HAVE_HGE. diffs (25 lines): diff --git a/sql/test/BugTracker-2018/Tests/sqlitelogictest-not-between-wrong.Bug-6569.sql b/sql/test/BugTracker-2018/Tests/sqlitelogictest-not-between-wrong.Bug-6569.sql --- a/sql/test/BugTracker-2018/Tests/sqlitelogictest-not-between-wrong.Bug-6569.sql +++ b/sql/test/BugTracker-2018/Tests/sqlitelogictest-not-between-wrong.Bug-6569.sql @@ -1,4 +1,4 @@ CREATE TABLE tab1(col0 INTEGER, col1 INTEGER, col2 INTEGER); INSERT INTO tab1 VALUES(51,14,96), (85,5,59), (91,47,68); -SELECT ALL + MIN ( ALL + ( + col0 ) ) + - 9 * - ( + COUNT ( * ) ) AS col0 FROM tab1 AS cor0 WHERE NOT ( - col0 + col0 ) BETWEEN ( - 39 ) AND ( - 92 ); +SELECT ALL + MIN ( ALL + ( + col0 ) ) + - 9 * - ( + CAST ( COUNT ( * ) AS INTEGER) ) AS col0 FROM tab1 AS cor0 WHERE NOT ( - col0 + col0 ) BETWEEN ( - 39 ) AND ( - 92 ); DROP TABLE tab1; diff --git a/sql/test/BugTracker-2018/Tests/sqlitelogictest-not-between-wrong.Bug-6569.stable.out b/sql/test/BugTracker-2018/Tests/sqlitelogictest-not-between-wrong.Bug-6569.stable.out --- a/sql/test/BugTracker-2018/Tests/sqlitelogictest-not-between-wrong.Bug-6569.stable.out +++ b/sql/test/BugTracker-2018/Tests/sqlitelogictest-not-between-wrong.Bug-6569.stable.out @@ -27,10 +27,10 @@ Ready. #CREATE TABLE tab1(col0 INTEGER, col1 INTEGER, col2 INTEGER); #INSERT INTO tab1 VALUES(51,14,96), (85,5,59), (91,47,68); [ 3 ] -#SELECT ALL + MIN ( ALL + ( + col0 ) ) + - 9 * - ( + COUNT ( * ) ) AS col0 FROM tab1 AS cor0 WHERE NOT ( - col0 + col0 ) BETWEEN ( - 39 ) AND ( - 92 ); +#SELECT ALL + MIN ( ALL + ( + col0 ) ) + - 9 * - ( + CAST ( COUNT ( * ) AS INTEGER) ) AS col0 FROM tab1 AS cor0 WHERE NOT ( - col0 + col0 ) BETWEEN ( - 39 ) AND ( - 92 ); % sys.L5 # table_name % col0 # name -% hugeint # type +% bigint # type % 2 # length [ 78 ] #DROP TABLE tab1; _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
