LucaCappelletti94 opened a new pull request, #2837: URL: https://github.com/apache/datafusion-sqlparser-rs/pull/2837
PostgreSQL documents `SET SCHEMA 'value'` as an alias for `SET search_path TO value`, and accepts it after `SET LOCAL` and `SET SESSION` as well. Parsing `SET SCHEMA 'other'` currently fails with `Expected: equals sign or TO, found: 'other'`, because `SCHEMA` is read as a variable name. This PR adds `Set::SetSchema` behind a new `Dialect::supports_set_schema`. When `SCHEMA` is followed by `=` or `TO` it stays a variable name, as it does in PostgreSQL where `SCHEMA` is an unreserved keyword, so `SET schema = 'x'` still parses as an assignment. -- 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]
