[MXS-4057] Query Editor Auto Intelligence Created: 2022-03-24  Updated: 2023-10-04  Resolved: 2023-10-04

Status: Closed
Project: MariaDB MaxScale
Component/s: maxgui
Affects Version/s: None
Fix Version/s: N/A

Type: New Feature Priority: Major
Reporter: Naresh Chandra Assignee: Todd Stoffel (Inactive)
Resolution: Duplicate Votes: 0
Labels: None

Issue Links:
Duplicate
duplicates MXS-4017 Query Editor Auto completion for all ... Closed

 Description   

As per the developers feedback, when they select the database and they trying to type the table name but the auto intelligence is not working here. They are unable to get the full table or column name or any object related to schema, if they type short name of the table or column or any object in the query editor.

Developers are expecting like below.

1. If they select any DB/Schema, then automatically it should show the matching tables or column or any object with full name while they type any short name of the table or column names or any objects.
2. If they select any schema/DB then all the objects related to that schema auto intelligence should work for any object. like when they are typing short tables, short columns, short views or any then it should show full matched tables names/column names/View names or any.
3. In the query editor, even if they place any multiple schemas and tables, If they join, then all the tables or columns or views or etc. the auto intelligence should work on the Query editor window.

 Comments   
Comment by Duong Thien Ly [ 2022-03-24 ]

Hi naresh.chandra@copart.com, this is expected behavior now. I'll change it to a new feature.
The "auto intelligence" works only when the tables are visible in the schemas sidebar. This is an intention to prevent querying everything as there may be hundreds of tables, columns. Anyway, I think, we can add an option in the query settings to automatically query them all.

Comment by Naresh Chandra [ 2022-03-24 ]

Hi Duong,

Make auto intelligence globally default for all in the query editor settings. I mean make it the setting default for all the schema and their objects.
Thanks for the update. Can we take fix this in the coming release like maxscale 7.

Comment by Naresh Chandra [ 2022-04-18 ]

Hi Duong,

Once the users selects the schema, then make immediately auto intelligence should work for all the objects(tables/views/procedures/view..etc) in the schema. So without expanding the table tree then auto intelligence should work for that particular schema.

1. Make default auto intelligence for every schema.
2. Add if any global parameter in the maxscale.config file.

Generated at Thu Feb 08 04:25:53 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.