-
Notifications
You must be signed in to change notification settings - Fork 729
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 generation fails when using Quoted Identifiers #1817
Comments
A workaround is to remove quotes around the identifier, but this will cause issues if the identifier is a reserved SQLite Keyword. I would be happy to offer a PR if someone could point me in the right direction. |
For others who may find this thread. I couldn't figure out why my table names had double quotes, because I didn't use them in This means I can't easily remove the quotes around identifiers to get around the issue with I looked upstream at their SQLite grammar, which uses a slightly different method for handling case than this repo does, but I don't see anything different with quoting. Using their Lab feature and and grammar shows quoted identifiers working just fine: http://lab.antlr.org/ Select I'm still looking, because I would like to use this project but I thought I'd share my findings so far. |
* fix(engine/sqlite): support quoted identifier close #1817 * test: add endtoend
Version
1.15.0
What happened?
Failure when SQLite identifiers are quoted with double quotes, for example quoting a table name as
"test"
or a column name as"id"
Relevant log output
Database schema
SQL queries
Configuration
Playground URL
https://play.sqlc.dev/p/1f469b2debde2c474439045390885b2bc9e9c9bcba0f9f2ecb78a8515b7afe07
What operating system are you using?
Linux
What database engines are you using?
SQLite
What type of code are you generating?
Go
The text was updated successfully, but these errors were encountered: