diff options
Diffstat (limited to 'mysql-test/main/log_tables_upgrade.test')
| -rw-r--r-- | mysql-test/main/log_tables_upgrade.test | 28 |
1 files changed, 28 insertions, 0 deletions
diff --git a/mysql-test/main/log_tables_upgrade.test b/mysql-test/main/log_tables_upgrade.test new file mode 100644 index 00000000000..36802fb38ad --- /dev/null +++ b/mysql-test/main/log_tables_upgrade.test @@ -0,0 +1,28 @@ +--source include/have_csv.inc +--source include/have_innodb.inc +--source include/mysql_upgrade_preparation.inc + +--echo # +--echo # Bug#49823: mysql_upgrade fatal error due to general_log / slow_low CSV NULL +--echo # + +USE test; + +let $MYSQLD_DATADIR= `SELECT @@datadir`; +copy_file std_data/bug49823.frm $MYSQLD_DATADIR/test/bug49823.frm; +copy_file std_data/bug49823.CSM $MYSQLD_DATADIR/test/bug49823.CSM; +copy_file std_data/bug49823.CSV $MYSQLD_DATADIR/test/bug49823.CSV; + +SET @saved_general_log = @@GLOBAL.general_log; +SET GLOBAL general_log = OFF; +USE mysql; +FLUSH TABLES; +REPAIR TABLE test.bug49823; +RENAME TABLE general_log TO renamed_general_log; +RENAME TABLE test.bug49823 TO general_log; +--exec $MYSQL_UPGRADE --force 2>&1 +DROP TABLE general_log; +RENAME TABLE renamed_general_log TO general_log; +SET GLOBAL general_log = @saved_general_log; +remove_file $MYSQLD_DATADIR/mysql_upgrade_info; +USE test; |