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

main.func_xxh fails under --view-protocol

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 13.1.1
    • 13.1.1
    • Tests, MTR
    • None
    • Not for Release Notes
    • Q3/2026 Server Maintenance

    Description

      MDEV-38180 introduced xxh32() and xxh3() SQL functions.
      Cross Reference reported a failure of main.func_xxh under --view-protocol.

      Can be reproduced with the HEAD of main.
      The bug is present in both a Debug / RelWithDebInfo server configuration.

                            main.func_xxh                            w1 [ fail ]
              Test ended at 2026-06-17 06:45:15
       
      CURRENT_TEST: main.func_xxh
      --- /home/buildbot/x86-debian-12-fulltest-debug/build/mysql-test/main/func_xxh.result	2026-06-17 04:45:12.000000000 +0000
      +++ /home/buildbot/x86-debian-12-fulltest-debug/build/mysql-test/main/func_xxh.reject	2026-06-17 06:45:14.974259653 +0000
      @@ -117,11 +117,11 @@
       ## 8. Charset conversion
       SET NAMES utf8mb4;
       SELECT XXH32(CONVERT('café' USING utf8mb4));
      -XXH32(CONVERT('café' USING utf8mb4))
      -1341024521
      +XXH32(CONVERT('café' USING utf8mb4))
      +1615442311
       SELECT XXH32(CONVERT('café' USING latin1));
      -XXH32(CONVERT('café' USING latin1))
      -2242119311
      +XXH32(CONVERT('café' USING latin1))
      +1296415314
       ## 9. Reject non-string types
       SELECT XXH32(1);
       ERROR HY000: Illegal parameter data type int for operation 'XXH32'
      @@ -167,14 +167,13 @@
       alpha	1378942857	12739993147785832021
       SELECT * FROM t_gen WHERE h3s = XXH3('alpha');
       d	h32v	h3s
      -alpha	1378942857	12739993147785832021
       DROP TABLE t_gen;
       ## 13. Stored function wrapping XXH
       CREATE OR REPLACE FUNCTION fxh32(s VARCHAR(255)) RETURNS INT UNSIGNED DETERMINISTIC RETURN XXH32(s);
       CREATE OR REPLACE FUNCTION fxh3(s VARCHAR(255)) RETURNS BIGINT UNSIGNED DETERMINISTIC RETURN XXH3(s);
       SELECT fxh32('abc') = XXH32('abc'), fxh3('abc') = XXH3('abc');
       fxh32('abc') = XXH32('abc')	fxh3('abc') = XXH3('abc')
      -1	1
      +0	0
       DROP FUNCTION fxh32;
       DROP FUNCTION fxh3;
       ## 14. Prepared statement with user var
       
      Result length mismatch
       
       - saving '/home/buildbot/x86-debian-12-fulltest-debug/build/mysql-test/var/1/log/main.func_xxh/' to '/home/buildbot/x86-debian-12-fulltest-debug/build/mysql-test/var/log/main.func_xxh/'
       
      Retrying test main.func_xxh, attempt(2/3)...
      

      Attachments

        Issue Links

          Activity

            People

              danblack Daniel Black
              rvarzaru Varzaru Razvan-Liviu
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - 1.65d
                  1.65d
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 1h 20m Time Not Required
                  1h 20m

                  Git Integration

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