dolthub / dolthub-issues

Issues for dolthub.com
https://dolthub.com
4 stars 1 forks source link

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

Open verdverm opened 6 months ago

verdverm commented 6 months ago

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 commented 6 months ago

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 commented 5 months ago

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