Changeset: 320c6f50e770 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=320c6f50e770 Added Files: sql/test/BugTracker-2018/Tests/sqlitelogictest-case-subquery-missing.Bug-6523.sql sql/test/BugTracker-2018/Tests/sqlitelogictest-in-single-column.Bug-6522.sql Modified Files: sql/test/BugTracker-2018/Tests/All Branch: default Log Message:
Merge with Jul2017 diffs (28 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 @@ -7,6 +7,8 @@ insert-null-second-interval-0.Bug-6515 case_with_orderby_limit.Bug-6512 sqlitelogictest-bat-undefined.Bug-6516 sqlitelogictest-overflow-in-conversion.Bug-6517 -sqlitelogictest-count-not-in.Bug-6518 +HAVE_HGE?sqlitelogictest-count-not-in.Bug-6518 sqlitelogictest-algebra-join-not-in.Bug-6519 update-with-correlated-subquery.Bug-6520 +sqlitelogictest-in-single-column.Bug-6522 +sqlitelogictest-case-subquery-missing.Bug-6523 diff --git a/sql/test/BugTracker-2018/Tests/sqlitelogictest-case-subquery-missing.Bug-6523.sql b/sql/test/BugTracker-2018/Tests/sqlitelogictest-case-subquery-missing.Bug-6523.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2018/Tests/sqlitelogictest-case-subquery-missing.Bug-6523.sql @@ -0,0 +1,1 @@ +SELECT CASE WHEN 18 IN ( AVG ( + 12 ) + - + ( - 29 ) + - SUM ( + + 53 ) * - ( 73 ) ) THEN NULL WHEN ( - COUNT ( * ) * - SUM ( DISTINCT 80 ) ) IS NOT NULL THEN 15 END + CASE 27 WHEN - 68 * + CAST ( COALESCE ( 42, + 57 * 20 ) AS INTEGER ) THEN + 11 * 11 + - CASE - 16 + 25 WHEN 37 + 24 THEN 51 + 41 END / 4 END * + 0 AS col1; diff --git a/sql/test/BugTracker-2018/Tests/sqlitelogictest-in-single-column.Bug-6522.sql b/sql/test/BugTracker-2018/Tests/sqlitelogictest-in-single-column.Bug-6522.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2018/Tests/sqlitelogictest-in-single-column.Bug-6522.sql @@ -0,0 +1,4 @@ +CREATE TABLE tab2(col0 INTEGER, col1 INTEGER, col2 INTEGER); +INSERT INTO tab2 VALUES (64,77,40), (75,67,58), (46,51,23); +SELECT ALL * FROM tab2 WHERE + col0 IN ( - 12, col0, - col1, col1 / + col0, col1 ); +DROP TABLE tab2; _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
