Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
None
Description
As per documentation:
https://mariadb.com/kb/en/library/system-versioned-tables/#adding-or-removing-system-versioning-tofrom-a-table
At the end of section the table structure shown as:
SHOW CREATE TABLE t\G |
*************************** 1. row ***************************
|
Table: t |
Create Table: CREATE TABLE `t` ( |
`x` int(11) DEFAULT NULL, |
`ts` timestamp(6) GENERATED ALWAYS AS ROW START, |
`te` timestamp(6) GENERATED ALWAYS AS ROW END, |
PERIOD FOR SYSTEM_TIME (`ts`, `te`) |
) ENGINE=MyISAM DEFAULT CHARSET=latin1 WITH SYSTEM VERSIONING |
Instead it should be:
MariaDB [sbtest]> show create table t\G |
*************************** 1. row ***************************
|
Table: t |
Create Table: CREATE TABLE `t` ( |
`x` int(11) DEFAULT NULL, |
`ts` timestamp(6) GENERATED ALWAYS AS ROW START, |
`te` timestamp(6) GENERATED ALWAYS AS ROW END, |
PERIOD FOR SYSTEM_TIME (`ts`, `te`) |
) ENGINE=InnoDB DEFAULT CHARSET=latin1 WITH SYSTEM VERSIONING |