diff options
author | unknown <petr/cps@outpost.site> | 2006-12-04 03:07:44 +0300 |
---|---|---|
committer | unknown <petr/cps@outpost.site> | 2006-12-04 03:07:44 +0300 |
commit | ebd5aec15e4901893711569e174cd9efbcc712e0 (patch) | |
tree | c8d6ec74d364e3dd92f1a6ce1bcc6ad3727d6acc /mysql-test/r/log_tables.result | |
parent | 23776f53ff8058f3bc2eb01f61f95ff718adb5ef (diff) | |
download | mariadb-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.result | 3 |
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` ( |