[teiid-issues] [JBoss JIRA] (TEIID-2399) Rewriting And-Conjunction does not work properly

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: 7.7.1, 8.2 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.