Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.4.6, 10.4(EOL)
-
None
-
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
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