Partition pruning, History truncation
Pre-release
Pre-release
midenok
released this
16 Jan 07:29
·
17269 commits
to 10.5
since this release
Added:
- Partition pruning [#97]:
- based on RANGE pruning by COLUMNS (sys_trx_end) condition;
- removed DEFAULT; AS OF NOW is always last; current VERSIONING as last non-empty (or first empty);
- ALTER TABLE ADD PARTITION adds before AS OF NOW partition;
- Min/Max partition stats are multi-threaded.
- History truncation [#96, #111]:
- FOR SYSTEM_TIME clause for TRUNCATE TABLE;
- FOR SYSTEM_TIME BEFORE syntax extension.
- FOR SYSTEM_TIME is now table-local or query-global [#116]:
- QUERY keyword makes it query-global.