"Code Insight pick list" does not work properly with case sensitive column names (4334463)

"Code Insight pick list" does not work properly with case sensitive column names.

To reproduce the problem follow the steps below:

1.Create table with the script below:

CREATE TABLE TEMP ("Case sensitive" VARCHAR2(10));

2. Go to the editor and type

SELECT T.
FROM TEMP T

The pick list returns:

SELECT T.CASE SENSITIVE
FROM TEMP T

This query fails with error:
ORA-00904: "T"."CASE": invalid identifier

The correct select is

SELECT T."Case sensitive"
FROM TEMP T

WORKAROUND

Type the query directly in the editor or modify the query generated like this:

SELECT T."Case sensitive"
FROM TEMP T

STATUS

Issue fixed in version 12.9. The latest version of Toad for Oracle can be downloaded at: https://support.quest.com/toad-for-oracle/download-new-releases