Changeset: bf4055f54eb9 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=bf4055f54eb9 Modified Files: sql/test/BugTracker-2018/Tests/sqlitelogictest-algebra-join-not-in.Bug-6519.sql sql/test/BugTracker-2018/Tests/sqlitelogictest-algebra-join-not-in.Bug-6519.stable.out Branch: Nov2019 Log Message:
Sqlite test queries with wrong results diffs (34 lines): diff --git a/sql/test/BugTracker-2018/Tests/sqlitelogictest-algebra-join-not-in.Bug-6519.sql b/sql/test/BugTracker-2018/Tests/sqlitelogictest-algebra-join-not-in.Bug-6519.sql --- a/sql/test/BugTracker-2018/Tests/sqlitelogictest-algebra-join-not-in.Bug-6519.sql +++ b/sql/test/BugTracker-2018/Tests/sqlitelogictest-algebra-join-not-in.Bug-6519.sql @@ -1,4 +1,7 @@ CREATE TABLE tab2(col0 INTEGER, col1 INTEGER, col2 INTEGER); INSERT INTO tab2 VALUES (64,77,40), (75,67,58), (46,51,23); SELECT * FROM tab2 WHERE col2 NOT IN ( - + col1, col2 * + col1, + - col0 * + + 36, + + col2, 84 * + + col0 ) AND NOT NULL IS NULL; +SELECT DISTINCT CAST ( SUM ( DISTINCT 23 ) * - COUNT ( DISTINCT + - col1 ) AS BIGINT ) FROM tab2 AS cor0 WHERE NOT ( NULL ) IS NULL; --NULL +SELECT ALL + + MIN ( DISTINCT - - 14 ) AS col1, CAST ( - SUM ( DISTINCT 74 ) AS BIGINT ) col0 FROM tab2 AS cor0 +WHERE NULL BETWEEN col0 AND NULL; --NULL, NULL DROP TABLE tab2; diff --git a/sql/test/BugTracker-2018/Tests/sqlitelogictest-algebra-join-not-in.Bug-6519.stable.out b/sql/test/BugTracker-2018/Tests/sqlitelogictest-algebra-join-not-in.Bug-6519.stable.out --- a/sql/test/BugTracker-2018/Tests/sqlitelogictest-algebra-join-not-in.Bug-6519.stable.out +++ b/sql/test/BugTracker-2018/Tests/sqlitelogictest-algebra-join-not-in.Bug-6519.stable.out @@ -31,6 +31,19 @@ stdout of test 'sqlitelogictest-algebra- % col0, col1, col2 # name % int, int, int # type % 1, 1, 1 # length +#SELECT DISTINCT CAST ( SUM ( DISTINCT 23 ) * - COUNT ( DISTINCT + - col1 ) AS BIGINT ) FROM tab2 AS cor0 WHERE NOT ( NULL ) IS NULL; --NULL +% .L4 # table_name +% L4 # name +% bigint # type +% 1 # length +[ NULL ] +#SELECT ALL + + MIN ( DISTINCT - - 14 ) AS col1, CAST ( - SUM ( DISTINCT 74 ) AS BIGINT ) col0 FROM tab2 AS cor0 +#WHERE NULL BETWEEN col0 AND NULL; --NULL, NULL +% .L3, .L6 # table_name +% col1, col0 # name +% tinyint, bigint # type +% 1, 1 # length +[ NULL, NULL ] #DROP TABLE tab2; # 16:19:09 > _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list