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

IndexTool incorrectly uses index when rebuilding an active index

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Resolved
    • 4.14.0
    • 4.14.1, 5.1.0
    • None
    • None

    Description

      If you want to leave an index active while rebuilding (e.g. an immutable index), the IndexTool selects from the index table instead of the data table.
      This is because it uses PostIndexDDLCompiler which builds an UpsertSelect statement with a NO_INDEX hint, but the IndexTool only uses the Select portion which has no hint.

      Attachments

        Activity

          People

            vincentpoon Vincent Poon
            vincentpoon Vincent Poon
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: