BenSatori opened a new pull request, #2522: URL: https://github.com/apache/datafusion-sqlparser-rs/pull/2522
Before this fix, PostgreSQL's `BETWEEN SYMMETRIC` / `BETWEEN ASYMMETRIC` modifier wasn't parsed: ```sql SELECT * FROM customers WHERE a NOT BETWEEN SYMMETRIC 10 AND 1; ``` This adds a `symmetric` field to `Expr::Between` and parses the optional `SYMMETRIC`/`ASYMMETRIC` keyword after `BETWEEN` (per the SQL standard / PostgreSQL docs: https://www.postgresql.org/docs/current/functions-comparison.html). `ASYMMETRIC` is the default behavior and is not round-tripped in the displayed SQL. AI assistance disclosure: this change was drafted with GitHub Copilot. -- 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]
