[MDEV-28214] Incorrect Join Execution When Controlling BKA and BKAH Join Algorithms Created: 2022-04-02 Updated: 2023-04-27 |
|
| Status: | Confirmed |
| Project: | MariaDB Server |
| Component/s: | Optimizer |
| Affects Version/s: | 10.8.2, 10.2, 10.3, 10.4, 10.5, 10.6, 10.7, 10.8 |
| Fix Version/s: | 10.4, 10.5, 10.6 |
| Type: | Bug | Priority: | Major |
| Reporter: | Xiu Tang | Assignee: | Sergei Petrunia |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Description |
|
CREATE TABLE `t1` ( CREATE TABLE `t2` ( CREATE TABLE `t3` ( CREATE TABLE `t4` ( mysql> SELECT t3.c0 FROM t3 RIGHT OUTER JOIN t4 ON t3.c1 = t4.c1 JOIN t2 ON t2.c1 = t4.c1 CROSS JOIN t1;
------
------ mysql> SET optimizer_switch='join_cache_bka=off'; mysql> SELECT t3.c0 FROM t3 RIGHT OUTER JOIN t4 ON t3.c1 = t4.c1 JOIN t2 ON t2.c1 = t4.c1 CROSS JOIN t1; |
| Comments |
| Comment by Alice Sherepa [ 2022-04-08 ] |
|
Thank you for the report! |