[MDEV-22450] Possible Range plan is not used with nested outer joins. Created: 2020-05-04  Updated: 2023-12-05

Status: Stalled
Project: MariaDB Server
Component/s: Optimizer
Affects Version/s: 10.4.12
Fix Version/s: 10.4

Type: Bug Priority: Major
Reporter: Sergei Petrunia Assignee: Sergei Petrunia
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-21383 Possible range plan is not used under... Closed

 Description   

MDEV-21383 fixed the issue with possible range plans not being used for inner joins.

Now, I am observing a similar issue for nested outer joins.

(I can't attach a testcase, because I don't have it atm. I have customer table DDLs and optimizer_trace. I've made a patch which fakes the optimizer stats and records_in_range() return values, and then I can see a bad query plan to be generated).

Checking my testcase against other server versions:

 Comments   
Comment by Julien Fritsch [ 2023-12-05 ]

Automated message:
----------------------------
Since this issue has not been updated since 6 weeks, it's time to move it back to Stalled.

Comment by JiraAutomate [ 2023-12-05 ]

Automated message:
----------------------------
Since this issue has not been updated since 6 weeks, it's time to move it back to Stalled.

Generated at Thu Feb 08 09:14:49 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.