12.18 to 12.19: SHOW FUNCTION STATUS WHERE Db = LOWER('foo');

Hi, since I updated from 12.18.0.7304 to 12.19.0.7314 HeidiSQL connects to Databases using SHOW FUNCTION STATUS WHERE Db = LOWER('foo'); SHOW PROCEDURE STATUS WHERE Db = LOWER('foo'); with the effect, that no functions and procedures are shown in connection tree. Are there any settings to change?

Sorry, the statements shown above are misleading. Correct is: SHOW FUNCTION STATUS WHERE Db = LOWER('FooBar'); SHOW PROCEDURE STATUS WHERE Db = LOWER('FooBar'); where "FooBar" is the original and correct name for the queried database.

Ouch... I broke that, while solving a MySQL problem reported in issue #2506. The mysql.proc table had lowercase database names in that case, for an UPPERCASE database. IS.ROUTINES had it in correct uppercase or mixed case.

Solution was to query SHOW FUNCTION/PROCEDURE STATUS ... with a lowercase database, which you see now. I guess you also have uppercase chars in your database name?

If so, then a potential solution could be to query both the original case and the lowercased variant:

SHOW PROCEDURE STATUS WHERE Db IN ('foo', LOWER('foo'));

Ok. So you're going to fix this and deploy a new release? For the moment, I'll go back to 12.18

Yes I'm thinking a bugfix release should be released quicky, as this surely affects many users. Though I'm curious how common it is to have uppercase database names in MySQL/MariaDB. In 30 years of MySQL usage, I only did that one or two times for reproducing some upper/lower case issue.