[MDEV-15168] Unexpected ER_VERS_ENGINE_UNSUPPORTED upon dropping versioning on a partitioned table Created: 2018-02-01  Updated: 2018-02-23  Resolved: 2018-02-23

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

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Eugene Kosov (Inactive)
Resolution: Fixed Votes: 0
Labels: None


 Description   

10.3 1951e7f05ae7b6069eeffdfe8ab304fa3a18a85a

 
MariaDB [test]> CREATE OR REPLACE TABLE t (a INT) WITH SYSTEM VERSIONING PARTITION BY SYSTEM_TIME (PARTITION p1 HISTORY, PARTITION pn CURRENT);
 
Query OK, 0 rows affected (0.66 sec)
 
 
 
MariaDB [test]> ALTER TABLE t DROP SYSTEM VERSIONING;
 
ERROR 4109 (HY000): Transaction system versioning for `#sql-69b8_a` is not supported

I can understand why ALTER has to fail, but the error code/message doesn't look right.

 Comments   
Comment by Aleksey Midenkov [ 2018-02-13 ]

DROP SYSTEM VERSIONING rather should not fail but drop partitioning.

DROP SYSTEM VERSIONING for partitioned table #465

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