Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-4580

Extent's approximate range keeping for dictionaries

    XMLWordPrintable

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • 23.10
    • None
    • 2021-4, 2021-5, 2021-6, 2021-7, 2021-8, 2021-9, 2021-10, 2021-11, 2021-12, 2021-13, 2021-14, 2021-15, 2021-16, 2021-17, 2022-22, 2022-23, 2023-4, 2023-5, 2023-6, 2023-7, 2023-8, 2023-10, 2023-11, 2023-12, 2024-1

    Description

      Following the ideas from the design document, we may add extent range information for dictionaries.

      Token columns are, essentially, 8-byte-wide unsigned integers. They can be tracked just like other integer columns in extentmap. But instead of tracking values of tokens we will track values of prefixes of corresponding dictionary strings, with collation applied.

      I will add more precise plan to comments below.

      Attachments

        Issue Links

          blocks

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4522 calGetTrace shows double LIO from Community 5.4.1 to Enterprise 5.5.1

          • Major - Major loss of function.
          • Closed
          causes

          Bug - A problem which impairs or prevents the functions of the product. MCOL-5346 Excessive log messages converting NULL VARCHAR into INT

          • Major - Major loss of function.
          • Closed
          duplicates

          New Feature - A new feature of the product, which has yet to be developed. MCOL-1090 Extent Elimination for char/varchar columns larger than 8 bytes

          • Major - Major loss of function.
          • Closed
          includes

          Task - A task that needs to be done. MCOL-4529 Design the proper way of doing extent elimination on varchars with utf8 or utf8mb4

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          is blocked by

          New Feature - A new feature of the product, which has yet to be developed. MCOL-5005 Add charset number to system catalog

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

          Task - A task that needs to be done. MCOL-5705 Extent elimination should work for CHAR(n)/VARCHAR(n) where n > 8

          • Major - Major loss of function.
          • Stalled

          Task - A task that needs to be done. MCOL-5714 TEXT column extent elimination should cover WHERE...LIKE clauses

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Task - A task that needs to be done. MCOL-5757 INSERT is not updating extent ranges

          • Major - Major loss of function.
          • Open

          Activity

            People

              sergey.zefirov Sergey Zefirov
              sergey.zefirov Sergey Zefirov
              Roman Roman
              Kirill Perov Kirill Perov (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.