Parsing error ------------- Key: TEIID-2592 URL: https://issues.jboss.org/browse/TEIID-2592 Project: Teiid Issue Type: Bug Environment: psql (8.4.13, server 8.1.4) Reporter: Simon Green Assignee: Steven Hawkins Using EngVDBR, I tried the following query, and received an error EngVDBR=> SELECT name FROM Bugzilla.products WHERE classification_id = 5 AND id NOT IN (SELECT product_id FROM Bugzilla.milestones WHERE value != '---');ERROR: Parsing error: Encountered "SELECT product_id FROM Bugzilla.milestones WHERE value" at line 1, column 79. However, the following query worked as expected: SELECT name FROM Bugzilla.products WHERE classification_id = 5 AND id NOT IN (SELECT product_id FROM Bugzilla.milestones WHERE milestones.value != '---'); The first query is valid, and thus I think it is a bug in TEIID.