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

Add XXH hash function

    XMLWordPrintable

Details

    • Hide
      Add XXH32() and XXH3() SQL functions for the XXH hash algorithms

      Contribution by monthdev
      Show
      Add XXH32() and XXH3() SQL functions for the XXH hash algorithms Contribution by monthdev
    • Q2/2026 Server Maintenance, Q2/2026 Server Development, Q3/2026 Server Maintenance

    Description

      MDEV-9826 adds some xxh use in the server, now we can add an sql function, same as md5 and others

      After discussion with the team (bar,serg,ycp), we decided to go with the following function signatures:

      XXH32(expr) --> INT UNSIGNED
      		 
      XXH3(expr) --> BIGINT UNSIGNED
      		 
      XXH64(expr) --> BIGINT UNSIGNED (will be done in a spearate task)
      		 
      XXH128(expr) --> BINARY(16)    (will be done in a separate task)

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-39661 LSAN Detectable memory leak in XXH_malloc upon SHUTDOWN

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-40043 Assertion `s' failed in my_uca_hash_sort_utf8mb4 on SELECT XXH32(REGEXP_REPLACE...)

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-40142 main.func_xxh fails under --view-protocol

          • Major - Major loss of function.
          • Closed
          is blocked by

          New Feature - A new feature of the product, which has yet to be developed. MDEV-9826 better hash algorithms for PARTITION BY KEY

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

          Task - A task that needs to be done. MDEV-27208 Implement 2-ary CRC32() and the CRC32C() function

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. MDEV-9826 better hash algorithms for PARTITION BY KEY

          • Major - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. MDEV-32016 change the hash used for hash unique

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-40040 MDEV-39661 fix introduces silent data corruption/NULL-correctness regression

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          has action item

          DOCS-6169 Loading...

          Activity

            People

              ycp Yuchen Pei
              nikitamalyavin Nikita Malyavin
              Alexander Barkov Alexander Barkov
              Roel Van de Paar Roel Van de Paar
              Votes:
              0 Vote for this issue
              Watchers:
              10 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - 0d
                  0d
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 4d 55m
                  4d 55m

                  Git Integration

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