Bug #116391 Test main.opt_hints_join_order_hypergraph failing with a result diff

• Submitted: 17 Oct 12:14
• Modified: 6 Nov 12:56
• Reporter: Laurynas Biveinis (OCA)
• Status: Closed
• Category: MySQL Server: Tests
• Severity: S7 (Test Cases)
• Version: 9.1.0
• OS: MacOS (15.0.1)
• CPU Architecture: ARM

[17 Oct 12:14] Laurynas Biveinis

Description:
./mtr main.opt_hints_join_order_hypergraph
...
[ 50%] main.opt_hints_join_order_hypergraph      [ fail ]
        Test ended at 2024-10-17 15:13:33

CURRENT_TEST: main.opt_hints_join_order_hypergraph
--- /Users/laurynas/vilniusdb/mysql-9.1.0/mysql-test/r/opt_hints_join_order_hypergraph.result	2024-10-15 13:25:42
+++ /Users/laurynas/vilniusdb/mysql-9.1.0/_build-debug/mysql-test/var/log/opt_hints_join_order_hypergraph.reject	2024-10-17 15:13:33
@@ -1257,21 +1257,21 @@
 -> Inner hash join (alias10.f1 = alias11.f1)  (rows=1)
     -> Table scan on alias10  (rows=1)
     -> Hash
-        -> Inner hash join (cast(alias4.f2 as double) = cast(alias11.f2 as double))  (rows=1)
-            -> Left hash join (alias4.f2 = alias5.f2)  (rows=1)
+        -> Left hash join (alias4.f2 = alias5.f2)  (rows=1)
+            -> Inner hash join (cast(alias4.f2 as double) = cast(alias11.f2 as double))  (rows=1)
                 -> Table scan on alias4  (rows=1)
                 -> Hash
-                    -> Left hash join (alias5.f1 = alias8.f2)  (rows=1)
-                        -> Inner hash join (alias5.f2 = alias6.f1)  (rows=1)
-                            -> Table scan on alias5  (rows=1)
-                            -> Hash
-                                -> Table scan on alias6  (rows=1)
+                    -> Table scan on alias11  (rows=1)
+            -> Hash
+                -> Left hash join (alias5.f1 = alias8.f2)  (rows=1)
+                    -> Inner hash join (alias5.f2 = alias6.f1)  (rows=1)
+                        -> Table scan on alias5  (rows=1)
                         -> Hash
-                            -> Inner hash join (<hash>(alias7.f1)=<hash>(alias8.f1)), extra conditions: (alias7.f1 = alias8.f1)  (rows=1)
-                                -> Table scan on alias7  (rows=1)
-                                -> Hash
-                                    -> Table scan on alias8  (rows=1)
-            -> Hash
-                -> Table scan on alias11  (rows=1)
+                            -> Table scan on alias6  (rows=1)
+                    -> Hash
+                        -> Inner hash join (<hash>(alias7.f1)=<hash>(alias8.f1)), extra conditions: (alias7.f1 = alias8.f1)  (rows=1)
+                            -> Table scan on alias7  (rows=1)
+                            -> Hash
+                                -> Table scan on alias8  (rows=1)
 
 DROP TABLES t2, t4, t5, t6, t7, t10, t11;

mysqltest: Result content mismatch

How to repeat:
See above

[17 Oct 12:58] MySQL Verification Team

Hello Laurynas,

Thank you for the report and feedback!

regards,
Umesh

[6 Nov 12:56] Jon Stephens

Fixed in MySQL 9.2.0.

Testing/HG only--no changelog entry needed.

Closed.