Easily find issues by searching: #<Issue ID>
Example: #1832
| Dev |
|
| QA |
|
| Priority | Low |
| Complexity | Unknown |
| Component | Q Analyzer - Auto-Completion |
| Version | 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
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