Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Auto uppercase can be inconvenient

muzza4's profile image muzza4 posted 12 months 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 11 months 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 11 months ago Permalink

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

Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.
Misha v.3's profile image Misha v.3 posted 11 months 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 11 months ago Permalink

Done...

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

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