database console autocomplete ignoring table and field name case
Answered
Hi,
I'm having a problem using database console after upgrading to IntelliJ IDEA 2019.3 .
I'm using MySql database and my fields and tables have names written in "PascalCase" (for example `User`, `UserRole`). When I type autocomplete pops up and shows a list of tables in lowercase. I tried to refresh the table list in the database pane, tried to change the driver and refresh again with no luck.
Database console displays database names when suggesting join clauses.
Please sign in to leave a comment.
Does it help to set Preferences | Editor | Code Style | SQL | MySQL -> Word Case: Identifiers to Do not change value?
If issue remains, attach screenshot of Word Case settings and output from Test Connection button for the Data Source.
already tried different case settings This is my TestConnection output:
DBMS: MySQL (ver. 5.7.28) Case sensitivity: plain=exact, delimited=exact Driver: MySQL Connector Java (ver. mysql-connector-java-5.1.47 ( Revision: fe1903b1ecb4a96a917f7ed3190d80c049b1de29 ), JDBC4.0) Ping: 54 ms SSL: no
And Word Case preferences
Here are screenshots from the console:
1. typing select and autocomplete pops up with lowercase table names
2. Join autocomplete offers correct table names
Thanks for details! Looks like a bug. Please follow the https://youtrack.jetbrains.com/issue/DBE-9828 for updates.
Hi,
after update to :
IntelliJ IDEA 2019.3.1 (Ultimate Edition)
Build #IU-193.5662.53, built on December 18, 2019
the problem is gone.
Thank You for Your effort.