Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
I am unable to auto-complete on the columns of the aliases subquery if I use the "d" alias, yet if I don't use an alias it will show me columns for both tables.
select *
from ( select * from dept ) d
left join emp s on d.
In the following query I can't auto-complete columns for the alias "x" :
select * from
( select * from Customers ) x
left join
( select * from Employees ) y
on x.CustomerID = y.EmployeeID
Verified in ADS v18.0.0-preview-81 with latest Editor
Verified in ADS v18.0.0-preview-81 with latest Editor
Issue #12594 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| Fixed Build 15.0.9-15 |
| No time estimate |
3 issue links |
relates to #12516
Issue #12516Oracle -> Auto Completion -> not completing columns from derived tables |
relates to #8583
Issue #8583How to handle alias name and virtual temporary table names |
relates to #11905
Issue #11905autocompletion not working for SQL Server 2000 |
In the following query I can't auto-complete columns for the alias "x" :
select * from
( select * from Customers ) x
left join
( select * from Employees ) y
on x.CustomerID = y.EmployeeID