Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-3807

quantified comparison results dependent on null ordering

    Details

      Description

      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.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                shawkins Steven Hawkins
                Reporter:
                shawkins Steven Hawkins
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: