dilovancelik commented on code in PR #1790:
URL:
https://github.com/apache/datafusion-sqlparser-rs/pull/1790#discussion_r2025411856
##########
tests/sqlparser_mssql.rs:
##########
@@ -1921,3 +1921,9 @@ fn ms() -> TestedDialects {
fn ms_and_generic() -> TestedDialects {
TestedDialects::new(vec![Box::new(MsSqlDialect {}),
Box::new(GenericDialect {})])
}
+
+#[test]
+fn parse_mssql_merge_with_output() {
+ let stmt = "MERGE dso.products AS t USING dsi.products AS s ON s.ProductID
= t.ProductID WHEN MATCHED AND NOT (t.ProductName = s.ProductName OR
(ISNULL(t.ProductName, s.ProductName) IS NULL)) THEN UPDATE SET t.ProductName =
s.ProductName WHEN NOT MATCHED BY TARGET THEN INSERT (ProductID, ProductName)
VALUES (s.ProductID, s.ProductName) WHEN NOT MATCHED BY SOURCE THEN DELETE
OUTPUT $action, deleted.ProductID INTO dsi.temp_products";
Review Comment:
Yeah that makes a lot of sense. Its should be updated to be multiline now
--
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.
To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org
For additional commands, e-mail: github-h...@datafusion.apache.org
