With x as (select 5 from dual),
(select 7 from x
union
select 8 from y)
minus
select 6 from dual;
When attemping to run a query in the following situation, the program reports a random error depending on the location of the text curser at the time of the run. This worked in previous versions. Why does it no longer work?
y as (select 9 from dual)****
Hi there
Thankyou for reporting this issue, seems we have broken this between versions.
I have raised ST14469 for this issue and we will aim to fix it in the next beta drop.
regards
Lidia
(select 7 from (select 5 from dual)
union
select 8 from (select 9 from dual))
minus select 6 from dual;
regards
Lidia
Sorry I forgot to add that the only alternative for the moment is to re-write the statement without the "with’, eg.
Hi Shane,
Further evaluation of risks of the changes required, we would like to defer the changes to v7.0 release which currently targeted for later this year.
Our apology that we will not be able to include in the next v6.7 release as promised.
Thanks and regards,
Bruce