Better suggestion & autocompletition?

93 posts

Kcko posted 7 months ago in General

Im surprised that HeidiSQL dont know newer things like Windows Function, without hints totally. See short video: https://bit.ly/3Tkv66h

older stuff (features etc) it suggests well.

Same problem with Routines, dont know eg REPEAT loop? https://bit.ly/49YxiHx

Thx for further info.

10328 posts

ansgar posted 7 months ago

Function names are loaded from functions-mysql.ini in a MySQL session, and from functions-mariadb.ini in MariaDB session. The mariadb file contains newer stuff, but the mysql version is a bit outdated.

10328 posts

ansgar posted 7 months ago

Btw, you find these ini files in your HeidiSQL install directory.

I will see if I can use the HELP command in MySQL 8 for generating a more complete functions-mysql.ini.

Note the REPEAT .. UNTIL .. END REPEAT is a compound statement, not a function, and should therefore not go into that functions-*.ini file. Instead, I should extend HeidiSQL's internal list of keywords with these missing compound statements.

93 posts

Kcko posted 7 months ago

Function names are loaded from functions-mysql.ini in a MySQL session, and from functions-mariadb.ini in MariaDB session. The mariadb file contains newer stuff, but the mysql version is a bit outdated.¨

Yes, I understand that one. Only MySQL 8 and Maria DB are practically the same, almost the same functionality and it is missing there, if something could be done with it, it would be great, if not, nothing happens.

Thanks for the support and great product :)

Code modification/commit 54c953e from Ansgar Becker <anse@heidisql.com>, 7 months ago, revision 12.6.0.6816

Add functions-mysql8.ini with some newer functions in it, and search for version specific ini file when connecting. See https://www.heidisql.com/forum.php?t=41892

10328 posts

ansgar posted 7 months ago

Latest installer now installs an additional functions-mysql8.ini file, loaded on MySQL 8.* sessions, while the old one is still used on all other MySQL versions.

Note if you want to test that, you need to download the latest built installer from revision 12.6.0.6816, not just the executable, otherwise you don't get the new ini file.

93 posts

Kcko posted 7 months ago

I just downloaded the latest build, I'm on MYSQL 8 and it still doesn't respond (e.g. Window functions)

https://bit.ly/4cllD7l

10328 posts

ansgar posted 7 months ago

Please use the installer, not just the latest build. You need the new additional ini file, and only the installer is aware of that:

Description