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

Full table scan performed for DELETE with table having immutable indexes

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 4.13.0
    • None

    Description

      If a DELETE command is issued with a partial match for the leading part of the primary key, instead of using the data table, when the table has immutable indexes, a full scan will occur against the index.

      Attachments

        1. PHOENIX-4290_v3.patch
          103 kB
          James R. Taylor
        2. PHOENIX-4290_v2.patch
          103 kB
          James R. Taylor
        3. PHOENIX-4290_v1.patch
          102 kB
          James R. Taylor
        4. PHOENIX-4290_wip10.patch
          95 kB
          James R. Taylor
        5. PHOENIX-4290_wip9.patch
          95 kB
          James R. Taylor
        6. PHOENIX-4290_wip8.patch
          95 kB
          James R. Taylor
        7. PHOENIX-4290_wip7.patch
          89 kB
          James R. Taylor
        8. PHOENIX-4290_wip6.patch
          85 kB
          James R. Taylor
        9. PHOENIX-4290_wip5.patch
          78 kB
          James R. Taylor
        10. PHOENIX-4290_wip4.patch
          72 kB
          James R. Taylor
        11. PHOENIX-4290_wip3.patch
          72 kB
          James R. Taylor
        12. PHOENIX-4290_wip2.patch
          56 kB
          James R. Taylor
        13. PHOENIX-4290_wip1.patch
          57 kB
          James R. Taylor

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            jamestaylor James R. Taylor
            jamestaylor James R. Taylor
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment