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

MySQL 8-style optimizer hints: milestone 2: index hints

Details

    • New Feature
    • Status: Open (View Workflow)
    • Critical
    • Resolution: Unresolved
    • None
    • Optimizer
    • None

    Description

      Implement needed hints that were not implemented in

      or not handled separately:

      • DERIVED_CONDITION_PUSHDOWN, NO_DERIVED_CONDITION_PUSHDOWN - Moved into MDEV-36106.
      • MERGE, NO_MERGE - Moved into MDEV-36106

      What remains are index usage control hints:

      • ORDER_INDEX, NO_ORDER_INDEX
      • GROUP_INDEX, NO_GROUP_INDEX
      • JOIN_INDEX, NO_JOIN_INDEX
      • INDEX, NO_INDEX

      Attachments

        Issue Links

          is part of

          Task - A task that needs to be done. MDEV-28906 MySQL 8.0 desired compatibility

          • Major - Major loss of function.
          • Open
          split from

          Epic - Created by Jira Software - do not edit or delete. Issue type for a big user story that needs to be broken down. MDEV-33281 Implement optimizer hints like in MySQL 8

          • Critical - Crashes, loss of data, severe memory leak.
          • In Progress

          Activity

            Ascending order - Click to sort in descending order
            psergei Sergei Petrunia created issue -
            psergei Sergei Petrunia made changes -
            Field Original Value New Value
            ralf.gebhardt Ralf Gebhardt made changes -
            Issue Type Task [ 3 ] New Feature [ 2 ]
            julien.fritsch Julien Fritsch made changes -
            julien.fritsch Julien Fritsch made changes -
            julien.fritsch Julien Fritsch made changes -
            Priority Major [ 3 ] Critical [ 2 ]
            psergei Sergei Petrunia made changes -
            Description Implement needed hints that were not implemented in
            * Milestone 1 - BKA, MRR, ICP (MDEV-35504)
            * Join order hints (MDEV-34870 )
            * Subquery hints (MDEV-34888).

            Tentative list:
            * ORDER_INDEX, NO_ORDER_INDEX
            * GROUP_INDEX, NO_GROUP_INDEX
            * JOIN_INDEX, NO_JOIN_INDEX
            * INDEX, NO_INDEX
            * DERIVED_CONDITION_PUSHDOWN, NO_DERIVED_CONDITION_PUSHDOWN
            * MERGE, NO_MERGE
            		Implement needed hints that were not implemented in
            * Milestone 1 - BKA, MRR, ICP (MDEV-35504)
            * Join order hints (MDEV-34870 )
            * Subquery hints (MDEV-34888).

            These are index hints:
            * ORDER_INDEX, NO_ORDER_INDEX
            * GROUP_INDEX, NO_GROUP_INDEX
            * JOIN_INDEX, NO_JOIN_INDEX
            * INDEX, NO_INDEX

            * DERIVED_CONDITION_PUSHDOWN, NO_DERIVED_CONDITION_PUSHDOWN - Moved into MDEV-36106.
            * MERGE, NO_MERGE - Moved into MDEV-36106
            psergei Sergei Petrunia made changes -
            Description Implement needed hints that were not implemented in
            * Milestone 1 - BKA, MRR, ICP (MDEV-35504)
            * Join order hints (MDEV-34870 )
            * Subquery hints (MDEV-34888).

            These are index hints:
            * ORDER_INDEX, NO_ORDER_INDEX
            * GROUP_INDEX, NO_GROUP_INDEX
            * JOIN_INDEX, NO_JOIN_INDEX
            * INDEX, NO_INDEX

            * DERIVED_CONDITION_PUSHDOWN, NO_DERIVED_CONDITION_PUSHDOWN - Moved into MDEV-36106.
            * MERGE, NO_MERGE - Moved into MDEV-36106
            		Implement needed hints that were not implemented in
            * Milestone 1 - BKA, MRR, ICP (MDEV-35504)
            * Join order hints (MDEV-34870 )
            * Subquery hints (MDEV-34888).

            or not handled separately:
            * DERIVED_CONDITION_PUSHDOWN, NO_DERIVED_CONDITION_PUSHDOWN - Moved into MDEV-36106.
            * MERGE, NO_MERGE - Moved into MDEV-36106

            What remains are index usage control hints:
            * ORDER_INDEX, NO_ORDER_INDEX
            * GROUP_INDEX, NO_GROUP_INDEX
            * JOIN_INDEX, NO_JOIN_INDEX
            * INDEX, NO_INDEX

            psergei Sergei Petrunia made changes -
            Summary MySQL 8-style optimizer hints: milestone 2 MySQL 8-style optimizer hints: ms2: index hints
            serg Sergei Golubchik made changes -
            Fix Version/s 12.1 [ 29992 ]
            Fix Version/s 12.0 [ 29945 ]
            danblack Daniel Black made changes -
            adamluciano Adam Luciano made changes -
            Fix Version/s 12.1 [ 29992 ]
            julien.fritsch Julien Fritsch made changes -
            Summary MySQL 8-style optimizer hints: ms2: index hints MySQL 8-style optimizer hints: milestone 2: index hints

            People

              oleg.smirnov Oleg Smirnov
              psergei Sergei Petrunia
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.