matrixorigin / matrixorigin/matrixone

Feature Gap: ANALYZE/CHECK/SHOW PROFILE statements unsupported

Open
#23,122 2 comments 0 reactions 1 assignee Claimed by @Ariznawlll View on GitHub
kind/feature priority/p1
Dominant language
Go
Stars
1.9k
Forks
311
Avg merge
1d 3h
Merged PRs (30d)
768

Description

## Description

Several MySQL administrative statements are completely unsupported and fail at the parser level:

```sql
ANALYZE TABLE company, company_patent;
CHECK TABLE company EXTENDED;
SHOW PROFILE FOR QUERY 1;
```

All three statements immediately return `ERROR 1064 (HY000)` with no alternative syntax available.

## Error Messages

```
ERROR 1064 (HY000) at line 1: SQL parser error ... syntax error at line 1 column 22 near ", company_patent"
ERROR 1064 (HY000) at line 1: SQL parser error ... syntax error at line 1 column 5 near "CHECK TABLE company EXTENDED"
ERROR 1064 (HY000) at line 1: SQL parser error ... syntax error at line 1 column 12 near " PROFILE FOR QUERY 1"
```

## Impact
- DBAs cannot gather statistics (`ANALYZE TABLE`) inside MatrixOne.
- Integrity/consistency checks (`CHECK TABLE`) are unavailable.
- Session profiling (`SHOW PROFILE`) cannot be used for diagnostics.

## Expected Behavior
MatrixOne should either support these statements or provide documented alternatives. At minimum, the parser should recognize the syntax and emit a clear "not implemented" error instead of a generic syntax error, so migration tools know the feature gap explicitly.

## References
- Cases 1288/1308/1328... (`ANALYZE TABLE`)
- Cases 1289/1309/1329... (`CHECK TABLE`)
- Cases 1290/1310/1330... (`SHOW PROFILE`)

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.