Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.3.8
-
None
-
Server version: 10.3.8-MariaDB-1:10.3.8+maria~stretch-log mariadb.org binary distribution
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.
Attachments
Issue Links
- relates to
-
-
- Closed
-