Easily find issues by searching: #<Issue ID>
Example: #1832
| Dev |
|
| QA |
|
| Priority | Low |
| Complexity | Unknown |
| Component | Q Analyzer - Auto-Completion |
| Version | 13.0 |
| Field | Old Value | New Value |
|---|---|---|
| Description |
ADS version : ads-windows-x64-14.0-dev-30.
select temp. from (select `actor_id` as a , `first_name` as fname from `actor`) as temp
Now in the above given query I'm selecting two column names from actor table and storing result to a temp table,now when i do another select from temp table and say temp. it will display column name of actor table.
How do ADS Auto completion will handle such cases where user is creating a virtual temporary table and is using alias name for column names?
|
ADS version : ads-windows-x64-14.0-dev-30.
select temp. from (select `actor_id` as a , `first_name` as fname from `actor`) as temp
Now in the above given query I'm selecting two column names from actor table and storing result to a temp table,now when i do another select from temp table and say temp. it will display column name of actor table,basically it is still referring to actor table which should not happen.
How do ADS Auto completion will handle such cases where user is creating a virtual temporary table and is using alias name for column names?
|
| Field | Old Value | New Value |
|---|---|---|
| Version | 14.0 | 13.0 |
With the virtual temporary tables, when we type temp. for the query "select temp. from (select `actor_id` as a , `first_name` as fname from `actor`) as temp" the correct behaviour was NOT to popup autocompletion as in previous versions of ADS 9,10,11 and 12. This is a bug which started occuring from ADS v13 and 14
As for the using alias for column names for virtual temp tables, since we don't display the column popup for completion, the aliases wont appear as well
| Field | Old Value | New Value |
|---|---|---|
| Dev Assignee | SachinPrakash (Sachin Prakash) | kin-hong (Kin-Hong Wong) |
| Type | Support | Bug |
| Field | Old Value | New Value |
|---|---|---|
| Resolution | Fixed | |
| Resolved Date | Apr 11, 2013 8:52 PM | |
| Status | New | Resolved |
| Field | Old Value | New Value |
|---|---|---|
| Fixed Build | 13.0-rc-24 | |
| Status | Resolved | Closed |
| Field | Old Value | New Value |
|---|---|---|
| Resolution | Fixed | Won't Fix |
Since autocomplete parser does not return selected columns (`actor_id`, `first_name`) associated with the table (`actor`), for now, autocomplete popup will show all columns
Since autocomplete parser does not return selected columns (`actor_id`, `first_name`) associated with the table (`actor`), for now, autocomplete popup will show all columns
Verified in ADS v18.0.0-preview-81 with latest Editor
Verified in ADS v18.0.0-preview-81 with latest Editor
Issue #8583 |
| Closed |
| Won't Fix |
| Resolved |
Completion |
| No due date |
| Fixed Build 13.0-rc-24 |
| No time estimate |
2 issue links |
relates to #11905
Issue #11905autocompletion not working for SQL Server 2000 |
relates to #12594
Issue #12594Auto-completion limitation with aliased sub-query |
With the virtual temporary tables, when we type temp. for the query "select temp. from (select `actor_id` as a , `first_name` as fname from `actor`) as temp" the correct behaviour was NOT to popup autocompletion as in previous versions of ADS 9,10,11 and 12. This is a bug which started occuring from ADS v13 and 14
As for the using alias for column names for virtual temp tables, since we don't display the column popup for completion, the aliases wont appear as well