matrixorigin / matrixorigin/matrixone

Feature Not Supported: ALTER TABLE ADD PARTITION Not Supported

Open
#23,090 0 comments 0 reactions 1 assignee Assigned to @XuPeng-SH View on GitHub
Dominant language
Go
Stars
1.9k
Forks
311
Avg merge
1d 3h
Merged PRs (30d)
768

Description

# Issue: ALTER TABLE ADD PARTITION Not Supported

## Description

MatrixOne does not support adding partitions to an existing partitioned table using `ALTER TABLE ADD PARTITION`. This is a standard MySQL feature for dynamically expanding partitioned tables.

## Error Statement

```sql
ALTER TABLE test_partition_range ADD PARTITION (
PARTITION p2024 VALUES LESS THAN (2025)
);
```

## Error Message

```
ERROR 20105 (HY000) at line 1: not supported: unsupported alter option in inplace mode: add partition (partition p2024 values less than (2025))
```

## Expected Behavior

The statement should add a new partition to the existing RANGE partitioned table, allowing data for year 2024 to be stored.

## Actual Behavior

MatrixOne reports that adding partitions is not supported in inplace mode, indicating this operation is not implemented.

## Impact

- Users cannot dynamically add partitions to existing tables
- Tables must be recreated to add new partitions
- This limits the flexibility of partition management
- Migration from MySQL may require schema redesign

## Test Case

**Case ID**: 605
**Test File**: `test_batch_61_partition.sql`
**Test Type**: Partition - ADD PARTITION operation

## Related Information

- MatrixOne supports creating partitioned tables (RANGE, HASH, KEY)
- Other partition management operations (TRUNCATE, REORGANIZE) are also not supported
- This is part of comprehensive partition functionality testing

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.