Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-1533

Last key part not taken into child/parent optimization

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 3.0.0, 4.0.0
    • 4.3.0, 3.3.0
    • None
    • None

    Description

      For example we have multiple PK columns (pk0, pk1, pk2) for table A, if we do a IN subquery or join query with all PK columns, like:

      select * from A where (pk0, pk1, pk2) IN (select pk0, pk1, pk2 from B);

      The child/parent join optimization is supposed to use the entire PK "(pk0, pk1, pk2)" for constructing the dynamic skip-scan filter.
      However it would only use (pk0, pk1) instead, missing the last PK part.

      Attachments

        1. 1533.patch
          7 kB
          Wei Xue

        Activity

          People

            maryannxue Wei Xue
            maryannxue Wei Xue
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - 72h
                72h
                Remaining:
                Remaining Estimate - 72h
                72h
                Logged:
                Time Spent - Not Specified
                Not Specified