Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
13.1.1
-
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
- blocks
-
MDBF-1201 add --view tests to branch protection
-
- Closed
-
- is caused by
-
MDEV-38180 Add XXH hash function
-
- Closed
-