-
Notifications
You must be signed in to change notification settings - Fork 524
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
SQLite dialect doesn't support typeless columns #743
Comments
@alamb I was wondering; this seems to be a mutually exclusive logic. Other databases require the data type, while SQLite doesn't. Is it reasonable to assume that the GenericDialect behavior would be to allow untyped columns...? |
I think if that was technically feasible and not too disruptive, it would be a nice feature |
I think the rules in SQLite are that the symbol after the column name is the data type unless it's one of the keywords introducing a column constraint: CONSTRAINT, PRIMARY, NOT, UNIQUE, CHECK, DEFAULT, COLLATE, REFERENCES, GENERATED, or AS. I'm basing this on the diagrams on this page. Is it sufficient to allow the check here to be skipped for SQLite: And then make Is the aim with |
SQLite supports untyped columns in the schema, like in this example:
Unfortunately, parsing this
CREATE TABLE
statement with currentsqlparser
(0.27) results in:The text was updated successfully, but these errors were encountered: