You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@datafusion.apache.org by "tpyo (via GitHub)" <gi...@apache.org> on 2026/04/05 12:11:16 UTC
[PR] MySQL: Add support for `ORDER BY` on single-table `UPDATE` [datafusion-sqlparser-rs]
tpyo opened a new pull request, #2296:
URL: https://github.com/apache/datafusion-sqlparser-rs/pull/2296
Adds parsing support for the MySQL-specific `ORDER BY` clause in single-table `UPDATE` statements, as documented in the MySQL 8.4 reference.
**Changes:**
- Added `order_by: Vec<OrderByExpr>` field to the `Update` AST struct
- Added `supports_update_order_by()` dialect method (default `false`)
- Added tests for `UPDATE` ... `ORDER BY`, `UPDATE` ... `ORDER BY` ... `LIMIT`
Example syntax that would be supported:
```sql
UPDATE foo SET bar = false WHERE foo = true ORDER BY foo ASC;
```
--
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-unsubscribe@datafusion.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org
Re: [PR] MySQL: Add support for `ORDER BY` on single-table `UPDATE` [datafusion-sqlparser-rs]
Posted by "yoavcloud (via GitHub)" <gi...@apache.org>.
yoavcloud merged PR #2296:
URL: https://github.com/apache/datafusion-sqlparser-rs/pull/2296
--
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-unsubscribe@datafusion.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org
Re: [PR] MySQL: Add support for `ORDER BY` on single-table `UPDATE` [datafusion-sqlparser-rs]
Posted by "yoavcloud (via GitHub)" <gi...@apache.org>.
yoavcloud commented on PR #2296:
URL: https://github.com/apache/datafusion-sqlparser-rs/pull/2296#issuecomment-4213055349
Looks good @tpyo, let's just see that the checks pass and the branch is rebased.
--
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-unsubscribe@datafusion.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org