[MDEV-18895] Fix engine output in "Adding or Removing System Versioning To/From a Table" section of doc Created: 2019-03-12  Updated: 2019-03-12  Resolved: 2019-03-12

Status: Closed
Project: MariaDB Server
Component/s: Documentation
Affects Version/s: None
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Shahriyar Rzayev (Inactive) Assignee: Ian Gilfillan
Resolution: Fixed Votes: 0
Labels: docs


 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


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