CONNECT BY fails on some combinations of VIEWS and UNION ALL
Details
| Detail name | Value |
|---|---|
| Changelog Number | 5132 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | EXASOL 6.0.0, EXASOL 6.0.2 |
| Fix Versions | EXASOL 6.0.3 |
| Resolution Date | 2017-09-22 |
The simplest query that reproduces the probem, we found so far:
with
t0 as (select 'a' a, 'b' b),
t1 as (select a, b
from t0
CONNECT BY a = PRIOR b)
SELECT a, b
from t1
UNION ALL
SELECT null, null;
Workaround
Put the query containing the CONNECT BY into a subselect:
with
t0 as (select 'a' a, 'b' b),
t1 as (select * from (select a, b
from t0
CONNECT BY a = PRIOR b))
SELECT a, b
from t1
UNION ALL
SELECT null, null;