Changeset: 7b5849d3cece for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=7b5849d3cece
Modified Files:
        sql/test/BugTracker-2018/Tests/global-temp-tables.Bug-6643.sql
        sql/test/BugTracker-2018/Tests/global-temp-tables.Bug-6643.stable.out
Branch: Apr2019
Log Message:

Extending test with temporary tables which have tmp schema name prefix. Those 
should be allowed.


diffs (26 lines):

diff --git a/sql/test/BugTracker-2018/Tests/global-temp-tables.Bug-6643.sql 
b/sql/test/BugTracker-2018/Tests/global-temp-tables.Bug-6643.sql
--- a/sql/test/BugTracker-2018/Tests/global-temp-tables.Bug-6643.sql
+++ b/sql/test/BugTracker-2018/Tests/global-temp-tables.Bug-6643.sql
@@ -2,7 +2,10 @@ CREATE SCHEMA "dropme";
 CREATE LOCAL TEMP TABLE "dropme"."temp1" ("id" int, "name" VARCHAR(99)); 
--error
 CREATE GLOBAL TEMP TABLE "dropme"."temp2" ("id" int, "name" VARCHAR(99)); 
--error
 DROP SCHEMA "dropme";
+
 START TRANSACTION;
 CREATE LOCAL TEMP TABLE "temp1" ("id" int, "name" VARCHAR(99));
 CREATE GLOBAL TEMP TABLE "temp2" ("id" int, "name" VARCHAR(99));
+CREATE LOCAL TEMPORARY TABLE tmp."temp3" ("id" int, "name" VARCHAR(99));
+CREATE GLOBAL TEMPORARY TABLE tmp."temp4" ("id" int, "name" VARCHAR(99));
 ROLLBACK;
diff --git 
a/sql/test/BugTracker-2018/Tests/global-temp-tables.Bug-6643.stable.out 
b/sql/test/BugTracker-2018/Tests/global-temp-tables.Bug-6643.stable.out
--- a/sql/test/BugTracker-2018/Tests/global-temp-tables.Bug-6643.stable.out
+++ b/sql/test/BugTracker-2018/Tests/global-temp-tables.Bug-6643.stable.out
@@ -69,6 +69,8 @@ Ready.
 #START TRANSACTION;
 #CREATE LOCAL TEMP TABLE "temp1" ("id" int, "name" VARCHAR(99));
 #CREATE GLOBAL TEMP TABLE "temp2" ("id" int, "name" VARCHAR(99));
+#CREATE LOCAL TEMPORARY TABLE tmp."temp3" ("id" int, "name" VARCHAR(99));
+#CREATE GLOBAL TEMPORARY TABLE tmp."temp4" ("id" int, "name" VARCHAR(99));
 #ROLLBACK;
 
 # 16:48:58 >  
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to