Hisanobu Okuda created TEIID-2399: ------------------------------------- Summary: Rewriting And-Conjunction does not work properly Key: TEIID-2399 URL: https://issues.jboss.org/browse/TEIID-2399 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 8.2, 7.7.1 Environment: EDS 5.3.0 Reporter: Hisanobu Okuda Assignee: Steven Hawkins The following query should return no row, but returns 1 row actually. {code} select * from (select 1 f1) x where x.f1 = 1 and x.f1 != 1; {code} The Query Processor rewrites the criteria to x.f1 = 1. The following query should return 1 row, but returns no row actually. {code} select * from (select 1 f1) x where x.f1 = 1 and x.f1 < 2; {code} The Query Processor rewrites the criteria to 1 = 0. -- 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