Changeset: 0f2cea81af8d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=0f2cea81af8d Added Files: sql/test/BugTracker-2017/Tests/sqlitelogictest-algebra-operators.Bug-6494.sql sql/test/BugTracker-2017/Tests/sqlitelogictest-comparisons-between-floating-points-and-NULL.Bug-6496.sql sql/test/BugTracker-2017/Tests/sqlitelogictest-hidden-alias.Bug-6495.sql sql/test/BugTracker-2017/Tests/sqlitelogictest-min-distinct-empty-table.Bug-6493.sql sql/test/BugTracker-2017/Tests/sqlitelogictest-not-between.Bug-6497.sql Modified Files: gdk/gdk_system.c sql/test/BugTracker-2017/Tests/All Branch: default Log Message:
Merged with Jul2017 branch. diffs (73 lines): diff --git a/sql/test/BugTracker-2017/Tests/All b/sql/test/BugTracker-2017/Tests/All --- a/sql/test/BugTracker-2017/Tests/All +++ b/sql/test/BugTracker-2017/Tests/All @@ -115,3 +115,8 @@ crash-in-topn.Bug-6478 function-resolution.Bug-6436 generate-resolution.Bug-6471 sqlitelogictest-select-in-column.Bug-6490 +sqlitelogictest-min-distinct-empty-table.Bug-6493 +sqlitelogictest-algebra-operators.Bug-6494 +sqlitelogictest-hidden-alias.Bug-6495 +sqlitelogictest-comparisons-between-floating-points-and-NULL.Bug-6496.sql +sqlitelogictest-not-between.Bug-6497 diff --git a/sql/test/BugTracker-2017/Tests/sqlitelogictest-algebra-operators.Bug-6494.sql b/sql/test/BugTracker-2017/Tests/sqlitelogictest-algebra-operators.Bug-6494.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2017/Tests/sqlitelogictest-algebra-operators.Bug-6494.sql @@ -0,0 +1,1 @@ +SELECT 85 * + 52 * 50 * ( + + 82 ) + - 78; diff --git a/sql/test/BugTracker-2017/Tests/sqlitelogictest-comparisons-between-floating-points-and-NULL.Bug-6496.sql b/sql/test/BugTracker-2017/Tests/sqlitelogictest-comparisons-between-floating-points-and-NULL.Bug-6496.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2017/Tests/sqlitelogictest-comparisons-between-floating-points-and-NULL.Bug-6496.sql @@ -0,0 +1,20 @@ +CREATE TABLE tab0(pk INTEGER PRIMARY KEY, col0 INTEGER, col1 FLOAT, col2 TEXT, col3 INTEGER, col4 FLOAT, col5 TEXT); +INSERT INTO tab0 VALUES(0,698,169.42,'apdbu',431,316.15,'sqvis'); +INSERT INTO tab0 VALUES(1,538,676.36,'fuqeu',514,685.97,'bgwrq'); +INSERT INTO tab0 VALUES(2,90,205.26,'yrrzx',123,836.88,'kpuhc'); +INSERT INTO tab0 VALUES(3,620,864.8,'myrdv',877,820.98,'oxkuv'); +INSERT INTO tab0 VALUES(4,754,677.3,'iofrg',67,665.49,'bzqba'); +INSERT INTO tab0 VALUES(5,107,710.19,'lhfro',286,504.28,'kwwsg'); +INSERT INTO tab0 VALUES(6,904,193.16,'eozui',48,698.55,'ejyzs'); +INSERT INTO tab0 VALUES(7,606,650.64,'ovmce',417,962.43,'dvkbh'); +INSERT INTO tab0 VALUES(8,535,18.11,'ijika',630,489.63,'hpnyu'); +INSERT INTO tab0 VALUES(9,501,776.40,'cvygg',725,75.5,'etlyv'); +SELECT + - COUNT ( * ) FROM tab0 AS cor0 WHERE NOT ( - col0 ) BETWEEN - + col4 AND NULL; --should be -5 +DROP TABLE tab0; + +CREATE TABLE tab1(col0 INTEGER, col1 INTEGER, col2 INTEGER); +INSERT INTO tab1 VALUES(51,14,96); +INSERT INTO tab1 VALUES(85,5,59); +INSERT INTO tab1 VALUES(91,47,68); +SELECT ALL + COUNT ( DISTINCT 64 ) FROM tab1 AS cor0 WHERE col2 + 5 > NULL; --should be 0 +DROP TABLE tab1; diff --git a/sql/test/BugTracker-2017/Tests/sqlitelogictest-hidden-alias.Bug-6495.sql b/sql/test/BugTracker-2017/Tests/sqlitelogictest-hidden-alias.Bug-6495.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2017/Tests/sqlitelogictest-hidden-alias.Bug-6495.sql @@ -0,0 +1,6 @@ +CREATE TABLE tab0(pk INTEGER PRIMARY KEY, col0 INTEGER, col1 FLOAT, col2 TEXT, col3 INTEGER, col4 FLOAT, col5 TEXT); +SELECT - col4 col0 FROM tab0 WHERE NOT NULL IS NULL; +SELECT - ( + 13 ) col0 FROM tab0 WHERE NOT NULL IS NULL; +SELECT + col3 * 82 col3 FROM tab0 AS cor0 WHERE NULL IS NULL; +SELECT DISTINCT + MAX ( DISTINCT - col1 ) col2 FROM tab0 WHERE - col3 + + 72 IS NULL; +DROP TABLE tab0; diff --git a/sql/test/BugTracker-2017/Tests/sqlitelogictest-min-distinct-empty-table.Bug-6493.sql b/sql/test/BugTracker-2017/Tests/sqlitelogictest-min-distinct-empty-table.Bug-6493.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2017/Tests/sqlitelogictest-min-distinct-empty-table.Bug-6493.sql @@ -0,0 +1,3 @@ +CREATE TABLE tab0(pk INTEGER PRIMARY KEY, col0 INTEGER, col1 FLOAT, col2 TEXT, col3 INTEGER, col4 FLOAT, col5 TEXT); +SELECT - MIN ( DISTINCT + 79 ) FROM tab0 AS cor0 WHERE NOT + col4 IS NOT NULL; +DROP TABLE tab0; diff --git a/sql/test/BugTracker-2017/Tests/sqlitelogictest-not-between.Bug-6497.sql b/sql/test/BugTracker-2017/Tests/sqlitelogictest-not-between.Bug-6497.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2017/Tests/sqlitelogictest-not-between.Bug-6497.sql @@ -0,0 +1,6 @@ +CREATE TABLE tab0(col0 INTEGER, col1 INTEGER, col2 INTEGER); +INSERT INTO tab0 VALUES(97,1,99); +INSERT INTO tab0 VALUES(15,81,47); +INSERT INTO tab0 VALUES(87,21,10); +SELECT * FROM tab0 WHERE + col1 NOT BETWEEN col2 + - 99 AND + 20; +DROP TABLE tab0; _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
