mirror of
https://github.com/MariaDB/server.git
synced 2025-10-31 02:46:29 +01:00
61acb43689
make TRANSACTIONAL table option behave similar to other engine-defined table options. If the engine doesn't suport it: * if specified expicitly in CREATE or ALTER - it's ER_UNKNOWN_OPTION * an error or a warning depending on sql_mode IGNORE_BAD_TABLE_OPTIONS * in ALTER TABLE from the engine that suppors it to the engine that doesn't - silently preserved (no warning) * it is commented out in SHOW CREATE unless IGNORE_BAD_TABLE_OPTIONS
18 lines
853 B
Text
18 lines
853 B
Text
alter table mysql.plugin engine=myisam;
|
|
set @old_dbug=@@debug_dbug;
|
|
call mtr.add_suppression("Index for table.*mysql.plugin.MYI");
|
|
call mtr.add_suppression("Index for table 'plugin' is corrupt; try to repair it");
|
|
SET debug_dbug='+d,myisam_pretend_crashed_table_on_usage';
|
|
install plugin audit_null soname 'adt_null';
|
|
ERROR HY000: Index for table './mysql/plugin.MYI' is corrupt; try to repair it
|
|
SET debug_dbug=@old_dbug;
|
|
install plugin audit_null soname 'adt_null';
|
|
SET debug_dbug='+d,myisam_pretend_crashed_table_on_usage';
|
|
uninstall plugin audit_null;
|
|
ERROR HY000: Index for table './mysql/plugin.MYI' is corrupt; try to repair it
|
|
SET debug_dbug=@old_dbug;
|
|
uninstall plugin audit_null;
|
|
uninstall plugin audit_null;
|
|
ERROR 42000: PLUGIN audit_null does not exist
|
|
delete from mysql.plugin where name='audit_null';
|
|
alter table mysql.plugin engine=aria;
|