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

Plan with join removal returns unexpected values

    XMLWordPrintable

Details

    • DV Sprint 66
    • 0.5

    Description

      In testing TEIIDSB-213 I can see that a query such as:

      select a1.id from Account a1 inner join account a2 on a1.parentid = a2.id

      actually returns results, but no are expected.

      Whereas

      select a1.id from Account a1 where a1.parentid is not null

      returns no results as expected

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            rhn-engineering-shawkins Steven Hawkins
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - 4 hours
                4h
                Remaining:
                Time Spent - 3 hours Remaining Estimate - 1 hour
                1h
                Logged:
                Time Spent - 3 hours Remaining Estimate - 1 hour
                3h