Intellisense/Autocomplete for functions and procedures no longer working

[mconradie]

Hi

Since updating to version 9.0.897 (Express Edition), custom functions and procedures are no longer suggested in the autocomplete/intellisense list


Yet the following returns multiple results:
select * from mysql.proc where name like '%getarea%'


I did refresh the local cache to no avail.

Has this feature been removed from the Express Edition or is this a bug? We would love to purchase a more feature rich edition but the prices are prohibitive for most developers in 3rd world nations.

Thanks in advance and thank you for a great product.

[dzhanhira]

Hi,

Could you please clarify the version of the server, on which OS it is deployed, and the value of the lower_case_table_names variable?

[mconradie]

Thanks for getting back to me.

We're running many instances of MySQL 5.7. It seems to be working on Windows boxes (Windows Server 2008 R2 and MySQL 5.7.16) and not working on Linux boxes (CentOS7 and MySQL 5.7.33).

lower_case_table_names is set to 1

[andrer]

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.

[dzhanhira]

Hi,

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

[andrer]

Awesome news. Thank you so much.

Hi,

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

[mconradie]

Thank you - much appreciated :)

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

[dzhanhira]

Hi there,

Kindly be informed that we have prepared a special custom build with the fix for you:

https://download.devart.com/dbForge/MyS ... _12195.exe

Once it's installed, please let us know about the result.

[mconradie]

Thank you for the custom build - I feel special :) It works 🥳

[Aus]

Thank you for your interest.

[andrer]

Yay. It's working!

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