Better suggestion & autocompletition?

Kcko's profile image Kcko posted 9 months ago in General Permalink

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.

ansgar's profile image ansgar posted 9 months ago Permalink

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.

ansgar's profile image ansgar posted 9 months ago Permalink

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.

Kcko's profile image Kcko posted 9 months ago Permalink

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>, 9 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
ansgar's profile image ansgar posted 9 months ago Permalink

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.

Kcko's profile image Kcko posted 9 months ago Permalink

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

ansgar's profile image ansgar posted 9 months ago Permalink

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

46devora's profile image 46devora posted 8 months ago Permalink

saya juga ingin bertanaya itu

siegra's profile image siegra posted 3 months ago Permalink

sya ingin bertanya situs menggunakan sql apa ?

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