Bug #32390 Character sets: casting utf32 to/from date doesn't work

Description:
I'm using the mysql-5.2-rpl team tree.

I create a table with a utf32 column.
I try to insert a DATE, expecting date-to-char conversion. That fails.
I try to use CAST for a char-to-date conversion. That fails.

With ucs2: the insert would work, the CAST would not, that's known.

How to repeat:
create table n (s1 varchar(10) character set utf32);
insert into n values (current_date);
show warnings;
delete from n;
insert into n values ('0001-01-01');
select cast(s1 as date) from n;
show warnings;

Example:

mysql> create table n (s1 varchar(10) character set utf32);
Query OK, 0 rows affected (0.00 sec)

mysql> insert into n values (current_date);
Query OK, 1 row affected, 1 warning (0.00 sec)

mysql> show warnings;
+---------+------+--------------------------------------------------------------+
| Level   | Code | Message                                                      |
+---------+------+--------------------------------------------------------------+
| Warning | 1366 | Incorrect string value: '07-11-...' for column 's1' at row 1 |
+---------+------+--------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> delete from n;
Query OK, 1 row affected (0.00 sec)

mysql> insert into n values ('0001-01-01');
Query OK, 1 row affected (0.00 sec)

mysql> select cast(s1 as date) from n;
+------------------+
| cast(s1 as date) |
+------------------+
| NULL             |
+------------------+
1 row in set, 1 warning (0.00 sec)

mysql> show warnings;
+---------+------+------------------------------+
| Level   | Code | Message                      |
+---------+------+------------------------------+
| Warning | 1292 | Incorrect datetime value: '' |
+---------+------+------------------------------+
1 row in set (0.00 sec)

Thank you for the bug report. Verified as described.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/49992

2723 Alexander Barkov	2008-07-18
      Bug#32390 Character sets: casting utf32 to/from date doesn't work
      Problem: insertion of CURRENT_TIME, CURRENT_DATE and CURRENT_TIMESTAMP
      into a varchar column didn't work for non-ASCII character sets
      like ucs2, utf16 and utf32. That happened because character set
      of the inserted value was specified as my_charset_bin.
      Fix:
      - for tricky character set we specify my_charset_latin1,
      which forces character set conversion and thus make insertion correct.
      - for non-tricky character set we still use my_charset_bin to
      avoid unnesessary conversion.
      
      
      - mysql-test/include/ctype_datetime.inc:
      A new shared test include file
      
      
      - mysql-test/r/ctype_ucs.result
      - mysql-test/r/ctype_utf16.result
      - mysql-test/r/ctype_utf32.result
      - mysql-test/t/ctype_ucs.test
      - mysql-test/t/ctype_utf16.test
      - mysql-test/t/ctype_utf32.test:
      Adding tests
      
      - sql/field.cc
      The fix itself: pass proper character set value to store().

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/50168

2732 Alexander Barkov	2008-07-22
      Bug#32390 Character sets: casting utf32 to/from date doesn't work
      Problem: insertion of CURRENT_TIME, CURRENT_DATE and CURRENT_TIMESTAMP
      into a varchar column didn't work for non-ASCII character sets
      like ucs2, utf16 and utf32. That happened because character set
      of the inserted value was specified as my_charset_bin.
      Fix:
      - for tricky character set we specify my_charset_latin1,
      which forces character set conversion and thus make insertion correct.
      - for non-tricky character set we still use my_charset_bin to
      avoid unnesessary conversion.
      
      
      - mysql-test/include/ctype_datetime.inc:
      A new shared test include file
      
      
      - mysql-test/r/ctype_ucs.result
      - mysql-test/r/ctype_utf16.result
      - mysql-test/r/ctype_utf32.result
      - mysql-test/t/ctype_ucs.test
      - mysql-test/t/ctype_utf16.test
      - mysql-test/t/ctype_utf32.test:
      Adding tests
      
      - sql/field.cc
      The fix itself: pass proper character set value to store().

Pushed into 6.0.7-bugteam

Pushed into 6.0.7-alpha  (revid:alik@mysql.com-20080725172155-fnc73o50e4tgl23k) (version source revid:alik@mysql.com-20080725172155-fnc73o50e4tgl23k) (pib:3)

Noted in 6.0.7 changelog.

Pushed into 6.0.6-alpha  (revid:bar@mysql.com-20080722092546-rb02kr9f7hs8y8g9) (version source revid:hakan@mysql.com-20080716105246-eg0utbybp122n2w9) (pib:3)