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

Autocompleting tables and columns that are all caps should not add backticks #185

Open
ddribin opened this issue Sep 13, 2024 · 0 comments

Comments

@ddribin
Copy link

ddribin commented Sep 13, 2024

Autocompleting tables and columns that are all caps adds backticks around the names. For example, completing a table named BAR adds backticks around this and completes to "`BAR`". (I can't format it correctly on GitHub. See the screen shots below).

Here's an example schema:

test.sqlite> .schema
+-----------------------------------------------------+
| sql                                                 |
+-----------------------------------------------------+
| CREATE TABLE BAR (PK integer primary key, BAR text) |
| CREATE TABLE foo (pk integer primary key, foo text) |
+-----------------------------------------------------+

The foo table completion works as expected:

foo completion

However, the BAR table completion adds unnecessary backticks:

BAR completion

For schemas that use all caps for all tables and columns, this adds a lot of unnecessary noise when typing queries. I don't think this should be adding quotes at all. At the least, it would be great to have an option to disable this behavior.

This is on:

LiteCli: 1.12.3 (SQLite: 3.46.1)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant