Auto transform keywords works bad

Kcko's profile image Kcko posted 1 month ago in General Permalink

I didnt test all keywords, but some wont transform. eg 'ORDER BY'

Short video: https://is.gd/w5nmma

Kcko's profile image Kcko posted 1 month ago Permalink

any functions have same problems .. DATE is working, CONCAT is not

ansgar's profile image ansgar posted 1 month ago Permalink

The just written token is only UPPERCASED if a) it's a known keyword or function name and b) there is no table or procedure named "order" . I guess you have such a table?

Kcko's profile image Kcko posted 1 month ago Permalink

Hi,

Im home, we have in our system table with name order (eshop order, so i dont know this rule, so this explains everything).

But Concatis known keyword or not?

ansgar's profile image ansgar posted 1 month ago Permalink

Yes, CONCAT is known through all of these .ini files (you may check that in your HeidiSQL folder):

  • functions-mariadb.ini
  • functions-mysql8.ini
  • functions-mysql.ini

If the completion proposal (suggest list) contains a function name, the function should also be uppercased.

ansgar's profile image ansgar posted 1 month ago Permalink

concat => CONCAT works here.

1 attachment(s):
  • uppercase-keywords
Kcko's profile image Kcko posted 1 month ago Permalink

Works if you wrote function earlier then columns ;) https://is.gd/8hkfN3

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