Toad World® Forums

12.5.0.99 Pick-list dropdown not triggering

The pick-list dropdown is not triggering in certain situations. Using the CTRL-T key combo doesn’t help.

Example 1

Triggers here:

select * from user_objects uo where uo.

Doesn’t: trigger here when select is part of create table statement:

create table test as select * from user_objects uo where uo.

Example 2

Triggers here when referencing alias for the first table in join:

select * from user_objects uo join user_tables ut on ut.

Doesn’t trigger here when referencing alias for second table in join:

select * from user_objects uo join user_tables ut on ut.tablename = uo.

Example 3

Triggers here using alias for first table:

select * from user_objects uo, user_table ut where uo.

Doesn’t trigger here when using the alias for the second table:

select * from user_objects uo, user_table ut where ut.

I have 1 and 2 fixed for next 12.6 beta. Item 3 looks like a typo. You have USER_TABLE instead of USER_TABLES.

Thanks,

Michael

On 07/02/2014 03:41 PM, raymond.leung wrote:

12.5.0.99 Pick-list dropdown not triggering

Thread created by raymond.leung
The pick-list dropdown is not triggering in certain situations. Using the CTRL-T key combo doesn’t help.

Example 1

Triggers here:

select * from user_objects uo where uo.

Doesn’t: trigger here when select is part of create table statement:

create table test as select * from user_objects uo where uo.

Example 2

Triggers here when referencing alias for the first table in join:

select * from user_objects uo join user_tables ut on ut.

Doesn’t trigger here when referencing alias for second table in join:

select * from user_objects uo join user_tables ut on ut.tablename = uo.

Example 3

Triggers here using alias for first table:

select * from user_objects uo, user_table ut where uo.

Doesn’t trigger here when using the alias for the second table:

select * from user_objects uo, user_table ut where ut.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

Yes, Example 3 was a typo. Sorry.

Note that Example 2 is also an issue with CREATE MATERIALIZED_VIEW statement as well.

When will 12.6 be available?

Confirmed it is fixed in 12.5.1