Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-22399

Remove multiple calls to enable and disable Handler::keyread and perform it after the plan refinement phase is done

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 10.5.4
    • Component/s: Optimizer
    • Labels:
      None

      Description

      Monty mentioned

      Find a solution for test_if_skip_sort_order() and key_reads. The problem is that we set key_read for indexes early and then test_if_skip_sort_order() have to delete old ones and in some cases add new ones. It would be better if the optimizer didn't enable key reads until after all indexes have been decided and can't be changed anymore.

      So the idea is to let all the plan refinements happen and all then enable the keyread for indexes.

        Attachments

          Activity

            People

            Assignee:
            varun Varun Gupta
            Reporter:
            varun Varun Gupta
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: