Table column lookup (code assist) is changing the alias name in the where clause (154813)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Table column lookup (code assist) is changing the alias name in the where clause
Description

A query is created using a table alias, e.g. "my_table_a". When typing the dot (.) to open the listing of columns in the table, and selecting a column, it changes the "my_table_a" alias in the where clause to be "my_table_a_a.column_name". There is an extra '_a'.
Cause

Issue only occurs when an underscore is used in the alias.
Resolution

WORKAROUND:
Remove the underscore.
STATUS:
Issue fixed in version 12.8 of Toad for Oracle. The latest version can be downloaded here.
Defect ID

118025

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title