Better suggestion & autocompletition?

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.

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.

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.

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 :)

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.

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

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

saya juga ingin bertanaya itu