[teiid-issues] [JBoss JIRA] (TEIID-2473) WHERE clause with contradicting condition should return no rows
Steven Hawkins (JIRA)
jira-events at lists.jboss.org
Tue Apr 16 11:38:54 EDT 2013
[ https://issues.jboss.org/browse/TEIID-2473?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steven Hawkins resolved TEIID-2473.
-----------------------------------
Resolution: Duplicate Issue
Duplicate of TEIID-2366
> 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
More information about the teiid-issues
mailing list