Changeset: ee35c7cd8917 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/ee35c7cd8917
Added Files:
sql/test/BugTracker-2026/Tests/7786-rename-drop-table.test
Modified Files:
sql/storage/store.c
sql/test/BugTracker-2026/Tests/All
Branch: Dec2025
Log Message:
only cleanup table related objects (like keys and idxs) from schema
if the object (table) moves too a different schema. Not if its renamed within
the schema.
diffs (48 lines):
diff --git a/sql/storage/store.c b/sql/storage/store.c
--- a/sql/storage/store.c
+++ b/sql/storage/store.c
@@ -6094,8 +6094,6 @@ sql_trans_rename_table(sql_trans *tr, sq
if ((res = table_dup(tr, t, t->s, new_name, &dup, true)))
return res;
- if (isGlobal(t))
- res = cleanup_schema_objects(t, tr);
return res;
}
diff --git a/sql/test/BugTracker-2026/Tests/7786-rename-drop-table.test
b/sql/test/BugTracker-2026/Tests/7786-rename-drop-table.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2026/Tests/7786-rename-drop-table.test
@@ -0,0 +1,20 @@
+statement ok
+CREATE TABLE test_table (id INT PRIMARY KEY, name VARCHAR(100))
+
+statement ok rowcount 1
+INSERT INTO test_table (id, name) VALUES (1, 'Test Name')
+
+statement ok
+ALTER TABLE test_table RENAME TO renamed_table
+
+query IT
+SELECT * FROM renamed_table
+-----
+1
+Test Name
+
+statement ok rowcount 1
+UPDATE renamed_table SET name = 'Updated Name' WHERE id = 1
+
+statement ok
+Drop table renamed_table
diff --git a/sql/test/BugTracker-2026/Tests/All
b/sql/test/BugTracker-2026/Tests/All
--- a/sql/test/BugTracker-2026/Tests/All
+++ b/sql/test/BugTracker-2026/Tests/All
@@ -1,6 +1,7 @@
7780-unnest-slow
7782-roles-view
7783-deleted-row
+7786-rename-drop-table
7804-querylog-catalog-orderby-bug
7805-orderby-all-bug
7806-numeric-no-prec-no-scale
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
