Changeset: 647d3a00d442 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/647d3a00d442 Added Files: sql/test/BugTracker-2021/Tests/query-too-complex.Bug-7092.test Removed 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 Branch: default Log Message:
converted the test diffs (truncated from 174079 to 300 lines): 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 deleted file mode 100644 --- a/sql/test/BugTracker-2021/Tests/query-too-complex.Bug-7092.sql +++ /dev/null @@ -1,86989 +0,0 @@ -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) - AND (test.col2 = 51) - AND (test.col3 = 23) - AND (test.col5 = 2305) - AND (test.col6 = 3681404)) - OR ((test.col1 = 1) - AND (test.col4 = 20) - AND (test.col2 = 51) _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
