[MDEV-16804] SYSTEM VERSIONING columns not showing as GENERATED Created: 2018-07-23  Updated: 2019-06-14  Resolved: 2019-06-14

Status: Closed
Project: MariaDB Server
Component/s: Versioned Tables
Affects Version/s: 10.3.8
Fix Version/s: 10.3.16, 10.4.6

Type: Bug Priority: Major
Reporter: Vincent Milum Jr Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: None
Environment:

Server version: 10.3.8-MariaDB-1:10.3.8+maria~stretch-log mariadb.org binary distribution

Issue Links:
Relates
relates to MDEV-16857 system-invisible row_end is displayed... Closed

 Description   

1. Create a table
2. Add SYSTEM VERSIONING as follows per documentation at https://mariadb.com/kb/en/library/system-versioned-tables/

ALTER TABLE t ADD COLUMN ts TIMESTAMP(6) GENERATED ALWAYS AS ROW START,
 
              ADD COLUMN te TIMESTAMP(6) GENERATED ALWAYS AS ROW END,
 
              ADD PERIOD FOR SYSTEM_TIME(ts, te),
 
              ADD SYSTEM VERSIONING;

3. Execute a SHOW COLUMNS on table.

MariaDB [test_database]> show columns from t;
 
+-------+--------------+------+-----+---------+----------------+
 
| Field | Type         | Null | Key | Default | Extra          |
 
+-------+--------------+------+-----+---------+----------------+
 
| col1  | bigint(20)   | NO   | PRI | NULL    | auto_increment |
 
| ts    | timestamp(6) | NO   |     | NULL    |                |
 
| te    | timestamp(6) | NO   | PRI | NULL    |                |
 
+-------+--------------+------+-----+---------+----------------+

`ts` and `te` should list GENERATED in the Extra field.
Generated at Thu Feb 08 08:31:41 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.