[MDEV-25173] paritioning not supported on transaction-precise versioned tabled Created: 2021-03-17  Updated: 2021-03-30

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

Type: Task Priority: Major
Reporter: Daniel Black Assignee: Unassigned
Resolution: Unresolved Votes: 1
Labels: None

Issue Links:
Relates
relates to MDEV-15951 system versioning by trx id doesn't w... Closed
relates to MDEV-20271 Partitioned versioned tables do not a... Open
relates to MDEV-23773 Cannot store the history separately f... Open

 Description   

CREATE OR REPLACE TABLE inv (
   x INT,
   start_trxid BIGINT UNSIGNED GENERATED ALWAYS AS ROW START INVISIBLE,
   end_trxid BIGINT UNSIGNED GENERATED ALWAYS AS ROW END INVISIBLE,
   PERIOD FOR SYSTEM_TIME(start_trxid, end_trxid)
) WITH SYSTEM VERSIONING;
 
alter table inv   PARTITION BY SYSTEM_TIME (
    PARTITION p_hist HISTORY,
    PARTITION p_cur CURRENT
  );
 
ERROR 4110 (HY000): `start_trxid` must be of type TIMESTAMP(6) for system-versioned table `inv`



 Comments   
Comment by Elena Stepanova [ 2021-03-17 ]

It is MDEV-15951, MDEV-20271, and MDEV-23773.
I don't know if it eventually got documented, though.

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