Devart Forums

Yay. It's working!

Thank you very much for the custom build. I've installed it and my function autocomplete is working again.

Awesome news. Thank you so much.

dzhanhira wrote: ↑Fri 08 Jul 2022 11:46 Hi,

Kindly be informed that we are going to fix this issue in one of the next releases.

I've noticed the same issue since upgrading.

Enabling the Tools -> Options -> Output -> Write queries sent by the program to the SQL Log option allowed me to see the queries being run to get the autocomplete texts when I select the Edit -> Code Completion -> Refresh Local Cache menu option.

On an older version of dbForge (Express 8.2.23) I see this query:
SELECT p.name
, p.type
, p.param_list
, p.returns
, p.comment
FROM mysql.proc AS p
WHERE p.db = 'Axxxxxxx' OR p.db = lower('Axxxxxxx')
ORDER BY p.name;

But on the new version of dbForge (Express 9.0.897) I see this query:
SELECT p.name
, p.type
, p.param_list
, p.returns
, p.comment
FROM mysql.proc AS p
WHERE p.db = 'Axxxxxxx'
ORDER BY p.name;

Looking at the mysql.proc table I see everything in the db field starts with a lower case character 'axxxxxxx' even though a "SHOW DATABASES" shows this database name starting with an upper case character.

It looks like the issue is that the query to get the list of functions from mysql.proc is case sensitive as the lower case conversion part has been removed for some reason.