martin-g opened a new issue, #2615: URL: https://github.com/apache/datafusion-sqlparser-rs/issues/2615
Hello! At https://github.com/apache/datafusion/issues/24998 we were investigating a problem that `DELETE FROM tableX LIMIT 10` was actually ignoring the limit and deleting all records. It seems only MySQL/MariaDB supports `LIMIT` in `DELETE` clause. All other major DBs cannot parse it. For example: Postgres: ``` postgres=# DELETE FROM t3 LIMIT 2; ERROR: syntax error at or near "LIMIT" LINE 1: DELETE FROM t3 LIMIT 2; ^ ``` DuckDB: ``` memory D DELETE FROM t3 LIMIT 2; Parser Error: syntax error at or near "LIMIT" LINE 1: DELETE FROM t3 LIMIT 2; ^ ``` Should sqlparser-rs disable DELETE+LIMIT for all but the MySQL dialect ? -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
