From 5dd3b617d447658b6fe373975a24a1437a04af4e Mon Sep 17 00:00:00 2001 From: Davi Arnaut Date: Fri, 26 Feb 2010 09:22:48 -0300 Subject: Bug#49823: mysql_upgrade fatal error due to general_log / slow_low CSV NULL The problem was that the CSV storage engine does not support NULL fields, yet in some early 5.1 version the log tables (general_log and slow_log) were created with null fields. On top of this, when altering a CSV table column, all fields of the table must be NOT NULL otherwise the alteration fails. The solution is to ensure that during upgrade all columns of the log tables are NOT NULL. --- mysql-test/std_data/bug49823.CSM | Bin 0 -> 35 bytes mysql-test/std_data/bug49823.CSV | 1 + mysql-test/std_data/bug49823.frm | Bin 0 -> 8776 bytes 3 files changed, 1 insertion(+) create mode 100644 mysql-test/std_data/bug49823.CSM create mode 100644 mysql-test/std_data/bug49823.CSV create mode 100644 mysql-test/std_data/bug49823.frm (limited to 'mysql-test/std_data') diff --git a/mysql-test/std_data/bug49823.CSM b/mysql-test/std_data/bug49823.CSM new file mode 100644 index 00000000000..ee345049d99 Binary files /dev/null and b/mysql-test/std_data/bug49823.CSM differ diff --git a/mysql-test/std_data/bug49823.CSV b/mysql-test/std_data/bug49823.CSV new file mode 100644 index 00000000000..ffc319e2446 --- /dev/null +++ b/mysql-test/std_data/bug49823.CSV @@ -0,0 +1 @@ +"2010-02-26 13:32:26","root[root] @ localhost []",2,1,"Query","SELECT 1" diff --git a/mysql-test/std_data/bug49823.frm b/mysql-test/std_data/bug49823.frm new file mode 100644 index 00000000000..527807da1c9 Binary files /dev/null and b/mysql-test/std_data/bug49823.frm differ -- cgit v1.2.1