Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Won't Fix
-
10.3, 10.4, 10.5
-
None
Description
CREATE OR REPLACE TABLE t1 (a INT) WITH system versioning; |
CREATE OR REPLACE TABLE t2 (a INT, s DATE, e DATE, period FOR p(s,e)); |
(can be executed either via command-line client or via HeidiSQL query).
Table t1:CREATE code - MariaDB 10.5.3 / HeidiSQL 11.0.0.5919 |
CREATE TABLE `t1` ( |
`a` INT(11) NULL DEFAULT NULL |
)
|
COLLATE='latin1_swedish_ci' |
ENGINE=InnoDB
|
;
|
Talbe t2:CREATE code |
CREATE TABLE `t2` ( |
`a` INT(11) NULL DEFAULT NULL, |
`s` DATE NOT NULL, |
`e` DATE NOT NULL |
)
|
COLLATE='latin1_swedish_ci' |
ENGINE=InnoDB
|
;
|
Screenshots are attached.
I suppose we need to request an update from upstream and then include it into our releases.