[MDEV-29382] Query returns wrong number of records - Jira

XML

Word

Printable

Details

Type: Bug
Status: Stalled (View Workflow)
Priority: Major
Resolution: Unresolved
Affects Version/s: 10.4.26, 10.8.4, 10.9.2, 10.6(EOL), 10.7(EOL), 10.8(EOL), 10.9(EOL)
Fix Version/s: 10.11
Component/s: None
Labels:
None
Environment:
dockerized instances from https://hub.docker.com/_/mariadb

Description

Attached query started to return wrong number of records after update to 10.9.2 from 10.8.3 (10.8.4 also fails, didn't tested other 10.x supported branches).

Looked through release notes and don't see anything that could cause it from changes description.

Query itself doesn't have any practical use for us, just one of test cases and works correctly for at least 6 other RDBMS

Attachments

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

query.sql
2022-08-25 10:41
0.9 kB
Dmitry
good-result.txt
2022-08-25 10:41
1 kB
Dmitry
data.sql
2022-08-25 10:41
0.4 kB
Dmitry
bad-result.txt
2022-08-25 10:41
1 kB
Dmitry

Issue Links

relates to

MDEV-41872 Wrong result (missing rows) with LEFT JOIN and two semi-joins when DuplicateWeedout uses a join buffer (11.0+)

Confirmed

Activity

People

Assignee:: Sergei Petrunia

Reporter:: Dmitry

Votes:: 0 Vote for this issue

Watchers:: 6 Start watching this issue

Dates

Created:: 2022-08-25 10:45

Updated:: 2026-10-29 05:11

Time Tracking

Estimated:

Remaining:

Logged:

2d 3h

Git Integration

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