[MDEV-24204] inconsistent query results using a LEFT JOIN - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Duplicate
Affects Version/s: 10.3.25, 10.3(EOL), 10.4(EOL), 10.5
Fix Version/s: N/A
Component/s: N/A
Labels:
None
Environment:
Ubuntu and Debian

Description

Hi,

After trying without success to post my trouble on the mariadb-discuss mailing list, so I posted it here:
https://alioth-lists.debian.net/pipermail/pkg-mysql-maint/2020-November/014430.html
with one follow up here:
https://alioth-lists.debian.net/pipermail/pkg-mysql-maint/2020-November/014445.html

This is strange because the same query works fine both on MySQL 8.0.21 (Ubuntu) and MySQL 5.7.26 (Debian).

I don't know how to start with this and I am not familiar with the EXPLAIN output.

Thanks,
Patrice

Attachments

Attachments

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

1_my.test
2020-11-17 15:12
767 kB
Alice Sherepa
3DstructureDB_ANC.sql.gz
2020-11-16 13:46
1.63 MB
Patrice Duroux
cnf.tgz
2020-11-13 11:48
3 kB
Patrice Duroux
db.sql.7z
2020-11-17 15:11
787 kB
Alice Sherepa
taxonomy.sql.gz
2020-11-16 13:46
5 kB
Patrice Duroux

Issue Links

duplicates

MDEV-25128 Wrong result from join with materialized semi-join and splittable derived

Closed

Activity

People

Assignee:: Oleg Smirnov

Reporter:: Patrice Duroux

Votes:: 1 Vote for this issue

Watchers:: 6 Start watching this issue

Dates

Created:: 2020-11-12 15:21

Updated:: 2022-04-06 16:48

Resolved:: 2022-04-06 16:48

Git Integration

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