Toad World® Forums

Sql Navigator 6.4 with statments

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