[MDEV-19820] Wrong result with multiple single column index request - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.4.6, 10.4(EOL)
Fix Version/s: 10.4.7
Component/s: Optimizer
Labels:
None
Environment:
Server : Debian baremetal server, this is the only product installed. Data is stored on a 4x1Tb SSD with material RAID 5
Client : Tested with mycli / mysql command / dbeaver on 2 different workstation on debian

Description

After migrating from mariadb 10.1.38-0+deb9u1 (provided by debian) to 10.4.6+maria~stretch, some request including IN (or multiple OR) and filtering on multiple columns indexed separately :

Here is the table creation : table_creation.sql

Here are the logs with my different results : execution.log

Execution plan : execution_plan.log

If I add an index on the two columns, the results are back : workaround.log

Attachments

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

execution_plan.log
1 kB
2019-06-21 08:33
execution.log
0.6 kB
2019-06-21 08:33
table_creation.sql
1 kB
2019-06-21 08:27
workaround.log
2 kB
2019-06-21 08:33

Issue Links

duplicates

MDEV-19911 Regression in 10.4 with InnoDB: indexed SELECT with join results in wrong results.

Closed

relates to

MDEV-19919 Assertion `!prebuilt->index->is_primary()' failed in row_search_idx_cond_check

Closed

MDEV-20056 Assertion `!prebuilt->index->is_primary()' failed in row_search_idx_cond_check

Closed

Activity

Ascending order - Click to sort in descending order

Sylvain RUMEU created issue - 2019-06-21 08:36

Sylvain RUMEU made changes - 2019-06-21 08:37

Field	Original Value	New Value
Summary	Wrong result with	Wrong result with

Sylvain RUMEU made changes - 2019-06-21 08:37

Summary

Wrong result with

Wrong result with multiple index request

Sylvain RUMEU made changes - 2019-06-21 08:38

Summary

Wrong result with multiple index request

Wrong result with multiple single column index request

Alice Sherepa made changes - 2019-06-21 10:18

Assignee

Alice Sherepa [ alice ]