- 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);
- JBoss Enterprise Data Services (JBEDS) 5.3.1
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.