[MDEV-15190] Bad error for non-versioned table PARTITION BY SYSTEM_TIME Created: 2018-02-03  Updated: 2018-02-23  Resolved: 2018-02-07

Status: Closed
Project: MariaDB Server
Component/s: Versioned Tables
Affects Version/s: 10.3
Fix Version/s: 10.3.5

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


 Description   

Bad error/code message upon attempt to partition by system_time a table without system versioning.

create or replace table t1 (i int);
 
alter table t1 partition by system_time limit 10 (partition p1 history, partition pn current);

Actual result

 
MariaDB [test]> alter table t1 partition by system_time limit 10 (partition p1 history, partition pn current);
 
ERROR 4109 (HY000): Transaction system versioning for `#sql-5280_9` is not supported

An error is expected, but this particular error doesn't seem optimal for the case, something like "the table is no system-versioned" would be more suitable.
Generated at Thu Feb 08 08:19:21 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.