calebdw opened a new issue, #2407:
URL: https://github.com/apache/datafusion-sqlparser-rs/issues/2407
## Summary
rejects PostgreSQL 18 generated columns when the generated-column mode is
omitted.
PostgreSQL 18 supports both stored and virtual generated columns. Per the
PostgreSQL 18 docs, generated columns are virtual by default and / are
optional explicit mode keywords:
https://www.postgresql.org/docs/current/ddl-generated-columns.html
## Reproduction
Using 0.62.0 with , parse:
## Expected behavior
The statement parses successfully, with represented as a generated virtual
column. Since PostgreSQL 18 defaults generated columns to virtual, omitted mode
should be accepted as virtual (or at least accepted with no explicit mode).
## Actual behavior
Parsing fails with:
This also affects PostgreSQL 18 output, which emits generated virtual
columns without an explicit keyword, for example:
## Notes
can parse a variant when is made explicit, but currently appears to
require after .
--
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]
