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.
Field | Old Value | New Value |
---|---|---|
Fixed Build | 15.0.9-14 | |
Resolution | Fixed | |
Resolved Date | Oct 23, 2014 5:51 PM | |
Status | New | Resolved |
Field | Old Value | New Value |
---|---|---|
Resolution | Fixed | Incomplete |
Resolved Date | Oct 23, 2014 5:51 PM | |
Status | Resolved | Reopened |
Field | Old Value | New Value |
---|---|---|
Fixed Build | 15.0.9-14 | 15.0.9-15 |
Resolution | Incomplete | Fixed |
Resolved Date | Oct 27, 2014 3:23 PM | |
Status | Reopened | Verified |
Field | Old Value | New Value |
---|---|---|
Status | Verified | Closed |
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 |