Custom Table Aliases in auto-complete

Answered

Hola,

When autocomplete guesses "orders" after a few keystrokes, it includes the custom table alias in the list of autocomplete options (see enclosed GIF) - cool! However, when DataGrip correctly guesses cl_order_extra_info on the next line, it shows the table name without the custom table alias, even though as you can later see it eventually finds it.

I'm using the latest version of DataGrip 2021.2.1, Build #DB-212.5080.22 to query a MariaDB database. I have a number of custom table aliases defined (in this case, 'o' for the orders table and 'oei' for the cl_order_extra_info table). I have both "Automatically add aliases when completing table names" and "Suggest alias names in completion after table names" checked.

What can I change to get the custom table alias to appear immediately when the table name is correctly guessed?

Thanks,
Ed

3 comments
Comment actions Permalink

Set the output mode to https://testmyspeed.onl/ CSV to instruct the sqlite3 tool to issue the result in the CSV mode.

0
Comment actions Permalink

Thanks Kasey, but I'm talking about auto-complete for a MariaDB connection. How will the sqlite3 tool effect DataGrip's auto complete?

0
Comment actions Permalink

hi, I've moved your request to our tracker, please follow and vote to get noticed on any updates.

0

Please sign in to leave a comment.