[MDEV-14676] Redundancy in error codes: ER_VERS_NOT_VERSIONED vs ER_VERSIONING_REQUIRED Created: 2017-12-16  Updated: 2017-12-27  Resolved: 2017-12-19

Status: Closed
Project: MariaDB Server
Component/s: Versioned Tables
Affects Version/s: N/A
Fix Version/s: 10.3.4

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Aleksey Midenkov
Resolution: Fixed Votes: 0
Labels: None


 Description   

Errors ER_VERSIONING_REQUIRED and ER_VERS_NOT_VERSIONED seem to have the same semantics, maybe there is no need to have both.

$ /data/bld/bb-10.3-temporal/bin/perror 4129
 
MySQL error code 4129 (ER_VERS_NOT_VERSIONED): Table %`s is not versioned
 
 
 
$ /data/bld/bb-10.3-temporal/bin/perror 4106
 
MySQL error code 4106 (ER_VERSIONING_REQUIRED): System Versioning required: %s



 Comments   
Comment by Aleksey Midenkov [ 2017-12-19 ] 

create or replace table t1 (x int);
 
insert into t1 values (1);
 
--error ER_VERSIONING_REQUIRED
 
select * from t1 for system_time all;


create table t(
 
  a int
 
);
 
show create table t;
 
--error ER_VERS_NOT_VERSIONED
 
alter table t drop system versioning;

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