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