Details
-
Bug
-
Status: In Testing (View Workflow)
-
Major
-
Resolution: Unresolved
-
11.4.9, 11.8.4
-
None
-
Gentoo
Description
main.func_json test fails in Gentoo test environment with following error:
main.func_json w2 [ fail ]
|
Test ended at 2025-11-07 14:32:19
|
|
|
CURRENT_TEST: main.func_json
|
--- /var/tmp/portage/dev-db/mariadb-11.4.9/work/mysql/mysql-test/main/func_json.result 2025-11-04 12:57:48.000000000 -0000
|
+++ /var/tmp/portage/dev-db/mariadb-11.4.9/work/mysql/mysql-test/main/func_json.reject 2025-11-07 14:32:19.506463192 -0000
|
@@ -5364,7 +5364,6 @@
|
[["2", "6"], ["3", "8"], ["4", "5"], ["1", "7"]]
|
[["2", "6"], ["3", "8"], ["4", "5"], ["1", "7"]]
|
[["2", "6"], ["3", "8"], ["4", "5"], ["1", "7"]]
|
-[["2", "6"], ["3", "8"], ["4", "5"], ["1", "7"]]
|
SELECT ( WITH x AS ( WITH x ( x ) AS ( SELECT ( 1.000000 ) ) SELECT x FROM x ) SELECT * FROM x WHERE ( SELECT AVG ( x ) OVER ( ORDER BY JSON_ARRAY_INTERSECT ( '[["1", "7"], ["2", "6"], ["3", "8"]]' , '[["2","6"],["3","8"],["4","5"],["1","
|
7"]]' ) ) FROM x ) ) as result;
|
result
|
1.000000
|
@@ -5376,6 +5375,5 @@
|
[["2", "6"], ["3", "8"], ["4", "5"], ["1", "7"]]
|
[["2", "6"], ["3", "8"], ["4", "5"], ["1", "7"]]
|
[["2", "6"], ["3", "8"], ["4", "5"], ["1", "7"]]
|
-[["2", "6"], ["3", "8"], ["4", "5"], ["1", "7"]]
|
[["2", "6"], ["3", "8"], ["4", "5"], ["1", "7"]]
|
# End of 11.4 Test
|
|
|
Result length mismatch
|
|
|
- saving '/var/tmp/portage/dev-db/mariadb-11.4.9/temp/var-tests/2/log/main.func_json/' to '/var/tmp/portage/dev-db/mariadb-11.4.9/temp/var-tests/log/main.func_json/'
|
Gentoo sandbox contains only lo interface, therefore, mysql.user contains only 4 rows, the 5th one for eth0 or similar interface is missing.