Changeset: ba903f1295ca for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/ba903f1295ca Added Files: sql/test/BugTracker-2025/Tests/7674-rel_find_designated_index_crash.test Modified Files: sql/test/BugTracker-2025/Tests/All Branch: Mar2025 Log Message:
Add test for #7674. When changing schema of a table, the schema of the index(es) of the table also need to be moved. This is not done internally. It crashes in rel_find_designated_index() when calling isTempSchema(idx->t->s). The idx->t->s->base.name pointer is corrupt. diffs (49 lines): diff --git a/sql/test/BugTracker-2025/Tests/7674-rel_find_designated_index_crash.test b/sql/test/BugTracker-2025/Tests/7674-rel_find_designated_index_crash.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2025/Tests/7674-rel_find_designated_index_crash.test @@ -0,0 +1,36 @@ +statement ok +CREATE SCHEMA IF NOT EXISTS schema1 + +statement ok +CREATE TABLE table1 (column1 NUMERIC(10, 2), column2 VARCHAR(100)) + +statement ok +CREATE INDEX index1 ON table1 (column1) + +statement ok +ALTER TABLE table1 SET SCHEMA schema1 + +statement error 42000!syntax error, unexpected IDENT, expecting INSERT or READ or SCHEMA or TABLE in: "alter table table1 set access" +ALTER TABLE table1 SET ACCESS READ ONLY + +skipif knownfail +statement ok +COMMENT ON INDEX index1 IS 'Index created for analytical queries' + +statement error 42S02!ALTER TABLE: no such table 'table1' +ALTER TABLE table1 SET READ ONLY + +statement ok +ALTER TABLE schema1.table1 SET READ ONLY + +statement error 42S02!COMMENT ON: no such table: 'table1' +COMMENT ON TABLE table1 IS 'Table created for analytical queries' + +statement ok +COMMENT ON TABLE schema1.table1 IS 'Table created for analytical queries' + +statement ok +DROP TABLE schema1.table1 + +statement ok +DROP SCHEMA schema1 diff --git a/sql/test/BugTracker-2025/Tests/All b/sql/test/BugTracker-2025/Tests/All --- a/sql/test/BugTracker-2025/Tests/All +++ b/sql/test/BugTracker-2025/Tests/All @@ -22,3 +22,4 @@ 7654_non_monetdb_user_remote_table_exec 7656_incorrect_error 7659_trigger_crashes 7671-lag-over-empty-bat +7674-rel_find_designated_index_crash _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
