auto-completion in CM,CQB doesn;t work well for long and join query

Details

Description

In the company, most of queries are so complicated and long.
The statement has Multi times JOINs, and consists of 20~100 lines for each query.
Based on understanding internal user's cases, the query editor's quto-completion should be tested more.

Issue Links

is duplicated by

Improvement - An improvement or enhancement to an existing feature or task. TOOLS-1161 Auto complete is not supported with join query and/or some complicated query

  • Major - Major loss of function.
  • Closed - The issue is considered finished, the resolution is correct. Issues which are closed can be reopened.

Activity

Hide
Permalink
高艳铭 added a comment -

Regression on CM8.4.1.2203
Now support status:
1 Alias auto-completion only support the first where, if where in second level, it cannot support.
such as: select * from a aalias where aalias. It's ok.
select * from a aalias where i in (select * from b balias where balias.)
2 After join on cannot support alias.
such as:
SELECT DISTINCT h.host_year, o.host_nation FROM history h RIGHT OUTER JOIN olympic o ON h.
It cannot display the columns.

Show
高艳铭 added a comment - Regression on CM8.4.1.2203 Now support status: 1 Alias auto-completion only support the first where, if where in second level, it cannot support. such as: select * from a aalias where aalias. It's ok. select * from a aalias where i in (select * from b balias where balias.) 2 After join on cannot support alias. such as: SELECT DISTINCT h.host_year, o.host_nation FROM history h RIGHT OUTER JOIN olympic o ON h. It cannot display the columns.

People

  • Assignee:
    Isaiah Choe
    Reporter:
    Laura Oh
Vote (0)
Watch (1)

Dates

  • Created:
    Updated: