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

Allow packed keys and packed values of non-sorted fields in the sort buffer

Details

    • Task
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • N/A
    • Optimizer
    • None

    Description

      This task will allow to have packed keys and packed values of non-sorted fields in the sort buffer.
      It will incorporate the code of wl 1509 from mysql-5.7 that implemented packed values of non-sorted fields in the sort buffer.
      Packed keys in sort buffer will help greatly to resolve the problem of
      mdev-6529.

      Attachments

        Issue Links

          blocks

          New Feature - A new feature of the product, which has yet to be developed. MDEV-6529 optimize VARCHAR temp storage during EITS ANALYZE

          • Critical - Crashes, loss of data, severe memory leak.
          • Stalled
          includes

          Technical task - A technical task. MDEV-21263 Allow packed values of non-sorted fields in the sort buffer

          • Major - Major loss of function.
          • Closed

          Technical task - A technical task. MDEV-21580 Allow packed sort keys in sort buffer

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-21772 Testing for packed sort keys and packed addon fields

          • Major - Major loss of function.
          • Closed
          relates to

          Task - A task that needs to be done. MDEV-21838 Add information about packed addon fields in ANALYZE FORMAT=JSON

          • Major - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. MDEV-21829 Use packed sort keys in Unique objects

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21922 Allow packing addon fields even if they don't honour max_length_for_sort_data

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            psergei Sergei Petrunia added a comment -

            Added estimate as discussed

            psergei Sergei Petrunia added a comment - Added estimate as discussed
            varun Varun Gupta (Inactive) added a comment -

            Patch
            http://lists.askmonty.org/pipermail/commits/2019-December/014080.html

            varun Varun Gupta (Inactive) added a comment - Patch http://lists.askmonty.org/pipermail/commits/2019-December/014080.html
            varun Varun Gupta (Inactive) added a comment -

            A big test case is required to test the feature.
            Here is the patch for it
            http://lists.askmonty.org/pipermail/commits/2020-January/014120.html

            varun Varun Gupta (Inactive) added a comment - A big test case is required to test the feature. Here is the patch for it http://lists.askmonty.org/pipermail/commits/2020-January/014120.html
            igor Igor Babaev (Inactive) added a comment -

            Review is needed only for subtasks

            igor Igor Babaev (Inactive) added a comment - Review is needed only for subtasks
            varun Varun Gupta (Inactive) added a comment -

            The task is completed by the sub tasks MDEV-21263 and MDEV-21580

            varun Varun Gupta (Inactive) added a comment - The task is completed by the sub tasks MDEV-21263 and MDEV-21580

            People

              varun Varun Gupta (Inactive)
              igor Igor Babaev (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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