phillipleblanc opened a new issue, #10624:
URL: https://github.com/apache/datafusion/issues/10624
### Describe the bug
When unparsing LogicalPlans back to SQL statements for the MySQL dialect,
any plan that includes a `Sort` node will produce a SQL statement that looks
like:
```
SELECT "ta"."j1_id" FROM "j1" AS "ta" ORDER BY "ta"."j1_id" ASC NULLS LAST
LIMIT 10
^--------^
```
The `NULLS LAST` causes issues when run against a MySQL server, as it
doesn't recognize that syntax.
### To Reproduce
Create an Unparser with a MySQL dialect, unparse any plan that includes a
Sort node and observe that the SQL string generated includes the NULLS
FIRST/LAST clause.
### Expected behavior
The MySQL dialect should omit writing out the NULLS LAST clause, since its
not a supported feature of the DB.
### Additional context
_No response_
--
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.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
