Changeset: 2faf7fad3ed7 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=2faf7fad3ed7
Added Files:
sql/test/rename/Tests/rename12.sql
Modified Files:
sql/test/rename/Tests/All
Branch: linear-hashing
Log Message:
Added crashing renaming test
diffs (59 lines):
diff --git a/sql/test/rename/Tests/All b/sql/test/rename/Tests/All
--- a/sql/test/rename/Tests/All
+++ b/sql/test/rename/Tests/All
@@ -10,3 +10,4 @@ rename08
rename09
rename10
HAVE_PYMONETDB?rename11
+rename12
diff --git a/sql/test/rename/Tests/rename12.sql
b/sql/test/rename/Tests/rename12.sql
new file mode 100644
--- /dev/null
+++ b/sql/test/rename/Tests/rename12.sql
@@ -0,0 +1,46 @@
+create schema "SA";
+create schema "SB";
+
+create table "SA"."t1" (a uuid);
+insert into "SA"."t1" values (null), ('be887b3d-08f7-c308-7285-354a1857cbd9');
+
+start transaction;
+select "a" from "SA"."t1";
+alter table "SA"."t1" set schema "SB";
+select "a" from "SB"."t1";
+drop table "SB"."t1";
+rollback;
+
+select "a" from "SA"."t1";
+select "a" from "SB"."t1"; --error
+
+start transaction;
+select "a" from "SA"."t1";
+alter table "SA"."t1" rename column "a" to "b";
+select "b" from "SA"."t1";
+commit;
+
+select "b" from "SA"."t1";
+select "a" from "SA"."t1"; --error
+
+start transaction;
+select "b" from "SA"."t1";
+alter table "SA"."t1" rename column "b" to "c";
+select "c" from "SA"."t1";
+select "b" from "SA"."t1"; --error
+rollback;
+
+select "b" from "SA"."t1";
+select "c" from "SA"."t1"; --error
+
+start transaction;
+select "b" from "SA"."t1";
+alter table "SA"."t1" set schema "SB";
+select "b" from "SB"."t1";
+commit;
+
+select "b" from "SB"."t1";
+select "b" from "SA"."t1"; --error
+
+drop schema "SA" cascade;
+drop schema "SB" cascade;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
