1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
|
--source include/not_valgrind.inc
--source include/force_myisam_default.inc
--source include/have_myisam.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;
# Create the table with a bogus NULL column
CREATE TABLE bug49823 (event_time TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6), user_host MEDIUMTEXT NOT NULL, thread_id BIGINT(21) UNSIGNED NOT NULL, server_id INTEGER UNSIGNED NULL, command_type VARCHAR(64) NOT NULL, argument MEDIUMBLOB NOT NULL) engine=MYISAM CHARACTER SET utf8 comment="General log";
SET GLOBAL general_log = OFF;
USE mysql;
FLUSH TABLES;
RENAME TABLE general_log TO renamed_general_log;
RENAME TABLE test.bug49823 TO general_log;
# Filter out ndb_binlog_index to mask differences due to running with or
# without ndb. Always report check-for-upgrade status as OK, as it depends
# on the order in which tests are run.
--let $restart_parameters = restart:--upgrade=FORCE --general-log=0
--let $wait_counter= 10000
--source include/restart_mysqld.inc
DROP TABLE general_log;
RENAME TABLE renamed_general_log TO general_log;
USE test;
--let $restart_parameters = restart:
--source include/restart_mysqld.inc
--source include/mysql_upgrade_cleanup.inc
|
