[MDEV-33123] Allow CHECK TABLE in stored procedures Created: 2023-12-26 Updated: 2023-12-26 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Admin statements, Stored routines |
| Fix Version/s: | 11.5 |
| Type: | New Feature | Priority: | Minor |
| Reporter: | Elena Stepanova | Assignee: | Sergei Golubchik |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | upstream | ||
| Description |
|
In the year 2005 in MySQL 5.0 CHECK TABLE was forbidden in stored routines on the reason that "it can't work"
Later gradually various limitations were lifted, OPTIMIZE, REPAIR and such were allowed in stored procedures, CHECK was allowed in prepared statements, but on some reason it is still forbidden in stored procedures, both in MariaDB and MySQL (including 8.2). There were a few feature requests for enabling it in MySQL, they were accepted but no explanation is given why it cannot be done. It is worth checking, maybe there was a reason which no longer exists, or maybe it was simply looked over when other similar limitations were removed.
|