GeezerVison

Summary
This PR addresses the issue with JSQLParser's inability to parse ADD PARTITION clauses in ALTER TABLE statements for MySQL 8.0. Previously, these clauses were not recognized, causing parsing errors for certain ALTER TABLE operations.

Changes

• Updated AlterOperation enum to include ADD PARTITION.
• Modified the parser to correctly identify and handle the ADD PARTITION clauses, allowing for accurate parsing of these statements.

References
MySQL Documentation: ALTER TABLE Partition Operations

Note
This update enables JSQLParser to parse MySQL 8.0-specific partition operations within ALTER TABLE statements, improving support for MySQL-specific syntax. Additional partition-related clauses (such as REORGANIZE PARTITION, REMOVE PARTITIONING, etc.) are planned for future implementation to fully support MySQL's ALTER TABLE partition syntax.