Changeset: 93a9d3a0c6e5 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/93a9d3a0c6e5 Added Files: sql/test/BugTracker-2021/Tests/query-too-complex.Bug-7092.sql sql/test/BugTracker-2021/Tests/query-too-complex.Bug-7092.stable.err sql/test/BugTracker-2021/Tests/query-too-complex.Bug-7092.stable.out Modified Files: sql/test/BugTracker-2021/Tests/All Branch: Oct2020 Log Message:
Added test for Issue #7092 diffs (truncated from 87089 to 300 lines): diff --git a/sql/test/BugTracker-2021/Tests/All b/sql/test/BugTracker-2021/Tests/All --- a/sql/test/BugTracker-2021/Tests/All +++ b/sql/test/BugTracker-2021/Tests/All @@ -1,2 +1,3 @@ update-from-count.Bug-7079 HAVE_PYMONETDB?remote-table-ranges.Bug-7089 +query-too-complex.Bug-7092 diff --git a/sql/test/BugTracker-2021/Tests/query-too-complex.Bug-7092.sql b/sql/test/BugTracker-2021/Tests/query-too-complex.Bug-7092.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2021/Tests/query-too-complex.Bug-7092.sql @@ -0,0 +1,86989 @@ +create table test ( + dkey int, + col1 int, + col2 int, + col3 int, + col4 int, + col5 int, + col6 int, + col7 int +); + +SELECT SUM(test.dkey), test.dkey + FROM test + WHERE ((test.col4 NOT IN (13)) + AND (test.col3 NOT IN (86, 552)) + AND (test.col4 NOT IN (9)) + AND (test.col4 NOT IN (6)) + AND (test.col4 NOT IN (7)) + AND (test.col5 NOT IN (30000)) + AND (test.col2 NOT IN (5)) + AND (((test.col1 = 1) + AND (test.col4 = 20) + AND (test.col2 = 51) + AND (test.col3 = 23) + AND (test.col5 = 56)) + OR ((test.col1 = 1) + AND (test.col4 = 20) + AND (test.col2 = 51) + AND (test.col3 = 23) + AND (test.col5 = 58)) + OR ((test.col1 = 1) + AND (test.col4 = 20) + AND (test.col2 = 51) + AND (test.col3 = 23) + AND (test.col5 = 60)) + OR ((test.col1 = 1) + AND (test.col4 = 20) + AND (test.col2 = 51) + AND (test.col3 = 23) + AND (test.col5 = 2307)) + OR ((test.col1 = 1) + AND (test.col4 = 20) + AND (test.col2 = 51) + AND (test.col3 = 23) + AND (test.col5 = 2305) + AND (test.col6 = 3283960)) + OR ((test.col1 = 1) + AND (test.col4 = 20) + AND (test.col2 = 51) + AND (test.col3 = 23) + AND (test.col5 = 2305) + AND (test.col6 = 6134135)) + OR ((test.col1 = 1) + AND (test.col4 = 20) + AND (test.col2 = 51) + AND (test.col3 = 23) + AND (test.col5 = 2305) + AND (test.col6 = 3294265)) + OR ((test.col1 = 1) + AND (test.col4 = 20) + AND (test.col2 = 51) + AND (test.col3 = 23) + AND (test.col5 = 2305) + AND (test.col6 = 6146546)) + OR ((test.col1 = 1) + AND (test.col4 = 20) + AND (test.col2 = 51) + AND (test.col3 = 23) + AND (test.col5 = 2305) + AND (test.col6 = 3311810)) + OR ((test.col1 = 1) + AND (test.col4 = 20) + AND (test.col2 = 51) + AND (test.col3 = 23) + AND (test.col5 = 2305) + AND (test.col6 = 6150213)) + OR ((test.col1 = 1) + AND (test.col4 = 20) + AND (test.col2 = 51) + AND (test.col3 = 23) + AND (test.col5 = 2305) + AND (test.col6 = 3311816)) + OR ((test.col1 = 1) + AND (test.col4 = 20) + AND (test.col2 = 51) + AND (test.col3 = 23) + AND (test.col5 = 2305) + AND (test.col6 = 3311817)) + OR ((test.col1 = 1) + AND (test.col4 = 20) + AND (test.col2 = 51) + AND (test.col3 = 23) + AND (test.col5 = 2305) + AND (test.col6 = 6150223)) + OR ((test.col1 = 1) + AND (test.col4 = 20) + AND (test.col2 = 51) + AND (test.col3 = 23) + AND (test.col5 = 2305) + AND (test.col6 = 6150225)) + OR ((test.col1 = 1) + AND (test.col4 = 20) + AND (test.col2 = 51) + AND (test.col3 = 23) + AND (test.col5 = 2305) + AND (test.col6 = 6150226)) + OR ((test.col1 = 1) + AND (test.col4 = 20) + AND (test.col2 = 51) + AND (test.col3 = 23) + AND (test.col5 = 2305) + AND (test.col6 = 3311824)) + OR ((test.col1 = 1) + AND (test.col4 = 20) + AND (test.col2 = 51) + AND (test.col3 = 23) + AND (test.col5 = 2305) + AND (test.col6 = 3311854)) + OR ((test.col1 = 1) + AND (test.col4 = 20) + AND (test.col2 = 51) + AND (test.col3 = 23) + AND (test.col5 = 2305) + AND (test.col6 = 6150260)) + OR ((test.col1 = 1) + AND (test.col4 = 20) + AND (test.col2 = 51) + AND (test.col3 = 23) + AND (test.col5 = 2305) + AND (test.col6 = 6150261)) + OR ((test.col1 = 1) + AND (test.col4 = 20) + AND (test.col2 = 51) + AND (test.col3 = 23) + AND (test.col5 = 2305) + AND (test.col6 = 3311865)) + OR ((test.col1 = 1) + AND (test.col4 = 20) + AND (test.col2 = 51) + AND (test.col3 = 23) + AND (test.col5 = 2305) + AND (test.col6 = 6150273)) + OR ((test.col1 = 1) + AND (test.col4 = 20) + AND (test.col2 = 51) + AND (test.col3 = 23) + AND (test.col5 = 2305) + AND (test.col6 = 3311879)) + OR ((test.col1 = 1) + AND (test.col4 = 20) + AND (test.col2 = 51) + AND (test.col3 = 23) + AND (test.col5 = 2305) + AND (test.col6 = 6150277)) + OR ((test.col1 = 1) + AND (test.col4 = 20) + AND (test.col2 = 51) + AND (test.col3 = 23) + AND (test.col5 = 2305) + AND (test.col6 = 6630936)) + OR ((test.col1 = 1) + AND (test.col4 = 20) + AND (test.col2 = 51) + AND (test.col3 = 23) + AND (test.col5 = 2305) + AND (test.col6 = 3311902)) + OR ((test.col1 = 1) + AND (test.col4 = 20) + AND (test.col2 = 51) + AND (test.col3 = 23) + AND (test.col5 = 2305) + AND (test.col6 = 7080675)) + OR ((test.col1 = 1) + AND (test.col4 = 20) + AND (test.col2 = 51) + AND (test.col3 = 23) + AND (test.col5 = 2305) + AND (test.col6 = 3419120)) + OR ((test.col1 = 1) + AND (test.col4 = 20) + AND (test.col2 = 51) + AND (test.col3 = 23) + AND (test.col5 = 2305) + AND (test.col6 = 6262519)) + OR ((test.col1 = 1) + AND (test.col4 = 20) + AND (test.col2 = 51) + AND (test.col3 = 23) + AND (test.col5 = 2305) + AND (test.col6 = 3459568)) + OR ((test.col1 = 1) + AND (test.col4 = 20) + AND (test.col2 = 51) + AND (test.col3 = 23) + AND (test.col5 = 2305) + AND (test.col6 = 6371749)) + OR ((test.col1 = 1) + AND (test.col4 = 20) + AND (test.col2 = 51) + AND (test.col3 = 23) + AND (test.col5 = 2305) + AND (test.col6 = 3639097)) + OR ((test.col1 = 1) + AND (test.col4 = 20) + AND (test.col2 = 51) + AND (test.col3 = 23) + AND (test.col5 = 2305) + AND (test.col6 = 6386829)) + OR ((test.col1 = 1) + AND (test.col4 = 20) + AND (test.col2 = 51) + AND (test.col3 = 23) + AND (test.col5 = 2305) + AND (test.col6 = 6397207)) + OR ((test.col1 = 1) + AND (test.col4 = 20) + AND (test.col2 = 51) + AND (test.col3 = 23) + AND (test.col5 = 2305) + AND (test.col6 = 3639361)) + OR ((test.col1 = 1) + AND (test.col4 = 20) + AND (test.col2 = 51) + AND (test.col3 = 23) + AND (test.col5 = 2305) + AND (test.col6 = 6397208)) + OR ((test.col1 = 1) + AND (test.col4 = 20) + AND (test.col2 = 51) + AND (test.col3 = 23) + AND (test.col5 = 2305) + AND (test.col6 = 3639362)) + OR ((test.col1 = 1) + AND (test.col4 = 20) + AND (test.col2 = 51) + AND (test.col3 = 23) + AND (test.col5 = 2305) + AND (test.col6 = 3639364)) + OR ((test.col1 = 1) + AND (test.col4 = 20) + AND (test.col2 = 51) + AND (test.col3 = 23) + AND (test.col5 = 2305) + AND (test.col6 = 3639368)) + OR ((test.col1 = 1) + AND (test.col4 = 20) + AND (test.col2 = 51) + AND (test.col3 = 23) + AND (test.col5 = 2305) + AND (test.col6 = 6397219)) + OR ((test.col1 = 1) + AND (test.col4 = 20) + AND (test.col2 = 51) + AND (test.col3 = 23) + AND (test.col5 = 2305) + AND (test.col6 = 6397220)) + OR ((test.col1 = 1) + AND (test.col4 = 20) + AND (test.col2 = 51) + AND (test.col3 = 23) + AND (test.col5 = 2305) + AND (test.col6 = 6407800)) + OR ((test.col1 = 1) + AND (test.col4 = 20) + AND (test.col2 = 51) + AND (test.col3 = 23) + AND (test.col5 = 2305) + AND (test.col6 = 3681400)) + OR ((test.col1 = 1) + AND (test.col4 = 20) + AND (test.col2 = 51) + AND (test.col3 = 23) + AND (test.col5 = 2305) + AND (test.col6 = 6407804)) + OR ((test.col1 = 1) + AND (test.col4 = 20) + AND (test.col2 = 51) + AND (test.col3 = 23) + AND (test.col5 = 2305) + AND (test.col6 = 6407805)) + OR ((test.col1 = 1) + AND (test.col4 = 20) + AND (test.col2 = 51) + AND (test.col3 = 23) + AND (test.col5 = 2305) + AND (test.col6 = 3681402)) + OR ((test.col1 = 1) + AND (test.col4 = 20) _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
