• anozdrin@mysql.com's avatar
    Fix for Bug#12953 "Stored procedures: crash if OPTIMIZE TABLE in function" · b2910906
    anozdrin@mysql.com authored
    OPTIMIZE TABLE statement is forbidden from usage in stored procedures/functions.
    
    NOTE: OPTIMIZE TABLE statement can be useful in stored procedures. The idea is
    that the user/administrator can create a stored procedure for admin
    tasks (optimizing, backing up, etc). This procedure can be scheduled to run
    automatically (by mean of internal cron (WL#1034)). So, once we can make this
    statement work, it is worth doing it.
    b2910906
sp-error.test 21.3 KB