Changeset: 6037d7a880c8 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=6037d7a880c8 Added Files: sql/test/BugTracker/Tests/BETWEEN_error.SF-1911991.test sql/test/BugTracker/Tests/add_and_drop_the_same_constraint.SF-1850789.test sql/test/BugTracker/Tests/alter-default.SF-1695290.test sql/test/BugTracker/Tests/alter_col_to_set_same_constraint.SF-1850781.test sql/test/BugTracker/Tests/alter_table_add_fkey.SF-1737668.test sql/test/BugTracker/Tests/alter_table_set_not_null.SF-1997030.test sql/test/BugTracker/Tests/ambiguous_join.SF-1580565.test sql/test/BugTracker/Tests/assert_fails_on_algebra_version.SF-2019349.test sql/test/BugTracker/Tests/auto_increment.SF-1834820.test sql/test/BugTracker/Tests/bat_descriptor_problem.SF-1997643.test sql/test/BugTracker/Tests/between_having_problem.SF-1959391.test sql/test/BugTracker/Tests/between_on_strings.SF-2021508.test sql/test/BugTracker/Tests/between_with_column.SF-1959410.test sql/test/BugTracker/Tests/bind_with_cast.SF-1720934.test sql/test/BugTracker/Tests/blob_corner_cases.SF-1613902.test sql/test/BugTracker/Tests/broken_join.SF-1373391.test sql/test/BugTracker/Tests/bug_in_selection.SF-1892413.test sql/test/BugTracker/Tests/cascade_operations_in_different_sessions.SF-1823387_create.test sql/test/BugTracker/Tests/cascade_operations_in_different_sessions.SF-1823387_drop.test sql/test/BugTracker/Tests/case_in_aggr_bug.SF-1506545.test sql/test/BugTracker/Tests/case_with_aggr.SF-1876779.test sql/test/BugTracker/Tests/cast_interval2time.SF-1488247.test sql/test/BugTracker/Tests/coalesce_equal_coalesce.SF-1907905.test sql/test/BugTracker/Tests/convert_dec2varchar.SF-1774312.test sql/test/BugTracker/Tests/convert_dec2varchar_crash.SF-1775550.test sql/test/BugTracker/Tests/copy_decimal.SF-1582957.test sql/test/BugTracker/Tests/copy_into_crash.SF-1993999.test sql/test/BugTracker/Tests/copy_overflow_null_bug.SF-1842550.test sql/test/BugTracker/Tests/count_crash.SF-1918780.test sql/test/BugTracker/Tests/crash_on_cast.SF-1357271.test sql/test/BugTracker/Tests/crash_on_delete.SF-1639108.test sql/test/BugTracker/Tests/crash_on_delete.SF-1651567.test sql/test/BugTracker/Tests/crash_on_fkey_update.SF-1703497.test sql/test/BugTracker/Tests/crash_on_fkey_update2.SF-1703497.test sql/test/BugTracker/Tests/crash_on_insert.SF-1639113.test sql/test/BugTracker/Tests/create_column.SF-1643542.test sql/test/BugTracker/Tests/create_column_name_data.SF-1440214.test sql/test/BugTracker/Tests/create_same_temp_tab_after_its_drop.SF-1850809.test sql/test/BugTracker/Tests/create_table_with_data.SF-1715679.test sql/test/BugTracker/Tests/creation_of_exeception_for_select.SF-1841749.test sql/test/BugTracker/Tests/decimal.SF-1718253.test sql/test/BugTracker/Tests/decimal_prepare.SF-1655818.test sql/test/BugTracker/Tests/decl_sec_tab_in_func_body.SF-1907858.test sql/test/BugTracker/Tests/drop_function.SF-1910396.test sql/test/BugTracker/Tests/drop_sequence_crash.SF-1505973.test sql/test/BugTracker/Tests/drop_sequence_crash_2.SF-1505973.test sql/test/BugTracker/Tests/drop_system_tables.SF-1550768.test sql/test/BugTracker/Tests/full_join_crash.SF-1841754.test sql/test/BugTracker/Tests/groupby_orderby_nonselected.SF-1723863.test sql/test/BugTracker/Tests/groupby_with_alias.SF-1520575.test sql/test/BugTracker/Tests/huge_math_expre.SF-1907048.test sql/test/BugTracker/Tests/insert_date.SF-1838785.test sql/test/BugTracker/Tests/insert_not_exists.SF-1380287.test sql/test/BugTracker/Tests/insert_text_with_repeat.SF-1841759.test sql/test/BugTracker/Tests/insert_values.SF-1578838.test sql/test/BugTracker/Tests/inserting_invalid_timestamp.SF-1363557.test sql/test/BugTracker/Tests/intersect_in_subquery.SF-1339411.test sql/test/BugTracker/Tests/is_not_null_syntax_error.SF-1959456.test sql/test/BugTracker/Tests/join_table_with_floats.SF-1907060.test sql/test/BugTracker/Tests/large_prepare.SF-1363729.test sql/test/BugTracker/Tests/large_prepare_2.SF-1363729.test sql/test/BugTracker/Tests/like_exp.SF-1613949.test sql/test/BugTracker/Tests/like_for_time_values.SF-1715659.test sql/test/BugTracker/Tests/like_join.SF-1684798.test sql/test/BugTracker/Tests/like_perl.SF-1907051.test sql/test/BugTracker/Tests/limit_timestampz.SF-1774217.test sql/test/BugTracker/Tests/limits_of_decimal.SF-1685357.test sql/test/BugTracker/Tests/local_global_temporary_table.SF-1715672.test sql/test/BugTracker/Tests/mapi_connect_errors_vanish.SF-1432134.test sql/test/BugTracker/Tests/ms_round.SF-1907063.test sql/test/BugTracker/Tests/multi-column-constraint.SF-1964587.test sql/test/BugTracker/Tests/multivalue_insert.SF-1509864.test sql/test/BugTracker/Tests/nested_views_algebra_version.SF-1993765.test sql/test/BugTracker/Tests/number_null_first_row.SF-1833286.test sql/test/BugTracker/Tests/order_by_over_table_from_another_function.SF-1959822.test sql/test/BugTracker/Tests/orderby_in_function.SF-1892708.test sql/test/BugTracker/Tests/pkey_in_temp_table.SF-1841727.test sql/test/BugTracker/Tests/prepare_decimal_float.SF-1675795.test sql/test/BugTracker/Tests/proc_insert_into.SF-1958572.test sql/test/BugTracker/Tests/rand_not_executed_for_every_row.SF-1723791.test sql/test/BugTracker/Tests/range_join_any.SF-2041785.test sql/test/BugTracker/Tests/range_predicate.SF-1711242.test sql/test/BugTracker/Tests/range_select.SF-1907006.test sql/test/BugTracker/Tests/rank_over.SF-1691098.test sql/test/BugTracker/Tests/reset_session_vars.SF-1505987.test sql/test/BugTracker/Tests/revoke_role.SF-1691646.test sql/test/BugTracker/Tests/rows_affected.SF-1377180.test sql/test/BugTracker/Tests/savepoint-SF.1898533.test sql/test/BugTracker/Tests/schema_from_declared_table.SF-1983341.test sql/test/BugTracker/Tests/select_crashes_in_the_optimization.SF-1848553.test sql/test/BugTracker/Tests/select_extract.SF-1263796.test sql/test/BugTracker/Tests/select_id_not_in_another_select.SF-1737777.test sql/test/BugTracker/Tests/select_mod.SF-1838813.test sql/test/BugTracker/Tests/select_multiple_not_null_constraints.SF-1926074.test sql/test/BugTracker/Tests/select_with_coalesce.SF-1841734.test sql/test/BugTracker/Tests/sequence_not_stored_1.SF-1509894.test sql/test/BugTracker/Tests/sequence_not_stored_2.SF-1509894.test sql/test/BugTracker/Tests/sequence_not_stored_3.SF-1509894.test sql/test/BugTracker/Tests/set_default_value.SF-1715553.test sql/test/BugTracker/Tests/set_operation_coersions.SF-1543216.test sql/test/BugTracker/Tests/set_session_vars.SF-1505987.test sql/test/BugTracker/Tests/sql_div.SF-1959357.test sql/test/BugTracker/Tests/sql_prepare_prob.SF-1909638.test sql/test/BugTracker/Tests/string2int_conversion.SF-1356068.test sql/test/BugTracker/Tests/subquery_orderby.SF-1688915.test sql/test/BugTracker/Tests/table_dependency_inside_union.SF-1884382.test sql/test/BugTracker/Tests/table_function_column_crash.SF-1913572.test sql/test/BugTracker/Tests/temporary_tables.SF-1715669.test sql/test/BugTracker/Tests/timestamp_default_time.SF-1841191.test sql/test/BugTracker/Tests/union_order.test sql/test/BugTracker/Tests/update_fkey_with_value_not_in_the_pkey.SF-1734143.test sql/test/BugTracker/Tests/update_pkey_bug.SF-1733712.test sql/test/BugTracker/Tests/update_with_correlated_subselect.SF-1284791.test sql/test/BugTracker/Tests/update_with_subselect.SF-1362771.test sql/test/BugTracker/Tests/variable_names.SF-1838816.test sql/test/BugTracker/Tests/variable_stack_crash.SF-1711251-2.test sql/test/BugTracker/Tests/variable_stack_crash.SF-1711251.test sql/test/BugTracker/Tests/variable_stack_crash_drop.SF-1711251.test sql/test/BugTracker/Tests/variable_stack_crash_load.SF-1711251.test sql/test/BugTracker/Tests/variables.SF-1508160.test sql/test/BugTracker/Tests/view_creation_using_func.SF-1714814.test sql/test/BugTracker/Tests/with_only_once.SF-1720293.test sql/test/BugTracker/Tests/with_row_number.SF-1898089.test Removed Files: sql/test/BugTracker/Tests/between_no_columns.SF2102101.stable.err sql/test/BugTracker/Tests/between_no_columns.SF2102101.stable.out Modified Files: sql/test/BugTracker/Tests/with_row_number.SF-1898089.sql Branch: mtest Log Message:
Converting sql/test/BugTracker directory, but many tests still to go diffs (truncated from 38673 to 300 lines): diff --git a/sql/test/BugTracker/Tests/BETWEEN_error.SF-1911991.test b/sql/test/BugTracker/Tests/BETWEEN_error.SF-1911991.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker/Tests/BETWEEN_error.SF-1911991.test @@ -0,0 +1,65 @@ +statement ok +create table t1911991 (id int) + +statement ok +insert into t1911991 values (0) + +statement ok +insert into t1911991 values (1) + +statement ok +insert into t1911991 values (2) + +statement ok +insert into t1911991 values (3) + +statement ok +insert into t1911991 values (4) + +statement ok +insert into t1911991 values (5) + +statement ok +insert into t1911991 values (6) + +statement ok +insert into t1911991 values (7) + +statement ok +insert into t1911991 values (8) + +statement ok +insert into t1911991 values (9) + +query I rowsort +select * from t1911991 +---- +0 +1 +2 +3 +4 +5 +6 +7 +8 +9 + +query I rowsort +select * from t1911991 WHERE (id - 5) BETWEEN 2 AND 7 +---- +7 +8 +9 + +query I rowsort +select * from t1911991 WHERE (4 - id) BETWEEN 2 AND 7 +---- +0 +1 +2 + +statement ok +drop table t1911991 + + diff --git a/sql/test/BugTracker/Tests/add_and_drop_the_same_constraint.SF-1850789.test b/sql/test/BugTracker/Tests/add_and_drop_the_same_constraint.SF-1850789.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker/Tests/add_and_drop_the_same_constraint.SF-1850789.test @@ -0,0 +1,13 @@ +statement ok +create table atacc1 (test int not null) + +statement ok +alter table atacc1 add constraint "atacc1_pkey" primary key (test) + +statement ok +alter table atacc1 drop constraint "atacc1_pkey" + +statement ok +drop table atacc1 + + diff --git a/sql/test/BugTracker/Tests/alter-default.SF-1695290.test b/sql/test/BugTracker/Tests/alter-default.SF-1695290.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker/Tests/alter-default.SF-1695290.test @@ -0,0 +1,13 @@ +statement ok +create table tmp (data numeric default 5) + +statement ok +alter table tmp alter column data drop default + +statement ok +alter table tmp alter column data set default 6 + +statement ok +drop table tmp + + diff --git a/sql/test/BugTracker/Tests/alter_col_to_set_same_constraint.SF-1850781.test b/sql/test/BugTracker/Tests/alter_col_to_set_same_constraint.SF-1850781.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker/Tests/alter_col_to_set_same_constraint.SF-1850781.test @@ -0,0 +1,13 @@ +statement ok +create table atacc1 (test int not null) + +statement error +alter table atacc1 alter bar set not null + +statement ok +alter table atacc1 alter test set not null + +statement ok +drop table atacc1 + + diff --git a/sql/test/BugTracker/Tests/alter_table_add_fkey.SF-1737668.test b/sql/test/BugTracker/Tests/alter_table_add_fkey.SF-1737668.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker/Tests/alter_table_add_fkey.SF-1737668.test @@ -0,0 +1,70 @@ +statement ok +create table t1737668b (id int , name varchar(1024), CONSTRAINT pk_t2_id PRIMARY KEY (id)) + +statement ok +create table t1737668c (age int , address int, CONSTRAINT pk_t3_age PRIMARY KEY (age)) + +statement ok +create table t1737668a (id int , age int) + +statement ok +insert into t1737668a values(1, 10) + +statement ok +insert into t1737668a values(2, 11) + +statement ok +insert into t1737668a values(3, 12) + +statement ok +insert into t1737668a values(4, 13) + +statement ok +insert into t1737668a values(5, 14) + +statement ok +insert into t1737668b values(10, 'monetdb') + +statement ok +insert into t1737668b values(11, 'moetdb') + +statement ok +insert into t1737668b values(12, 'montdb') + +statement ok +insert into t1737668b values(13, 'monetb') + +statement ok +insert into t1737668b values(14, 'metdb') + +statement ok +insert into t1737668c values(1, 101) + +statement ok +insert into t1737668c values(2, 118) + +statement ok +insert into t1737668c values(3, 108) + +statement ok +insert into t1737668c values(4, 18) + +statement ok +insert into t1737668c values(5, 1) + +statement error +alter table t1737668a add constraint fk_t1_id_t2_id FOREIGN key(id) references t1737668b(id) + +statement error +alter table t1737668a add constraint fk_t1_age_t3_age FOREIGN key(age) references t1737668c(age) + +statement ok +drop table t1737668a + +statement ok +drop table t1737668c + +statement ok +drop table t1737668b + + diff --git a/sql/test/BugTracker/Tests/alter_table_set_not_null.SF-1997030.test b/sql/test/BugTracker/Tests/alter_table_set_not_null.SF-1997030.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker/Tests/alter_table_set_not_null.SF-1997030.test @@ -0,0 +1,13 @@ +statement ok +CREATE TABLE foo (i INT) + +statement ok +INSERT INTO foo (i) VALUES (NULL) + +statement error +ALTER TABLE foo ALTER COLUMN i SET NOT NULL + +statement ok +DROP TABLE foo + + diff --git a/sql/test/BugTracker/Tests/ambiguous_join.SF-1580565.test b/sql/test/BugTracker/Tests/ambiguous_join.SF-1580565.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker/Tests/ambiguous_join.SF-1580565.test @@ -0,0 +1,34 @@ +statement ok +create table A (id int) + +statement ok +create table B (id int) + +statement ok +insert into A values(1) + +statement ok +insert into B values(1) + +statement error +select * from B left join B on B.id = B.id + +query II rowsort +select * from B left join B as b2 on B.id = b2.id +---- +1 +1 + +statement error +select * from A, B left join B on B.id = A.id + +statement error +select * from A, B left join B as b2 on B.id = A.id + +statement ok +drop table A + +statement ok +drop table B + + diff --git a/sql/test/BugTracker/Tests/assert_fails_on_algebra_version.SF-2019349.test b/sql/test/BugTracker/Tests/assert_fails_on_algebra_version.SF-2019349.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker/Tests/assert_fails_on_algebra_version.SF-2019349.test @@ -0,0 +1,23 @@ +statement ok +create table prop1 (subj int, obj int) + +statement ok +create table prop2 (subj int, obj int, prop int) + +query TII rowsort +WITH A(subj, obj) as (SELECT * FROM prop1 where obj = 14660332) +SELECT prop, obj, cnt from ( +SELECT 'prop14657240_pso' as prop, B.obj as obj, count(*) as cnt +FROM A, prop2 as B +WHERE A.subj = B.subj +GROUP BY B.obj HAVING count(*) > 1 +) as trip +---- + +statement ok +drop table prop1 + +statement ok +drop table prop2 + + diff --git a/sql/test/BugTracker/Tests/auto_increment.SF-1834820.test b/sql/test/BugTracker/Tests/auto_increment.SF-1834820.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker/Tests/auto_increment.SF-1834820.test @@ -0,0 +1,56 @@ +statement ok +CREATE TABLE testusers ( +id INT NOT NULL AUTO_INCREMENT, +name VARCHAR(40), +fullname VARCHAR(100), +PRIMARY KEY (id) +) + +statement ok +INSERT INTO testusers (id, name, fullname) VALUES (1, 'wendy', 'Wendy +Wones') _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
