Changeset: 6f3ac2786528 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=6f3ac2786528 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 Modified Files: sql/test/BugTracker-2017/Tests/All Branch: Jul2017 Log Message:
Added tests for bugs 6494, 6495 and 6496 diffs (52 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 @@ -102,3 +102,6 @@ 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 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; _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
