Bug #120885 Test jdv.jdv_update failing with a result diff
Submitted: 7 Jul 6:00
Reporter: Laurynas Biveinis (OCA) Email Updates:
Status: Open Impact on me:
None 
Category:MySQL Server: Tests Severity:S7 (Test Cases)
Version:26.7.0-er OS:MacOS (26.5.2)
Assigned to: CPU Architecture:ARM

[7 Jul 6:00] Laurynas Biveinis 
Description:
$ ./mtr jdv.jdv_update
...
[ 50%] jdv.jdv_update                            [ fail ]
        Test ended at 2026-07-07 08:56:42

CURRENT_TEST: jdv.jdv_update
--- /Users/laurynas/vilniusdb/mysql-26.7.0-er/mysql-test/suite/jdv/r/jdv_update.result	2026-07-01 09:23:08
+++ /Users/laurynas/vilniusdb/mysql-26.7.0-er/_build-debug/mysql-test/var/log/jdv_update.reject	2026-07-07 08:56:41
@@ -1704,7 +1704,7 @@
 );
 SELECT * FROM course_dv;
 data
-{"_id": 1, "zip": "22602", "city": "Winchester", "name": "Rock Harbor Golf Course - Boulder Course", "phone": "(540) 722-7111", "state": "VA", "abbrev": "RHB", "address": "365 Rock Harbor Drive", "address2": null, "_metadata": {"etag": "b262d99e8bb2a75ede3248c9ddae58a6"}, "holeGroups": [{"id": 1, "name": "Front Nine", "holes": [{"id": 10, "par": 5, "number": 9, "handicap": 11, "hole_group_id": 1}, {"id": 11, "par": 3, "number": 8, "handicap": 3, "hole_group_id": 1}, {"id": 12, "par": 4, "number": 7, "handicap": 9, "hole_group_id": 1}, {"id": 13, "par": 5, "number": 6, "handicap": 1, "hole_group_id": 1}, {"id": 14, "par": 3, "number": 5, "handicap": 13, "hole_group_id": 1}, {"id": 15, "par": 5, "number": 4, "handicap": 17, "hole_group_id": 1}, {"id": 16, "par": 4, "number": 3, "handicap": 7, "hole_group_id": 1}, {"id": 17, "par": 3, "number": 2, "handicap": 5, "hole_group_id": 1}, {"id": 18, "par": 4, "number": 1, "handicap": 15, "hole_group_id": 1}], "slope": 136.00, "rating": 35.15, "course_id": 1, "sort_order": 1}, {"id": 2, "name": "Back Nine", "holes": [{"id": 1, "par": 5, "number": 18, "handicap": 10, "hole_group_id": 2}, {"id": 2, "par": 3, "number": 17, "handicap": 12, "hole_group_id": 2}, {"id": 3, "par": 5, "number": 16, "handicap": 6, "hole_group_id": 2}, {"id": 4, "par": 4, "number": 15, "handicap": 2, "hole_group_id": 2}, {"id": 5, "par": 4, "number": 14, "handicap": 8, "hole_group_id": 2}, {"id": 6, "par": 3, "number": 13, "handicap": 14, "hole_group_id": 2}, {"id": 7, "par": 4, "number": 12, "handicap": 16, "hole_group_id": 2}, {"id": 8, "par": 3, "number": 11, "handicap": 18, "hole_group_id": 2}, {"id": 9, "par": 5, "number": 10, "handicap": 4, "hole_group_id": 2}], "slope": 136.00, "rating": 35.15, "course_id": 1, "sort_order": 2}]}
+{"_id": 1, "zip": "22602", "city": "Winchester", "name": "Rock Harbor Golf Course - Boulder Course", "phone": "(540) 722-7111", "state": "VA", "abbrev": "RHB", "address": "365 Rock Harbor Drive", "address2": null, "_metadata": {"etag": "fba9304401ad026c918ad8b005b90f04"}, "holeGroups": [{"id": 1, "name": "Front Nine", "holes": [{"id": 1, "par": 4, "number": 1, "handicap": 15, "hole_group_id": 1}, {"id": 2, "par": 3, "number": 2, "handicap": 5, "hole_group_id": 1}, {"id": 3, "par": 4, "number": 3, "handicap": 7, "hole_group_id": 1}, {"id": 4, "par": 5, "number": 4, "handicap": 17, "hole_group_id": 1}, {"id": 5, "par": 3, "number": 5, "handicap": 13, "hole_group_id": 1}, {"id": 6, "par": 5, "number": 6, "handicap": 1, "hole_group_id": 1}, {"id": 7, "par": 4, "number": 7, "handicap": 9, "hole_group_id": 1}, {"id": 8, "par": 3, "number": 8, "handicap": 3, "hole_group_id": 1}, {"id": 9, "par": 5, "number": 9, "handicap": 11, "hole_group_id": 1}], "slope": 136.00, "rating": 35.15, "course_id": 1, "sort_order": 1}, {"id": 2, "name": "Back Nine", "holes": [{"id": 10, "par": 5, "number": 10, "handicap": 4, "hole_group_id": 2}, {"id": 11, "par": 3, "number": 11, "handicap": 18, "hole_group_id": 2}, {"id": 12, "par": 4, "number": 12, "handicap": 16, "hole_group_id": 2}, {"id": 13, "par": 3, "number": 13, "handicap": 14, "hole_group_id": 2}, {"id": 14, "par": 4, "number": 14, "handicap": 8, "hole_group_id": 2}, {"id": 15, "par": 4, "number": 15, "handicap": 2, "hole_group_id": 2}, {"id": 16, "par": 5, "number": 16, "handicap": 6, "hole_group_id": 2}, {"id": 17, "par": 3, "number": 17, "handicap": 12, "hole_group_id": 2}, {"id": 18, "par": 5, "number": 18, "handicap": 10, "hole_group_id": 2}], "slope": 136.00, "rating": 35.15, "course_id": 1, "sort_order": 2}]}
 SELECT * FROM course;
 id	name	address	address2	city	state	zip	phone	abbrev
 1	Rock Harbor Golf Course - Boulder Course	365 Rock Harbor Drive	NULL	Winchester	VA	22602	(540) 722-7111	RHB
@@ -1714,24 +1714,24 @@
 2	Back Nine	2	136.00	35.15	1
 SELECT * FROM hole;
 id	number	handicap	par	hole_group_id
-1	18	10	5	2
-2	17	12	3	2
-3	16	6	5	2
-4	15	2	4	2
-5	14	8	4	2
-6	13	14	3	2
-7	12	16	4	2
-8	11	18	3	2
-9	10	4	5	2
-10	9	11	5	1
-11	8	3	3	1
-12	7	9	4	1
-13	6	1	5	1
-14	5	13	3	1
-15	4	17	5	1
-16	3	7	4	1
-17	2	5	3	1
-18	1	15	4	1
+1	1	15	4	1
+2	2	5	3	1
+3	3	7	4	1
+4	4	17	5	1
+5	5	13	3	1
+6	6	1	5	1
+7	7	9	4	1
+8	8	3	3	1
+9	9	11	5	1
+10	10	4	5	2
+11	11	18	3	2
+12	12	16	4	2
+13	13	14	3	2
+14	14	8	4	2
+15	15	2	4	2
+16	16	6	5	2
+17	17	12	3	2
+18	18	10	5	2
 # Note that only the base table course is actually being updated here.
 # None of the hole_groups or holes in the new value actually exists,
 # so all existing rows in hole_group and hole will be deleted and

mysqltest: Result content mismatch

How to repeat:
See above. I have used debug build