mirror of
https://github.com/MariaDB/server.git
synced 2025-02-12 00:15:35 +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
36 lines
1 KiB
Text
36 lines
1 KiB
Text
--source include/have_debug.inc
|
|
--source include/not_embedded.inc
|
|
|
|
if (!$ADT_NULL_SO) {
|
|
skip No NULL_AUDIT plugin;
|
|
}
|
|
|
|
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");
|
|
|
|
#
|
|
# MySQL BUG#14485479 - INSTALL AUDIT PLUGIN HANGS IF WE TRY TO DISABLE AND ENABLED DURING DDL OPERATION
|
|
# (a.k.a. audit event caused by the table access during audit plugin initialization)
|
|
#
|
|
SET debug_dbug='+d,myisam_pretend_crashed_table_on_usage';
|
|
--replace_result \\ /
|
|
--error 126
|
|
install plugin audit_null soname 'adt_null';
|
|
SET debug_dbug=@old_dbug;
|
|
|
|
install plugin audit_null soname 'adt_null';
|
|
SET debug_dbug='+d,myisam_pretend_crashed_table_on_usage';
|
|
--replace_result \\ /
|
|
--error 126
|
|
uninstall plugin audit_null;
|
|
SET debug_dbug=@old_dbug;
|
|
|
|
uninstall plugin audit_null;
|
|
--error ER_SP_DOES_NOT_EXIST
|
|
uninstall plugin audit_null;
|
|
|
|
delete from mysql.plugin where name='audit_null';
|
|
alter table mysql.plugin engine=aria;
|