matrixorigin / matrixorigin/matrixone

Feature Not Supported: SHOW PARTITIONS FROM table Command Not Supported

Open
#23,095 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: SHOW PARTITIONS FROM table Command Not Supported

## Description

MatrixOne does not support the `SHOW PARTITIONS FROM table` command for displaying partition information. This is a standard MySQL feature for viewing partition metadata.

## Error Statement

```sql
SHOW PARTITIONS FROM test_partition_range;
```

## Error Message

```
ERROR 1064 (HY000) at line 1: SQL parser error: You have an error in your SQL syntax; check the manual that corresponds to your MatrixOne server version for the right syntax to use. syntax error at line 1 column 15 near " PARTITIONS FROM test_partition_range"
```

## Expected Behavior

The command should display information about all partitions in the table, including partition names, expressions, and descriptions.

## Actual Behavior

MatrixOne reports a syntax error, indicating that the `SHOW PARTITIONS` syntax is not recognized by the parser.

## Impact

- Users cannot easily view partition information using SHOW command
- Must query INFORMATION_SCHEMA.PARTITIONS instead (which may have limited information)
- Less convenient for partition management
- Migration from MySQL may require different approaches to view partition metadata

## Test Case

**Case ID**: 611
**Test File**: `test_batch_62_partition.sql`
**Test Type**: Partition - SHOW PARTITIONS command

## Related Information

- MatrixOne supports querying INFORMATION_SCHEMA.PARTITIONS (though may return limited data)
- Other partition query features (EXPLAIN PARTITIONS, PARTITION() syntax) 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.