Toad World® Forums

12.9.0.52: Picklist not working with functions inside queries

SELECT CASE WHEN d.|
FROM dual d;

SELECT COALESCE( d.|
FROM dual d;

These two examples highlight a well known and discussed shortcoming of Code Insight. The parser cannot digest some SQL to the table references so it has no knowledge of the tables in the select. The following examples work, but I had to add enough of the missing pieces to make the parser happy. This is a heavily logged issue of broader scope than just Code Insight and has quite a few sub cases associated with it. It’s definitely on the radar, but I don’t have any ETA for you.

SELECT CASE WHEN d.| then 1 end
FROM dual d;

SELECT COALESCE( d.|)
FROM dual d;