Auto transform keywords works bad

Kcko's profile image Kcko posted 2 hours 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 2 hours ago Permalink

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

ansgar's profile image ansgar posted 1 hour 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 hour 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 31 minutes 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.

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