[MDEV-20250] do not open partitions excluded by automatic partition pruning Created: 2019-08-05  Updated: 2024-02-04

Status: Stalled
Project: MariaDB Server
Component/s: Optimizer, Partitioning
Fix Version/s: 11.5

Type: New Feature Priority: Critical
Reporter: Sergei Golubchik Assignee: Alexey Botchkov
Resolution: Unresolved Votes: 0
Labels: contribution

Issue Links:
Blocks
blocks MDEV-17613 MIN/MAX Optimization (Select tables o... Stalled
Relates
relates to MDEV-11084 Select statement with partition selec... Closed
relates to MDEV-19002 Partition performance optimization Stalled
relates to MDEV-20376 Assertion in ha_maria::close() upon c... Closed

 Description   

extend MDEV-11084 to also not open automatically excluded partitions

In particular, INSERT, DELETE, UPDATE and SELECT should not open any partitions that can be excluded by parsing the WHERE clause.


Generated at Thu Feb 08 08:58:01 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.