Changeset: 7c3a281dde09 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=7c3a281dde09 Added Files: sql/test/BugTracker-2010/Tests/COPY_INTO_with_backslashes.Bug-2748.test sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.test sql/test/BugTracker-2010/Tests/ORDER_BY_over_UNION_EXCEPT_INTERSECT.Bug-2606.test sql/test/BugTracker-2010/Tests/SQLengine_error_on_join.Bug-2580.test sql/test/BugTracker-2010/Tests/TypeException_with_missing_function.Bug-2674.test sql/test/BugTracker-2010/Tests/and_not_broken.Bug-2602.test sql/test/BugTracker-2010/Tests/assert_on_type_mismatch.Bug-2319.test sql/test/BugTracker-2010/Tests/between-crash.Bug-2672.test sql/test/BugTracker-2010/Tests/between-timestamp.Bug-2718.test sql/test/BugTracker-2010/Tests/call_function_without_warning.Bug-2752.test sql/test/BugTracker-2010/Tests/cast-varchar.Bug-2682.test sql/test/BugTracker-2010/Tests/complex_query_crash.Bug-2633.test sql/test/BugTracker-2010/Tests/concat_type_check_problem.Bug-2354.test sql/test/BugTracker-2010/Tests/connectto.Bug-2548.test sql/test/BugTracker-2010/Tests/constants-optimizer.Bug-2317.test sql/test/BugTracker-2010/Tests/copy-into-too-long-string.Bug-2358.test sql/test/BugTracker-2010/Tests/correlated_update_type_mismatch.SF-2947841.test sql/test/BugTracker-2010/Tests/corrupted_values_after_updates.SF-2938065.test sql/test/BugTracker-2010/Tests/count-and-not.Bug-2663.test sql/test/BugTracker-2010/Tests/crash-with-huge-query.Bug-2647.test sql/test/BugTracker-2010/Tests/crash_default_unlocked.Bug-2744.test sql/test/BugTracker-2010/Tests/crash_in_dce.Bug-2651.test sql/test/BugTracker-2010/Tests/crash_on_complex_join_exp.Bug-2353.test sql/test/BugTracker-2010/Tests/crash_on_in_1.Bug-2352.test sql/test/BugTracker-2010/Tests/crash_on_in_2.Bug-2604.test sql/test/BugTracker-2010/Tests/crash_on_where_in.Bug-2333.test sql/test/BugTracker-2010/Tests/crash_with_prepare_statement.Bug-2549.test sql/test/BugTracker-2010/Tests/crashonschema.Bug-2547.test sql/test/BugTracker-2010/Tests/decimal-function.BUG-2624.test sql/test/BugTracker-2010/Tests/decimal_div_whole_nrs.Bug-2579.test sql/test/BugTracker-2010/Tests/delete_insert.Bug-2529.test sql/test/BugTracker-2010/Tests/distinct-order-by-limit.Bug-2691.test sql/test/BugTracker-2010/Tests/duplicate-key.Bug-2667.test sql/test/BugTracker-2010/Tests/embedded_record_seperator.SF-2991400.test sql/test/BugTracker-2010/Tests/error-truncated.Bug-2615.test sql/test/BugTracker-2010/Tests/foreign_key_type_mismatch.Bug-2745.test sql/test/BugTracker-2010/Tests/function_results_NULL.Bug-2626.test sql/test/BugTracker-2010/Tests/group-by_ordered_column.Bug-2564.test sql/test/BugTracker-2010/Tests/heap_combine_crash.SF-2947763.test sql/test/BugTracker-2010/Tests/huge_nr_of_columns.Bug-2609.test sql/test/BugTracker-2010/Tests/in_column_exp.Bug-2561.test sql/test/BugTracker-2010/Tests/in_query_missing_columns.Bug-2652.test sql/test/BugTracker-2010/Tests/in_query_with_constants_fails.Bug-2582.test sql/test/BugTracker-2010/Tests/incomplete-utf8-sequence.Bug-2575.SQL.py sql/test/BugTracker-2010/Tests/insert-into-except.Bug-2569.test sql/test/BugTracker-2010/Tests/join-and-like.Bug-2715.test sql/test/BugTracker-2010/Tests/join_problem.Bug-2694.test sql/test/BugTracker-2010/Tests/keycheck_crash.Bug-2583.test sql/test/BugTracker-2010/Tests/limit_in_prepare.Bug-2552.test sql/test/BugTracker-2010/Tests/mat.slice_on_empty_BATs.SF-2994521.test sql/test/BugTracker-2010/Tests/multiple-common-table-expressions.Bug-2664.test sql/test/BugTracker-2010/Tests/multiple-updates-in-transaction.Bug-2543.test sql/test/BugTracker-2010/Tests/not-in-union-except-union.Bug-2577.test sql/test/BugTracker-2010/Tests/offset_limited_32bit.SF-2950579.test sql/test/BugTracker-2010/Tests/order_by_on_single_row_view.SF-2950453.test sql/test/BugTracker-2010/Tests/orderby-limit.Bug-2634.test sql/test/BugTracker-2010/Tests/predicate_in_select.Bug-2535.test sql/test/BugTracker-2010/Tests/prepare_on_boolean_bug.Bug-2581.test sql/test/BugTracker-2010/Tests/prepare_statements_crash_server.Bug-2599.test sql/test/BugTracker-2010/Tests/prepare_stmt.Bug-2533.Bug-2534.test sql/test/BugTracker-2010/Tests/rank-over-crash.SF-2926454.test sql/test/BugTracker-2010/Tests/reorder.SF-2995671.test sql/test/BugTracker-2010/Tests/second_function_existing_signature.Bug-2611.test sql/test/BugTracker-2010/Tests/select-distinct-limit.Bug-2676.test sql/test/BugTracker-2010/Tests/select-view-key.Bug-2673.test sql/test/BugTracker-2010/Tests/select_from_seq.Bug-2730.test sql/test/BugTracker-2010/Tests/select_star.Bug-2563.test sql/test/BugTracker-2010/Tests/sequence-restart-with-null.Bug-2648.test sql/test/BugTracker-2010/Tests/shift_with_cast.Bug-2638.test sql/test/BugTracker-2010/Tests/slow-query.Bug-2671.test sql/test/BugTracker-2010/Tests/store_function_argument_correctly.Bug-2750.test sql/test/BugTracker-2010/Tests/subselect.Bug-2537.test sql/test/BugTracker-2010/Tests/substring_display_width.Bug-2683.test sql/test/BugTracker-2010/Tests/sum_on_date_crash.Bug-2643.test sql/test/BugTracker-2010/Tests/tableDataLimit.SF-2944504.test sql/test/BugTracker-2010/Tests/times-crash.Bug-2586.test sql/test/BugTracker-2010/Tests/unicode-bom.Bug-2641.test sql/test/BugTracker-2010/Tests/update_statement_in_function_ignored.Bug-2614.test sql/test/BugTracker-2010/Tests/vacuum.test sql/test/BugTracker-2010/Tests/values.Bug-2726.test sql/test/BugTracker-2010/Tests/values_type_cast.Bug-2735.test sql/test/BugTracker-2010/Tests/with-between.Bug-2732.test sql/test/BugTracker-2010/Tests/with_row_number_crash.Bug-2631.test sql/test/BugTracker-2010/Tests/wrong_error_message_dropping_view.Bug-2713.test Removed Files: sql/test/BugTracker-2010/Tests/incomplete-utf8-sequence.Bug-2575.sql Modified Files: sql/test/BugTracker-2010/Tests/All sql/test/BugTracker-2010/Tests/new-readonly-db.Bug-2695.SQL.py sql/test/BugTracker-2010/Tests/operation-successful.Bug-2589.SQL.py Branch: mtest Log Message:
Converted sql/BugTracker-2010/Tests diffs (truncated from 11755 to 300 lines): diff --git a/sql/test/BugTracker-2010/Tests/All b/sql/test/BugTracker-2010/Tests/All --- a/sql/test/BugTracker-2010/Tests/All +++ b/sql/test/BugTracker-2010/Tests/All @@ -37,7 +37,7 @@ ORDER_BY_over_UNION_EXCEPT_INTERSECT.Bug second_function_existing_signature.Bug-2611 update_statement_in_function_ignored.Bug-2614 error-truncated.Bug-2615 -LIMIT_OFFSET_big-endian.Bug-2622 +LIMIT_OFFSET_big-endian.Bug-2622 # Fails because of EXPLAIN and PLAN decimal-function.BUG-2624 function_results_NULL.Bug-2626 with_row_number_crash.Bug-2631 diff --git a/sql/test/BugTracker-2010/Tests/COPY_INTO_with_backslashes.Bug-2748.test b/sql/test/BugTracker-2010/Tests/COPY_INTO_with_backslashes.Bug-2748.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2010/Tests/COPY_INTO_with_backslashes.Bug-2748.test @@ -0,0 +1,14 @@ +statement ok +create table t2748 (x varchar(1)) + +statement ok +copy 1 records into t2748 from stdin + +statement error +\\ +select * from t2748 + +statement ok +drop table t2748 + + diff --git a/sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.test b/sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.test @@ -0,0 +1,220 @@ +statement ok +set optimizer = 'minimal_pipe' + +statement ok +create table oblo (a int) + +statement ok +insert into oblo values (4) + +statement ok +insert into oblo values (3) + +statement ok +insert into oblo values (2) + +statement ok +insert into oblo values (1) + +query T rowsort + PLAN select * from oblo +---- +) [ "oblo"."a" ] +project ( +| table(sys.oblo) [ "oblo"."a" ] COUNT + +query T rowsort + PLAN select * from oblo OFFSET 2 +---- +) [ "oblo"."a" ] +project ( +| ) [ bigint "NULL", bigint "2" ] +| top N ( +| | table(sys.oblo) [ "oblo"."a" ] COUNT + +query T rowsort + PLAN select * from oblo LIMIT 2 +---- +) [ "oblo"."a" ] +project ( +| ) [ bigint "2" ] +| top N ( +| | table(sys.oblo) [ "oblo"."a" ] COUNT + +query T rowsort + PLAN select * from oblo LIMIT 1 OFFSET 2 +---- +) [ "oblo"."a" ] +project ( +| ) [ bigint "1", bigint "2" ] +| top N ( +| | table(sys.oblo) [ "oblo"."a" ] COUNT + +query T rowsort + PLAN select * from oblo LIMIT 2 OFFSET 1 +---- +) [ "oblo"."a" ] +project ( +| ) [ bigint "2", bigint "1" ] +| top N ( +| | table(sys.oblo) [ "oblo"."a" ] COUNT + +query T rowsort + PLAN select * from oblo ORDER BY a +---- +) [ "oblo"."a" ] [ "oblo"."a" ASC ] +project ( +| table(sys.oblo) [ "oblo"."a" ] COUNT + +query T rowsort + PLAN select * from oblo ORDER BY a OFFSET 2 +---- +) [ bigint "NULL", bigint "2" ] +top N ( +| ) [ "oblo"."a" ] [ "oblo"."a" ASC ] +| project ( +| | table(sys.oblo) [ "oblo"."a" ] COUNT + +query T rowsort + PLAN select * from oblo ORDER BY a LIMIT 2 +---- +) [ bigint "2" ] +top N ( +| ) [ "oblo"."a" ] [ "oblo"."a" ASC ] +| project ( +| | table(sys.oblo) [ "oblo"."a" ] COUNT + +query T rowsort + PLAN select * from oblo ORDER BY a LIMIT 2 OFFSET 1 +---- +) [ bigint "2", bigint "1" ] +top N ( +| ) [ "oblo"."a" ] [ "oblo"."a" ASC ] +| project ( +| | table(sys.oblo) [ "oblo"."a" ] COUNT + +query T rowsort + PLAN select * from oblo ORDER BY a LIMIT 1 OFFSET 2 +---- +) [ bigint "1", bigint "2" ] +top N ( +| ) [ "oblo"."a" ] [ "oblo"."a" ASC ] +| project ( +| | table(sys.oblo) [ "oblo"."a" ] COUNT + +query T rowsort +EXPLAIN select * from oblo +---- +26 values hashing to ebcde96c710ce41a3a41e01df44dad83 + +query T rowsort +EXPLAIN select * from oblo OFFSET 2 +---- +32 values hashing to c27a53ca10ccfd0d9bd0589e43640f9e + +query T rowsort +EXPLAIN select * from oblo LIMIT 2 +---- +32 values hashing to 37b78da4384c09dfa3e3f871d7945069 + +query T rowsort +EXPLAIN select * from oblo LIMIT 1 OFFSET 2 +---- +32 values hashing to 63cef56a1a0d902f6e1bec7df8282e34 + +query T rowsort +EXPLAIN select * from oblo LIMIT 2 OFFSET 1 +---- +32 values hashing to b6e71196b356f95f360c63af5f9eecb7 + +query T rowsort +EXPLAIN select * from oblo ORDER BY a +---- +30 values hashing to 358130ac394d5760d2b95cc2e203d111 + +query T rowsort +EXPLAIN select * from oblo ORDER BY a OFFSET 2 +---- +36 values hashing to 1f15a9fa6f4a60b07a0dd1740b12241f + +query T rowsort +EXPLAIN select * from oblo ORDER BY a LIMIT 2 +---- +41 values hashing to e5ef5f97772d2182310e7adc85ca11af + +query T rowsort +EXPLAIN select * from oblo ORDER BY a LIMIT 2 OFFSET 1 +---- +43 values hashing to bdd35ee192377448c950df5dd511365c + +query T rowsort +EXPLAIN select * from oblo ORDER BY a LIMIT 1 OFFSET 2 +---- +43 values hashing to 90b778c279e8652c5422448d85843c85 + +query I rowsort + select * from oblo +---- +1 +2 +3 +4 + +query I rowsort + select * from oblo OFFSET 2 +---- +1 +2 + +query I rowsort + select * from oblo LIMIT 2 +---- +3 +4 + +query I rowsort + select * from oblo LIMIT 1 OFFSET 2 +---- +2 + +query I rowsort + select * from oblo LIMIT 2 OFFSET 1 +---- +2 +3 + +query I rowsort + select * from oblo ORDER BY a +---- +1 +2 +3 +4 + +query I rowsort + select * from oblo ORDER BY a OFFSET 2 +---- +3 +4 + +query I rowsort + select * from oblo ORDER BY a LIMIT 2 +---- +1 +2 + +query I rowsort + select * from oblo ORDER BY a LIMIT 2 OFFSET 1 +---- +2 +3 + +query I rowsort + select * from oblo ORDER BY a LIMIT 1 OFFSET 2 +---- +3 + +statement ok +drop table oblo + + diff --git a/sql/test/BugTracker-2010/Tests/ORDER_BY_over_UNION_EXCEPT_INTERSECT.Bug-2606.test b/sql/test/BugTracker-2010/Tests/ORDER_BY_over_UNION_EXCEPT_INTERSECT.Bug-2606.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2010/Tests/ORDER_BY_over_UNION_EXCEPT_INTERSECT.Bug-2606.test @@ -0,0 +1,237 @@ +statement ok +create table t2606a (a int) + +statement ok +insert into t2606a values (11) + +statement ok +insert into t2606a values (21) + +statement ok +insert into t2606a values (13) + +statement ok +insert into t2606a values (23) + +statement ok +insert into t2606a values (12) + +statement ok +insert into t2606a values (22) + +statement ok +create table t2606b (a int) + +statement ok +insert into t2606b values (21) + +statement ok +insert into t2606b values (31) + +statement ok +insert into t2606b values (23) + +statement ok +insert into t2606b values (33) + +statement ok +insert into t2606b values (22) + _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
