]
Steven Hawkins resolved TEIID-3807.
-----------------------------------
Resolution: Done
Corrected the logic so that we conditionally change the result.
quantified comparison results dependent on null ordering
--------------------------------------------------------
Key: TEIID-3807
URL:
https://issues.jboss.org/browse/TEIID-3807
Project: Teiid
Issue Type: Bug
Components: Query Engine
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 8.13, 8.12.2
The handling of null and it's affect on the result is dependent upon it's
position in the the subquery result.
Specifically if null occurs before something that would otherwise evaluate to true for an
all comparison the result will be true and not the expected null. Or if null occurs
before something that would be otherwise false in a some comparison, then false will be
returned rather than the expected null.