Auto uppercase can be inconvenient

muzza4's profile image muzza4 posted 5 years ago in General Permalink

Hi Anse

About 13 years ago we made a decision to call a table of financial movements "transaction".

Now that HSQL automatically changes transaction to TRANSACTION it's become pretty inconvenient when writing a query since when in uppercase the query doesn't work (it clain table TRANSACTION does not exist).

Any chance that you could allow users to specify a list of words not to change to uppercase?

Cheers Muzza

ansgar's profile image ansgar posted 5 years ago Permalink

If that's a table in the current database, Heidi already knows these and should not uppercase them. I suppose there are some things to tweak here.

ansgar's profile image ansgar posted 5 years ago Permalink

You could post that here: https://github.com/HeidiSQL/HeidiSQL/issues/337

[expired user #1502]'s profile image [expired user #1502] posted 5 years ago Permalink

I'm confirming the issue. I just created table named 'transaction', refreshed tree (F5), opened Query and typed 'select from transaction'. Got 'SELECT FROM TRANSACTION'

muzza4's profile image muzza4 posted 5 years ago Permalink

Done...

https://github.com/HeidiSQL/HeidiSQL/issues/412

Please login to leave a reply, or register at first.