summaryrefslogtreecommitdiff
path: root/mysql-test/r/log_tables.result
diff options
context:
space:
mode:
authorunknown <petr/cps@outpost.site>2006-12-04 03:07:44 +0300
committerunknown <petr/cps@outpost.site>2006-12-04 03:07:44 +0300
commitebd5aec15e4901893711569e174cd9efbcc712e0 (patch)
treec8d6ec74d364e3dd92f1a6ce1bcc6ad3727d6acc /mysql-test/r/log_tables.result
parent23776f53ff8058f3bc2eb01f61f95ff718adb5ef (diff)
downloadmariadb-git-ebd5aec15e4901893711569e174cd9efbcc712e0.tar.gz
Fix Bug #21328 mysqld issues warnings on ALTER CSV table to MyISAM
mysql-test/r/csv.result: update result file mysql-test/r/log_tables.result: log_tables test contains alter of a CSV table with NULLs which results in warnings. In fact this is how the bug noticed. So, now when it is fixed we should update result file. mysql-test/t/csv.test: add a test for the bug storage/csv/ha_tina.cc: We should write 0 to the data file in the case we meet NULL. CSV does not support NULL values internally and we shouldn't distinguish them from 0 when writing a row (the alternative is to implement full NULL support). Otherwise other routines (such as Field::check_int() become confused). In 5.0 NULLs are stored as zeroes. In 5.1 it somehow turned into empty string. Which is wrong.
Diffstat (limited to 'mysql-test/r/log_tables.result')
-rw-r--r--mysql-test/r/log_tables.result3
1 files changed, 0 insertions, 3 deletions
diff --git a/mysql-test/r/log_tables.result b/mysql-test/r/log_tables.result
index d9d754c91e6..fc6891a3909 100644
--- a/mysql-test/r/log_tables.result
+++ b/mysql-test/r/log_tables.result
@@ -111,9 +111,6 @@ slow_log CREATE TABLE `slow_log` (
) ENGINE=CSV DEFAULT CHARSET=utf8 COMMENT='Slow log'
alter table mysql.general_log engine=myisam;
alter table mysql.slow_log engine=myisam;
-Warnings:
-Warning 1366 Incorrect integer value: '' for column 'last_insert_id' at row 0
-Warning 1366 Incorrect integer value: '' for column 'insert_id' at row 0
show create table mysql.general_log;
Table Create Table
general_log CREATE TABLE `general_log` (