Changeset: e156ab0c6065 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=e156ab0c6065 Added Files: sql/test/BugTracker-2018/Tests/sqlitelogictest-in-query.Bug-6545.sql sql/test/BugTracker-2018/Tests/sqlitelogictest-in-with-division.Bug-6546.sql Modified Files: sql/test/BugTracker-2018/Tests/All Branch: Mar2018 Log Message:
Added tests for bugs 6545 and 6546 diffs (37 lines): diff --git a/sql/test/BugTracker-2018/Tests/All b/sql/test/BugTracker-2018/Tests/All --- a/sql/test/BugTracker-2018/Tests/All +++ b/sql/test/BugTracker-2018/Tests/All @@ -13,7 +13,7 @@ update-with-correlated-subquery.Bug-6520 sqlitelogictest-in-single-column.Bug-6522 sqlitelogictest-case-subquery-missing.Bug-6523 sqlitelogictest-group-by-having-in-count.Bug-6524 -aggr-in-case.Bug-6526 +HAVE_HGE?aggr-in-case.Bug-6526 crash-orderby-alias.Bug-6527 sqlitelogictest-in-cast-null.Bug-6529 sqlitelogictest-not-in-wrong-results.Bug-6530 @@ -23,4 +23,5 @@ HAVE_NETCDF?truncate_sys_netcdf_tables.B HAVE_SAMTOOLS?truncate_bam_tables.Bug-6543 truncate_sys_tables.Bug-6543 truncate_empty_table.Bug-6544 - +sqlitelogictest-in-query.Bug-6545 +sqlitelogictest-in-with-division.Bug-6546 diff --git a/sql/test/BugTracker-2018/Tests/sqlitelogictest-in-query.Bug-6545.sql b/sql/test/BugTracker-2018/Tests/sqlitelogictest-in-query.Bug-6545.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2018/Tests/sqlitelogictest-in-query.Bug-6545.sql @@ -0,0 +1,4 @@ +CREATE TABLE tab0(col0 INTEGER, col1 INTEGER, col2 INTEGER); +INSERT INTO tab0 VALUES (97,1,99),(15,81,47),(87,21,10); +SELECT DISTINCT * FROM tab0 AS cor0 WHERE - 60 + ( + - col0 ) IN ( + - CAST ( 35 AS INTEGER ) * + ( - 3 ) * - 91 * + + 87, - col0 * + col2 * 18 ); +DROP TABLE tab0; diff --git a/sql/test/BugTracker-2018/Tests/sqlitelogictest-in-with-division.Bug-6546.sql b/sql/test/BugTracker-2018/Tests/sqlitelogictest-in-with-division.Bug-6546.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2018/Tests/sqlitelogictest-in-with-division.Bug-6546.sql @@ -0,0 +1,4 @@ +CREATE TABLE tab0(col0 INTEGER, col1 INTEGER, col2 INTEGER); +INSERT INTO tab0 VALUES (97,1,99),(15,81,47),(87,21,10); +SELECT * FROM tab0 cor0 WHERE ( col1 ) IN ( + 57, + col1 / - col2 ); +DROP TABLE tab0; _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list