[teiid-issues] [JBoss JIRA] (TEIID-2473) WHERE clause with contradicting condition should return no rows

[Jeff Hayes (JIRA)]

Jeff Hayes created TEIID-2473:
---------------------------------

             Summary: WHERE clause with contradicting condition should return no rows
                 Key: TEIID-2473
                 URL: https://issues.jboss.org/browse/TEIID-2473
             Project: Teiid
          Issue Type: Feature Request
          Components: Query Engine
    Affects Versions: 8.1
         Environment: JZOS mainframe
            Reporter: Jeff Hayes
            Assignee: Steven Hawkins
            Priority: Minor


Using Eclipse datasource explorer with teiid connection using SHOWPLAN to demonstrate the problem. 

Enter: SELECT * FROM SECURITY.SYSINFO WHERE SYSID = 'DE29 AND SYSID <> 'DE29'

USER COMMAND appears as: SELECT * FROM SECURITY.SYSINFO WHERE SYSID = 'DE29

Apparently conflicting "AND SYSID <> 'DE29'" is dropped and I get results from SYSID = 'DE29'.

Enter: SELECT * FROM SECURITY.SYSINFO WHERE SYSID <> 'DE29' AND SYSID = 'DE29'

USER COMMAND appears as: SELECT * FROM SECURITY.SYSINFO WHERE 1 = 0

And I get expected null result set. 

Admittedly irrational query but it should give empty result set however you order the WHERE clause conditions. 
 

--
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