|
Quoting the previous issue, as it still produces the same error:
Creating a system-versioned table with row version by trx id works as described in the KB. However when I add partitions to separate current and historic data, I get an error.
The CREATE TABLE statement:
CREATE TABLE sbtest1 (
|
id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
|
k INTEGER UNSIGNED DEFAULT '0' NOT NULL,
|
c CHAR(120) DEFAULT '' NOT NULL,
|
pad CHAR(60) DEFAULT '' NOT NULL,
|
start_trxid BIGINT UNSIGNED GENERATED ALWAYS AS ROW START,
|
end_trxid BIGINT UNSIGNED GENERATED ALWAYS AS ROW END,
|
PERIOD FOR SYSTEM_TIME(start_trxid, end_trxid),
|
PRIMARY KEY (id),
|
INDEX k_ (k)
|
) ENGINE=InnoDB WITH SYSTEM VERSIONING PARTITION BY SYSTEM_TIME (
|
PARTITION p_hist HISTORY,
|
PARTITION p_cur CURRENT
|
)
|
and the error message:
ERROR 4110 (HY000): `start_trxid` must be of type TIMESTAMP(6)
|
for system-versioned table `sbtest1`
|
If partitioning isn't supposed to work with trx ids, this should be documented.
|