Changeset: bfea9425b863 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=bfea9425b863 Modified Files: sql/test/BugTracker-2019/Tests/merge-statement-aliases.Bug-6715.stable.err sql/test/BugTracker-2019/Tests/merge-statement-aliases.Bug-6715.stable.out Branch: Apr2019 Log Message:
Specifying the target column's table/relation name in the column list for insert and update statements is not mentioned in the SQL standard. Therefore we won't implement it. diffs (58 lines): diff --git a/sql/test/BugTracker-2019/Tests/merge-statement-aliases.Bug-6715.stable.err b/sql/test/BugTracker-2019/Tests/merge-statement-aliases.Bug-6715.stable.err --- a/sql/test/BugTracker-2019/Tests/merge-statement-aliases.Bug-6715.stable.err +++ b/sql/test/BugTracker-2019/Tests/merge-statement-aliases.Bug-6715.stable.err @@ -26,6 +26,28 @@ stderr of test 'merge-statement-aliases. # 10:27:55 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-18243" "--port=31635" # 10:27:55 > +MAPI = (monetdb) /var/tmp/mtest-25315/.s.monetdb.33017 +QUERY = MERGE INTO ProductTarget T USING ProductSource S ON S.ProductID = T.ProductID WHEN MATCHED THEN UPDATE SET T.Name = S.Name, ProductTarget.ProductNumber = S.ProductNumber, ProductTarget.Color = S.Color; +ERROR = !syntax error, unexpected '.', expecting '=' in: "merge into producttarget t using productsource s on s.productid = t.productid wh" +CODE = 42000 +MAPI = (monetdb) /var/tmp/mtest-25315/.s.monetdb.33017 +QUERY = MERGE INTO ProductTarget T USING ProductSource S ON S.ProductID = T.ProductID WHEN NOT MATCHED THEN INSERT (T.ProductID, ProductTarget.ProductNumber, ProductTarget.Color, T.Name) VALUES (S.ProductID, S.ProductNumber, S.Color, S.Name); +ERROR = !syntax error, unexpected '.', expecting ')' or ',' in: "merge into producttarget t using productsource s on s.productid = t.productid wh" +CODE = 42000 +MAPI = (monetdb) /var/tmp/mtest-25315/.s.monetdb.33017 +QUERY = MERGE INTO ProductTarget T USING ProductSource S ON S.ProductID = T.ProductID + WHEN MATCHED THEN UPDATE SET ProductTarget.Name = S.Name, ProductTarget.ProductNumber = S.ProductNumber, T.Color = S.Color + WHEN NOT MATCHED THEN INSERT (T.ProductID, ProductTarget.ProductNumber, ProductTarget.Color, T.Name) VALUES (ProductID, S.ProductNumber, S.Color, Name); +ERROR = !syntax error, unexpected '.', expecting '=' in: "merge into producttarget t using productsource s on s.productid = t.productid + ! w" +CODE = 42000 +MAPI = (monetdb) /var/tmp/mtest-25315/.s.monetdb.33017 +QUERY = MERGE INTO ProductTarget T USING ProductSource S ON T.ProductID = S.ProductID + WHEN MATCHED THEN UPDATE SET T.Name = S.Name, T.ProductNumber = ProductNumber, T.Color = Color + WHEN NOT MATCHED THEN INSERT (T.ProductID, T.ProductNumber, T.Color, T.Name) VALUES (ProductID, S.ProductNumber, S.Color, Name); +ERROR = !syntax error, unexpected '.', expecting '=' in: "merge into producttarget t using productsource s on t.productid = s.productid + ! w" +CODE = 42000 # 10:27:55 > # 10:27:55 > "Done." diff --git a/sql/test/BugTracker-2019/Tests/merge-statement-aliases.Bug-6715.stable.out b/sql/test/BugTracker-2019/Tests/merge-statement-aliases.Bug-6715.stable.out --- a/sql/test/BugTracker-2019/Tests/merge-statement-aliases.Bug-6715.stable.out +++ b/sql/test/BugTracker-2019/Tests/merge-statement-aliases.Bug-6715.stable.out @@ -28,22 +28,10 @@ Ready. #CREATE TABLE ProductSource (ProductID SERIAL, Name VARCHAR(100) NOT NULL, ProductNumber BIGINT, Color VARCHAR(30) NOT NULL); #MERGE INTO ProductTarget T USING ProductSource S ON S.ProductID = T.ProductID WHEN MATCHED THEN UPDATE SET Name = S.Name; [ 0 ] -#MERGE INTO ProductTarget T USING ProductSource S ON S.ProductID = T.ProductID WHEN MATCHED THEN UPDATE SET T.Name = S.Name, ProductTarget.ProductNumber = S.ProductNumber, ProductTarget.Color = S.Color; -[ 0 ] -#MERGE INTO ProductTarget T USING ProductSource S ON S.ProductID = T.ProductID WHEN NOT MATCHED THEN INSERT (T.ProductID, ProductTarget.ProductNumber, ProductTarget.Color, T.Name) VALUES (S.ProductID, S.ProductNumber, S.Color, S.Name); -[ 0 ] #MERGE INTO ProductTarget T USING ProductSource S ON S.ProductID = T.ProductID # WHEN MATCHED THEN UPDATE SET Name = S.Name, ProductNumber = S.ProductNumber, Color = S.Color # WHEN NOT MATCHED THEN INSERT (ProductID, ProductNumber, Color, Name) VALUES (S.ProductID, S.ProductNumber, Color, Name); [ 0 ] -#MERGE INTO ProductTarget T USING ProductSource S ON S.ProductID = T.ProductID -# WHEN MATCHED THEN UPDATE SET ProductTarget.Name = S.Name, ProductTarget.ProductNumber = S.ProductNumber, T.Color = S.Color -# WHEN NOT MATCHED THEN INSERT (T.ProductID, ProductTarget.ProductNumber, ProductTarget.Color, T.Name) VALUES (ProductID, S.ProductNumber, S.Color, Name); -[ 0 ] -#MERGE INTO ProductTarget T USING ProductSource S ON T.ProductID = S.ProductID -# WHEN MATCHED THEN UPDATE SET T.Name = S.Name, T.ProductNumber = ProductNumber, T.Color = Color -# WHEN NOT MATCHED THEN INSERT (T.ProductID, T.ProductNumber, T.Color, T.Name) VALUES (ProductID, S.ProductNumber, S.Color, Name); -[ 0 ] #DROP TABLE ProductTarget; #DROP TABLE ProductSource; _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
