[MDEV-26965] Left join to derived table on multiple clauses with aggregation returns missing/incorrect results - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 10.6.4, 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL)
Fix Version/s: 10.3.33, 10.4.23, 10.5.14, 10.6.6, 10.7.2
Component/s: Optimizer
Labels:
- optimizer
- regression
Environment:
Ubuntu Focal

Description

I couldn't work out how to reopen an issue, so sorry for making a new one.

The problem in ~~MDEV-25714~~ and ~~MDEV-21614~~ seems to be back in 10.6.4 (we recently upgraded from 10.5.6).

Using `SET optimizer_switch="split_materialized=off";` fixes the problem, so this is our temporary work-around.

Thanks for your help.

Attachments

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

dataset.sql
2 kB
2022-01-06 11:25
screenshot-1.png
13 kB
2022-01-06 11:17
screenshot-2.png
65 kB
2022-01-06 11:17
screenshot-3.png
9 kB
2022-01-06 11:18
screenshot-4.png
56 kB
2022-01-06 11:19

Issue Links

duplicates

MDEV-27132 Wrong result from query when using split optimization

Closed

relates to

MDEV-27132 Wrong result from query when using split optimization

Closed

MDEV-27510 Query returns wrong result when using split optimization

Closed

Activity

People

Assignee:: Alice Sherepa

Reporter:: Luke Cousins

Votes:: 4 Vote for this issue

Watchers:: 8 Start watching this issue

Dates

Created:: 2021-11-03 11:25

Updated:: 2022-02-01 08:13

Resolved:: 2022-01-31 18:20

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.