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/t/csv.test | |
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/t/csv.test')
-rw-r--r-- | mysql-test/t/csv.test | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/t/csv.test b/mysql-test/t/csv.test index 60d38394fc0..48c174355f4 100644 --- a/mysql-test/t/csv.test +++ b/mysql-test/t/csv.test @@ -1605,3 +1605,17 @@ check table bug22080_2; check table bug22080_3; drop tables bug22080_1,bug22080_2,bug22080_3; + +# +# Bug #21328 mysqld issues warnings on ALTER CSV table to MyISAM +# + +CREATE TABLE `bug21328` ( + `col1` int(11) DEFAULT NULL, + `col2` int(11) DEFAULT NULL, + `col3` int(11) DEFAULT NULL +) ENGINE=CSV; + +insert into bug21328 values (1,NULL,NULL); +alter table bug21328 engine=myisam; +drop table bug21328; |