Incorrect query rewrite in JBEDS
Issue
- The following example query returns 1 record, when in fact it should return zero records.
select * from (select 1 f1 union all select 2 f1 ) x
where x.f1 in (1) and x.f1 not in (1);
Environment
- JBoss Enterprise Data Services (JBEDS) 5.3.1
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.