Incorrect query rewrite in JBEDS

Solution Verified - Updated -

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 of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In