Changeset: 2189280799d5 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=2189280799d5
Added Files:
sql/test/BugTracker-2018/Tests/multiple-insertinto-table-Bug-6578.sql
Modified Files:
sql/test/BugTracker-2018/Tests/All
Branch: default
Log Message:
Merge with Mar2018
diffs (60 lines):
diff --git a/sql/test/BugTracker-2018/Tests/All
b/sql/test/BugTracker-2018/Tests/All
--- a/sql/test/BugTracker-2018/Tests/All
+++ b/sql/test/BugTracker-2018/Tests/All
@@ -50,3 +50,4 @@ sqlitelogictest-complex-case.Bug-6573
create-temp-table-ordered-index-error.Bug-6574
sqlitelogictest-missing-bulk-implementation.Bug-6575
sqlitelogictest-aritmetic-expressions-handling.Bug-6576
+multiple-insertinto-table-Bug-6578
diff --git
a/sql/test/BugTracker-2018/Tests/multiple-insertinto-table-Bug-6578.sql
b/sql/test/BugTracker-2018/Tests/multiple-insertinto-table-Bug-6578.sql
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2018/Tests/multiple-insertinto-table-Bug-6578.sql
@@ -0,0 +1,47 @@
+START TRANSACTION;
+CREATE TABLE "x" (
+ "a1" CHARACTER LARGE OBJECT,
+ "a2" CHARACTER LARGE OBJECT
+);
+COPY 5 RECORDS INTO "x" FROM stdin USING DELIMITERS '|','\n','"';
+"fiets"|"damesfiets"
+"fiets"|"herenfiets"
+"auto"|"personenwag"
+"auto"|"bedrijfsauto"
+"auto"|"personenauto"
+COMMIT;
+
+START TRANSACTION;
+CREATE TABLE "y" (
+ "paramname" CHARACTER LARGE OBJECT,
+ "value" CHARACTER LARGE OBJECT
+);
+COPY 1 RECORDS INTO "y" FROM stdin USING DELIMITERS '|','\n','"';
+"1"|"something"
+COMMIT;
+
+start transaction;
+
+insert into y values ('0','boot');
+insert into y values ('0','auto');
+
+select count(*)
+from x,
+ (select value as a1 from y where paramname='0') as v
+where x.a1 = v.a1;
+
+rollback;
+
+start transaction;
+
+insert into y values ('0','boot'), ('0','auto');
+
+select count(*)
+from x,
+ (select value as a1 from y where paramname='0') as v
+where x.a1 = v.a1;
+
+rollback;
+
+drop table x;
+drop table y;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
