kdcro101 / vscode-cassandra

Design and query Apache Cassandra database with help of generated templates, autocomplete and inline code decorations in Visual Studio Code
GNU General Public License v3.0
22 stars 6 forks source link

Undefined Column if names are not lower-case #5

Closed alexandermikuta closed 5 years ago

alexandermikuta commented 5 years ago

Describe the bug Cassandra uses lower-case as default. If non-lower-case names should be preserved they need to be quoted.

To Reproduce Steps to reproduce the behavior:

  1. Create a table with e.g. column name "userId"
  2. Select table via cassandra-workbench 3 Message "undefined column name userId" appears as workbench selects without quotes around column-name

Expected behavior Select should work also for non-lower-case names, so selects from workbench should be quoted.

System info (please complete the following information):

kdcro101 commented 5 years ago

@alexandermikuta,

Thank you for your feedback! Please update to version 0.3.5. Problem should be fixed.

If you have any problems, open issue.

alexandermikuta commented 5 years ago

Thanks for your quick fix. The Column-Names are fixed now, but the problem seems also to exist for Table-Names. There I get still the same problem.

Kind regards, Alex

kdcro101 commented 5 years ago

@alexandermikuta ,

Thank you for your feedback. Please update to version 0.3.6. All object names are double-quoted if case sensitive.

If you have any problems, please open new issue.