Intellisense/Autocomplete for functions and procedures no longer working
Intellisense/Autocomplete for functions and procedures no longer working
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.
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.
Last edited by mconradie on Tue 05 Jul 2022 07:23, edited 1 time in total.
Re: Intellisense/Autocomplete for functions and procedures no longer working
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?
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?
Re: Intellisense/Autocomplete for functions and procedures no longer working
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
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
Last edited by mconradie on Tue 05 Jul 2022 09:33, edited 1 time in total.
Re: Intellisense/Autocomplete for functions and procedures no longer working
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.
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.
Re: Intellisense/Autocomplete for functions and procedures no longer working
Hi,
Kindly be informed that we are going to fix this issue in one of the next releases.
Kindly be informed that we are going to fix this issue in one of the next releases.
Re: Intellisense/Autocomplete for functions and procedures no longer working
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.
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.
Re: Intellisense/Autocomplete for functions and procedures no longer working
Thank you for the custom build - I feel special :) It works 🥳
Re: Intellisense/Autocomplete for functions and procedures no longer working
Thank you for your interest.
Re: Intellisense/Autocomplete for functions and procedures no longer working
Yay. It's working!
Thank you very much for the custom build. I've installed it and my function autocomplete is working again.
Thank you very much for the custom build. I've installed it and my function autocomplete is working again.