Toad World® Forums

Toad Intelnside issue on sql with union - beta 13.0.0.16

when using TI in following sql it works just fine to get a list of columns for last expression

with a as
(
select distinct object_type from user_objects
)
select distinct a.object_type, a.
from a

once I have union in it (see below), TI list of columns is empty.

with a as
(
select distinct object_type from user_objects
union all
select ‘aaaa’ from dual
)
select distinct a.object_type, a.
from a

Hi

When I change part of query with
“a.”
to
“a.*”
both queries works fine.

Brg
Damir

a. is where I user ctrl + <.> to get ToadInside - list of columns, in later case it’s empty

Fixed in next beta.

Thanks,

Michael