matrixorigin / matrixorigin/matrixone
Feature Gap: ANALYZE/CHECK/SHOW PROFILE statements unsupported
- 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
Assessment
This issue has not been assessed yet.