Eliminated subselect in outer join on virtual schema leads to internal error
Details
| Detail name | Value |
|---|---|
| Changelog Number | 7422 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | EXASOL 6.0.0, Exasol 6.1.0 |
| Fix Versions | Exasol 6.1.2 |
| Resolution Date | 2019-02-01 |
Problem
An eliminated subselect in an outer join on a virtual schema leads to an internal error. Example:
select a.a, b.a, b.c from vs.test1 a left outer join (select a, 1 as c from vs.test2) b on a.a = b.a;
Workaround
Disable the SELECTLIST_PROJECTION capability in the virtual schema adapter.
