Equivalence expressions in where clauses between two columns are ignored. ------------------------------------------------------------------------- Key: TEIID-68 URL: https://issues.jboss.org/browse/TEIID-68 Project: Teiid Issue Type: Bug Components: XML Connector Affects Versions: 9.x Reporter: Steven Hawkins Priority: Optional 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.