Skip to content

[Bug] ALTER TABLE with TRUNCATE fails #2378

@rr-ngoc-to

Description

@rr-ngoc-to

Describe the bug
ALTER TABLE with TRUNCATE fails

Database Engine
mysql

To Reproduce
ALTER TABLE test_table TRUNCATE PARTITION p202503;

Expected behavior
The query should be parsed without any issues.
Instead the following error is thrown:

s [SyntaxError]: Expected "#", "--", ".", "/*", "ADD", "ALGORITHM", "AUTO_INCREMENT", "AVG_ROW_LENGTH", "CHANGE", "CHARACTER", "CHARSET", "CHECKSUM", "COLLATE", "COMMENT", "COMPRESSION", "CONNECTION", "DATA", "DEFAULT", "DELAY_KEY_WRITE", "DROP", "ENGINE", "ENGINE_ATTRIBUTE", "INDEX", "KEY_BLOCK_SIZE", "LOCK", "MAX_ROWS", "MIN_ROWS", "MODIFY", "NOCHECK", "RENAME", "ROW_FORMAT", "SECONDARY_ENGINE_ATTRIBUTE", "STATS_SAMPLE_PAGES", "WITH", or [ \t\n\r] but "T" found.

Metadata

Metadata

Assignees

Labels

enhancementNew feature or request

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions