Return
-
Title
Getting "This type of SQL is not supported" when trying to optimize valid query -
Description
Getting "This type of SQL is not supported" when trying to optimize valid query. -
Cause
Syntax not supporting cast to varchar with "CHAR" label.
In this case the query included "CAST('ABC' AS varchar(5 CHAR))". For example:
select 1
from dual
where 'ABC' = CAST('ABC' AS varchar(5 CHAR))
-
Resolution
WORKAROUND
Remove the label "CHAR" . In the example above it would be to replace "(5 CHAR)" by "(5)" so the query would be:
select 1
from dual
where 'ABC' = CAST('ABC' AS varchar(5))STATUS
Issue fixed in version 9.2.2. The latest version of SQL Optimizer for Oracle can be downloaded here
-
Defect ID
SOFO-2088