cloud-fan commented on a change in pull request #27677: [SPARK-30924][SQL][3.0]
Add additional checks to Merge Into
URL: https://github.com/apache/spark/pull/27677#discussion_r383097562
##########
File path:
sql/catalyst/src/test/scala/org/apache/spark/sql/catalyst/parser/DDLParserSuite.scala
##########
@@ -1190,6 +1190,56 @@ class DDLParserSuite extends AnalysisTest {
assert(exc.getMessage.contains("There should be at most 1 'WHEN NOT
MATCHED' clause."))
}
+ test("merge into table: the first matched clause must have a condition if
there's a second") {
+ val exc = intercept[ParseException] {
+ parsePlan(
+ """
+ |MERGE INTO testcat1.ns1.ns2.tbl AS target
+ |USING testcat2.ns1.ns2.tbl AS source
+ |ON target.col1 = source.col1
+ |WHEN MATCHED THEN DELETE
+ |WHEN MATCHED THEN UPDATE SET target.col2 = source.col2
+ |WHEN NOT MATCHED AND (target.col2='insert')
+ |THEN INSERT (target.col1, target.col2) values (source.col1,
source.col2)
+ """.stripMargin)
+ }
+
+ assert(exc.getMessage.contains("the first MATCHED clause must have a
condition"))
+ }
+
+ test("merge into table: there must be a when (not) matched condition") {
+ val exc = intercept[ParseException] {
+ parsePlan(
+ """
+ |MERGE INTO testcat1.ns1.ns2.tbl AS target
+ |USING testcat2.ns1.ns2.tbl AS source
+ |ON target.col1 = source.col1
+ """.stripMargin)
+ }
+
+ assert(exc.getMessage.contains("There must be at least one WHEN clause in
a MERGE statement"))
+ }
+
+ test("merge into table: there can be only a single use DELETE or UPDATE") {
+ Seq("UPDATE SET *", "DELETE").foreach { op =>
Review comment:
This is a bit hard to justify. For example, we may want to update different
rows with different new values according to the condition.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org
For additional commands, e-mail: reviews-h...@spark.apache.org
