Description

liviuconcioiu

opened on Mar 5, 2023

Issue body actions

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

1. Unrecognized keyword. (near FOR)
2. Unrecognized keyword. (near UPGRADE)

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

1. Unrecognized alter operation. (near ;)

05.03.2023_19.16.44_REC.mp4

Activity

1. williamdes

   added

   bug

   on Mar 9, 2023
2. williamdes commented on Mar 9, 2023

   

   williamdes

   on Mar 9, 2023

   Member

   More actions

   I believe the two queries do execute, can you post a documentation link for this sort of query ?
3. liviuconcioiu commented on Mar 10, 2023

   

   liviuconcioiu

   on Mar 10, 2023

   ContributorAuthor

   More actions

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

   https://mariadb.com/kb/en/check-table/
   https://mariadb.com/kb/en/alter-table/

   https://dev.mysql.com/doc/refman/8.0/en/check-table.html
   https://dev.mysql.com/doc/refman/8.0/en/alter-table.html

   Reacted by William Desportes
4. niconoe- commented on Aug 7, 2024

   

   niconoe-

   on Aug 7, 2024

   Contributor

   More actions

   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.

   Reacted by William Desportes

   Reacted by Liviu-Mihail Concioiu

Issue actions