support upper case aliases

mtxr / SublimeText-SQLTools

SQLTools for Sublime Text 3

https://code.mteixeira.dev/SublimeText-SQLTools/

GNU General Public License v3.0

177 stars 40 forks source link

support upper case aliases #142

Closed swatoff closed 6 years ago

swatoff commented 6 years ago

Issue Type

[x] Feature Request
[ ] Bugfix/Errors
[ ] Questions
[ ] Other

Description

Alias from table name must associate with table name and columns. If i type select * from TABLE_NAME TN where TN.COLUMN1 is not null codeintel must show all columns from alias TN

Expected behavior:

See description

Actual behavior:

Alias not working. Instead alias i need type a full table name

Versions

Version: all version
OS: all OS
RDBMS: all suppoer RDBMS

tkopets commented 6 years ago

Indeed looks like a bug - thanks for reporting it. I will try to fix this bug this week. For now, you can use lower-cased aliases (which hopefully should work as expected). select * from TABLE_NAME tn where tn.COLUMN1 is not null

swatoff commented 6 years ago

Thank you, very much @tkopets. With lower-cased aliases work perfectly.

tkopets commented 6 years ago

This fix will be available in next release.