Mysql Workbench with autocomplete with all database columns when using table alias

Asked

Viewed 1,641 times

7

I realized that after I installed a new version of Mysql Workbench the autocomplete brings columns from all tables, this when I use alias for table, when I repeat the table name the autocomplete works normal. The problem is that sometimes the table name is quite extensive.

Example:

SELECT * FROM cliente_relatorio_dinamico C where C.coluna_deste_banco;

Before, when tightening Ctrl+Space after "C." it appeared only columns of this bank, now it shows columns of all banks.

I believe you have overwritten some old version configuration file.

I tried to go back to the previous version but did not correct.

Does anyone have any idea ?

mysql-workbench self-cmplete

  • Good afternoon. I noticed that the problem occurs with Mariadb and Workbench with version higher than 6.0.9, ie if you are using Mariadb use version 6.0.9. In my case, I switched to Mysql and it’s solved. .

1 answer

1

I had similar problems with version 6.2.5, I had to downgrade to version 6.1.7 and the problem was solved, with me solved this way, it may be an alternative for you.

Browser other questions tagged mysql-workbench self-cmplete

You are not signed in. Login or sign up in order to post.