Unrecognized keyword and Unrecognized alter operation

CHECK TABLE `table` FOR UPGRADE; will give two errors.

ALTER TABLE `table` FORCE; will give one error.

05.03.2023_19.16.44_REC.mp4

I believe the two queries do execute, can you post a documentation link for this sort of query ?

I believe the two queries do execute, can you post a documentation link for this sort of query ?

About the CHECK TABLE statement:

CHECK TABLE is available at least since MySQL 5.0: https://web.archive.org/web/20160324160726/https://dev.mysql.com/doc/refman/5.0/en/check-table.html
Keyword "FOR UPGRADE" is not part of the dictionnary.
I can't find any test in the parser for it, maybe we should add one

About the ALTER TABLE … FORCE statement:

Available since MySQL 5.5
- NOT IN MySQL 5.1: https://web.archive.org/web/20160326052718/https://dev.mysql.com/doc/refman/5.1/en/alter-table.html
- IN MySQL 5.5: https://web.archive.org/web/20160326034033/https://dev.mysql.com/doc/refman/5.5/en/alter-table.html
Keyword "FORCE" is not part of the TABLE_OPTIONS on AlterStatement class, so it is not managed yet.
Some tests in the parser must be added about it.

Navigation Menu