Changeset: 20b14a441553 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/20b14a441553 Modified Files: gdk/gdk_bbp.c Branch: default Log Message:
Merge with Sep2022 branch. diffs (truncated from 373 to 300 lines): diff --git a/sql/test/BugTracker-2022/Tests/All b/sql/test/BugTracker-2022/Tests/All --- a/sql/test/BugTracker-2022/Tests/All +++ b/sql/test/BugTracker-2022/Tests/All @@ -18,3 +18,6 @@ dependencies.Bug-7328 multi-column-filters-k2-unique.Bug-7303 multi-column-filters-k2-is-1.Bug-7303 values.Bug-7336 +temp-table-index.Bug +rerun-temp-table-index-crashes-server.Bug +rerun-temp-table-index-fails-to-restart-server.Bug diff --git a/sql/test/BugTracker-2022/Tests/rerun-temp-table-index-crashes-server.Bug.test b/sql/test/BugTracker-2022/Tests/rerun-temp-table-index-crashes-server.Bug.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2022/Tests/rerun-temp-table-index-crashes-server.Bug.test @@ -0,0 +1,116 @@ +statement ok +CREATE LOCAL TEMP TABLE tmp.tmp_pk_uc (id1 INT NOT NULL PRIMARY KEY, name1 VARCHAR(99) UNIQUE) + +statement ok +CREATE LOCAL TEMP TABLE tmp.tmp_nopk_twoucs (id2 INT NOT NULL UNIQUE, name2 VARCHAR(99) UNIQUE) + +statement ok +CREATE GLOBAL TEMP TABLE tmp.glbl_pk_uc (id1 INT NOT NULL PRIMARY KEY, name1 VARCHAR(99) UNIQUE) + +statement ok +CREATE GLOBAL TEMP TABLE tmp.glbl_nopk_twoucs (id2 INT NOT NULL UNIQUE, name2 VARCHAR(99) UNIQUE) + +query T rowsort +SELECT name FROM sys.tables WHERE NOT system ORDER BY name +----- +glbl_nopk_twoucs +glbl_pk_uc +tmp_nopk_twoucs +tmp_pk_uc + +query T rowsort +SELECT name FROM sys.idxs WHERE (table_id) IN (SELECT id FROM sys.tables WHERE NOT system) ORDER BY name +----- +glbl_nopk_twoucs_id2_unique +glbl_nopk_twoucs_name2_unique +glbl_pk_uc_id1_pkey +glbl_pk_uc_name1_unique + +query T rowsort +SELECT name FROM tmp.idxs WHERE (table_id) IN (SELECT id FROM sys.tables WHERE NOT system) ORDER BY name +----- +tmp_nopk_twoucs_id2_unique +tmp_nopk_twoucs_name2_unique +tmp_pk_uc_id1_pkey +tmp_pk_uc_name1_unique + +statement ok +CREATE INDEX tmp_pk_uc_i ON tmp.tmp_pk_uc (id1, name1) + +statement ok +CREATE INDEX tmp_nopk_twoucs_i ON tmp.tmp_nopk_twoucs (id2, name2) + +statement ok +CREATE INDEX glbl_pk_uc_i ON tmp.glbl_pk_uc (id1, name1) + +statement ok +CREATE INDEX glbl_nopk_twoucs_i ON tmp.glbl_nopk_twoucs (id2, name2) + +query T rowsort +SELECT name FROM sys.idxs WHERE (table_id) IN (SELECT id FROM sys.tables WHERE NOT system) ORDER BY name +----- +glbl_nopk_twoucs_i +glbl_nopk_twoucs_id2_unique +glbl_nopk_twoucs_name2_unique +glbl_pk_uc_i +glbl_pk_uc_id1_pkey +glbl_pk_uc_name1_unique + +query T rowsort +SELECT name FROM tmp.idxs WHERE (table_id) IN (SELECT id FROM sys.tables WHERE NOT system) ORDER BY name +----- +tmp_nopk_twoucs_i +tmp_nopk_twoucs_id2_unique +tmp_nopk_twoucs_name2_unique +tmp_pk_uc_i +tmp_pk_uc_id1_pkey +tmp_pk_uc_name1_unique + +statement ok +DROP INDEX tmp.tmp_pk_uc_i + +statement ok +DROP INDEX tmp.tmp_nopk_twoucs_i + +statement ok +DROP INDEX tmp.glbl_pk_uc_i + +statement ok +DROP INDEX tmp.glbl_nopk_twoucs_i + +query T rowsort +SELECT name FROM sys.idxs WHERE (table_id) IN (SELECT id FROM sys.tables WHERE NOT system) ORDER BY name +----- +glbl_nopk_twoucs_id2_unique +glbl_nopk_twoucs_name2_unique +glbl_pk_uc_id1_pkey +glbl_pk_uc_name1_unique + +query T rowsort +SELECT name FROM tmp.idxs WHERE (table_id) IN (SELECT id FROM sys.tables WHERE NOT system) ORDER BY name +----- +tmp_nopk_twoucs_id2_unique +tmp_nopk_twoucs_name2_unique +tmp_pk_uc_id1_pkey +tmp_pk_uc_name1_unique + +statement ok +DROP TABLE tmp.tmp_pk_uc + +statement ok +DROP TABLE tmp.glbl_pk_uc + +statement ok +DROP TABLE tmp.tmp_nopk_twoucs + +statement ok +DROP TABLE tmp.glbl_nopk_twoucs + +query T rowsort +SELECT name FROM sys.idxs WHERE (table_id) IN (SELECT id FROM sys.tables WHERE NOT system) ORDER BY name +----- + +query T rowsort +SELECT name FROM tmp.idxs WHERE (table_id) IN (SELECT id FROM sys.tables WHERE NOT system) ORDER BY name +----- + diff --git a/sql/test/BugTracker-2022/Tests/rerun-temp-table-index-fails-to-restart-server.Bug.test b/sql/test/BugTracker-2022/Tests/rerun-temp-table-index-fails-to-restart-server.Bug.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2022/Tests/rerun-temp-table-index-fails-to-restart-server.Bug.test @@ -0,0 +1,116 @@ +statement ok +CREATE LOCAL TEMP TABLE tmp.tmp_pk_uc (id1 INT NOT NULL PRIMARY KEY, name1 VARCHAR(99) UNIQUE) + +statement ok +CREATE LOCAL TEMP TABLE tmp.tmp_nopk_twoucs (id2 INT NOT NULL UNIQUE, name2 VARCHAR(99) UNIQUE) + +statement ok +CREATE GLOBAL TEMP TABLE tmp.glbl_pk_uc (id1 INT NOT NULL PRIMARY KEY, name1 VARCHAR(99) UNIQUE) + +statement ok +CREATE GLOBAL TEMP TABLE tmp.glbl_nopk_twoucs (id2 INT NOT NULL UNIQUE, name2 VARCHAR(99) UNIQUE) + +query T rowsort +SELECT name FROM sys.tables WHERE NOT system ORDER BY name +----- +glbl_nopk_twoucs +glbl_pk_uc +tmp_nopk_twoucs +tmp_pk_uc + +query T rowsort +SELECT name FROM sys.idxs WHERE (table_id) IN (SELECT id FROM sys.tables WHERE NOT system) ORDER BY name +----- +glbl_nopk_twoucs_id2_unique +glbl_nopk_twoucs_name2_unique +glbl_pk_uc_id1_pkey +glbl_pk_uc_name1_unique + +query T rowsort +SELECT name FROM tmp.idxs WHERE (table_id) IN (SELECT id FROM sys.tables WHERE NOT system) ORDER BY name +----- +tmp_nopk_twoucs_id2_unique +tmp_nopk_twoucs_name2_unique +tmp_pk_uc_id1_pkey +tmp_pk_uc_name1_unique + +statement ok +CREATE INDEX tmp_pk_uc_i ON tmp.tmp_pk_uc (id1, name1) + +statement ok +CREATE INDEX tmp_nopk_twoucs_i ON tmp.tmp_nopk_twoucs (id2, name2) + +statement ok +CREATE INDEX glbl_pk_uc_i ON tmp.glbl_pk_uc (id1, name1) + +statement ok +CREATE INDEX glbl_nopk_twoucs_i ON tmp.glbl_nopk_twoucs (id2, name2) + +query T rowsort +SELECT name FROM sys.idxs WHERE (table_id) IN (SELECT id FROM sys.tables WHERE NOT system) ORDER BY name +----- +glbl_nopk_twoucs_i +glbl_nopk_twoucs_id2_unique +glbl_nopk_twoucs_name2_unique +glbl_pk_uc_i +glbl_pk_uc_id1_pkey +glbl_pk_uc_name1_unique + +query T rowsort +SELECT name FROM tmp.idxs WHERE (table_id) IN (SELECT id FROM sys.tables WHERE NOT system) ORDER BY name +----- +tmp_nopk_twoucs_i +tmp_nopk_twoucs_id2_unique +tmp_nopk_twoucs_name2_unique +tmp_pk_uc_i +tmp_pk_uc_id1_pkey +tmp_pk_uc_name1_unique + +statement ok +DROP INDEX tmp.tmp_pk_uc_i + +statement ok +DROP INDEX tmp.tmp_nopk_twoucs_i + +statement ok +DROP INDEX tmp.glbl_pk_uc_i + +statement ok +DROP INDEX tmp.glbl_nopk_twoucs_i + +query T rowsort +SELECT name FROM sys.idxs WHERE (table_id) IN (SELECT id FROM sys.tables WHERE NOT system) ORDER BY name +----- +glbl_nopk_twoucs_id2_unique +glbl_nopk_twoucs_name2_unique +glbl_pk_uc_id1_pkey +glbl_pk_uc_name1_unique + +query T rowsort +SELECT name FROM tmp.idxs WHERE (table_id) IN (SELECT id FROM sys.tables WHERE NOT system) ORDER BY name +----- +tmp_nopk_twoucs_id2_unique +tmp_nopk_twoucs_name2_unique +tmp_pk_uc_id1_pkey +tmp_pk_uc_name1_unique + +statement ok +DROP TABLE tmp.tmp_pk_uc + +statement ok +DROP TABLE tmp.glbl_pk_uc + +statement ok +DROP TABLE tmp.tmp_nopk_twoucs + +statement ok +DROP TABLE tmp.glbl_nopk_twoucs + +query T rowsort +SELECT name FROM sys.idxs WHERE (table_id) IN (SELECT id FROM sys.tables WHERE NOT system) ORDER BY name +----- + +query T rowsort +SELECT name FROM tmp.idxs WHERE (table_id) IN (SELECT id FROM sys.tables WHERE NOT system) ORDER BY name +----- + diff --git a/sql/test/BugTracker-2022/Tests/temp-table-index.Bug.test b/sql/test/BugTracker-2022/Tests/temp-table-index.Bug.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2022/Tests/temp-table-index.Bug.test @@ -0,0 +1,116 @@ +statement ok +CREATE LOCAL TEMP TABLE tmp.tmp_pk_uc (id1 INT NOT NULL PRIMARY KEY, name1 VARCHAR(99) UNIQUE) + +statement ok +CREATE LOCAL TEMP TABLE tmp.tmp_nopk_twoucs (id2 INT NOT NULL UNIQUE, name2 VARCHAR(99) UNIQUE) + +statement ok +CREATE GLOBAL TEMP TABLE tmp.glbl_pk_uc (id1 INT NOT NULL PRIMARY KEY, name1 VARCHAR(99) UNIQUE) + +statement ok +CREATE GLOBAL TEMP TABLE tmp.glbl_nopk_twoucs (id2 INT NOT NULL UNIQUE, name2 VARCHAR(99) UNIQUE) + +query T rowsort +SELECT name FROM sys.tables WHERE NOT system ORDER BY name +----- +glbl_nopk_twoucs +glbl_pk_uc +tmp_nopk_twoucs +tmp_pk_uc + +query T rowsort +SELECT name FROM sys.idxs WHERE (table_id) IN (SELECT id FROM sys.tables WHERE NOT system) ORDER BY name +----- +glbl_nopk_twoucs_id2_unique +glbl_nopk_twoucs_name2_unique +glbl_pk_uc_id1_pkey +glbl_pk_uc_name1_unique + +query T rowsort +SELECT name FROM tmp.idxs WHERE (table_id) IN (SELECT id FROM sys.tables WHERE NOT system) ORDER BY name +----- +tmp_nopk_twoucs_id2_unique +tmp_nopk_twoucs_name2_unique +tmp_pk_uc_id1_pkey +tmp_pk_uc_name1_unique + +statement ok +CREATE INDEX tmp_pk_uc_i ON tmp.tmp_pk_uc (id1, name1) + +statement ok +CREATE INDEX tmp_nopk_twoucs_i ON tmp.tmp_nopk_twoucs (id2, name2) + +statement ok _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
