[MDEV-25531] Auto-create: Bad error message upon failure to create partitions due to ER_TOO_MANY_PARTITIONS_ERROR Created: 2021-04-26  Updated: 2021-07-29  Resolved: 2021-06-04

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

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

bb-10.6-midenok-MDEV-17554

Issue Links:
Relates
relates to MDEV-17554 Auto-create history partitions for sy... Closed

 Description   

The test case is taken from the MTR test, so there is no need to add it anywhere:

set timestamp= unix_timestamp('2000-01-01 00:00:00');
 
create or replace table t1 (x int) with system versioning partition by system_time interval 1 hour auto;
 
set timestamp= unix_timestamp('2001-01-01 00:01:00');
 
update t1 set x= x + 1;

The UPDATE results in

bb-10.6-midenok-MDEV-17554 b96b96f9f3e

 
MariaDB [test]>  update t1 set x= x + 1;
 
ERROR 1499 (HY000): Too many partitions (including subpartitions) were defined

While it is indeed what happens underneath, the error message is really unsuitable and confusing in this situation: UPDATE doesn't define any partitions at all, and in this case even the table definition doesn't "define too many partitions".


Generated at Thu Feb 08 09:38:24 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.