Skip to content
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

Dolthub SQL Editor auto UPPERCASES certain tokens, making certain queries impossible #533

Open
verdverm opened this issue Mar 12, 2024 · 2 comments
Assignees
Labels
bug Something isn't working

Comments

@verdverm
Copy link

In the Dolthub SQL editor, there are certain strings that get automatically UPPERCASED and make it impossible to write a column name like year.

I assume it has to do with an LSP like mechanism for certain SQL keywords

https://www.dolthub.com/repositories/topicalsource/us-border/data/main/cbp_apprehensions_monthly

Screenshot 2024-03-11 at 9 35 05 PM
@verdverm verdverm added the bug Something isn't working label Mar 12, 2024
@verdverm
Copy link
Author

I would say that removing the case changing would be the way to go, since SQL is generally relaxed when it comes to the casing of keywords anyway

@liuliu-dev
Copy link

You can use backticks to wrap the column name to avoid case changing.
The query also works without backticks.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants