[MDEV-21588] don't store ROW END timestamp in PARTITION CURRENT Created: 2020-01-29  Updated: 2020-01-29

Status: Open
Project: MariaDB Server
Component/s: Versioned Tables
Fix Version/s: None

Type: Task Priority: Major
Reporter: Sergei Golubchik Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None


 Description   

in a table that is partitioned BY SYSTEM_TIME, in a CURRENT partition the value of the column that is GENERATED ALWAYS AS ROW END is always the same, the max possible value for a given temporal type.

It doesn't make much sense to store this column in the table, it could be filled in after the row is read, much like a virtual generated column. And there is no point in appending it to all unique indexes — not doing it will make keys smaller and will competly eliminate the overhead for selects (currently sysbench oltp_read_only shows up to 20% slowdown).


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