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

Plan with join removal returns unexpected values

    XMLWordPrintable

    Details

    • Sprint:
      DV Sprint 66
    • Story Points:
      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

            Assignee:
            shawkins Steven Hawkins
            Reporter:
            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