[MDEV-32147] ADD PERIOD FOR SYSTEM_TIME succeeds without action Created: 2023-09-11  Updated: 2023-11-28

Status: Open
Project: MariaDB Server
Component/s: Versioned Tables
Affects Version/s: 10.4, 10.5, 10.6, 10.10, 10.11, 11.0, 11.1
Fix Version/s: 10.4, 10.5, 10.6, 10.11, 11.0, 11.1

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Nikita Malyavin
Resolution: Unresolved Votes: 0
Labels: None


 Description    

CREATE TABLE t (a INT);
 
INSERT INTO t (a) VALUES (1),(2);
 
ALTER TABLE t ADD PERIOD FOR SYSTEM_TIME(s, e);
 
SHOW CREATE TABLE t;
 
 
 
DROP TABLE t;

ALTER here pretends to succeed even though columns s and e don't exist, and the table isn't versioned.

10.4 7d7ea799

 
ALTER TABLE t ADD PERIOD FOR SYSTEM_TIME(s, e);
 
SHOW CREATE TABLE t;
 
Table	Create Table
 
t	CREATE TABLE `t` (
 
  `a` int(11) DEFAULT NULL
 
) ENGINE=MyISAM DEFAULT CHARSET=latin1


Generated at Thu Feb 08 10:29:11 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.