Regresar
-
Título
Getting "This type of SQL is not supported" when trying to optimize valid query -
Descripción
Getting "This type of SQL is not supported" when trying to optimize valid query. -
Causa
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))
-
Resolución
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
-
ID de defecto
SOFO-2088