[teiid-issues] [JBoss JIRA] (TEIID-2592) Parsing error

[Simon Green (JIRA)]

Simon Green created TEIID-2592:
----------------------------------

             Summary: 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.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira