Details
-
Bug
-
Resolution: Obsolete
-
Optional
-
None
-
9.x
-
None
Description
Defect Tracker #18728: If the where clause processed by the XML connectors has an equivalence expression containing two columns (where col1 = col2), the expression will be ignored. If the expression contains a column and a literal, it works properly. Thus a workaround is to use a scalar conversion function to convert the column to a literal. Something like substring(col1, 0) for string values or (col1 * 1) for numeric values.