|
|||||||||||
|
bk commit into 5.0 tree (bar:1.2502)
From: <bar(at)mysql.com>
Date: Tue Aug 07 2007 - 10:22:34 EDT
ChangeSet@1.2502, 2007-08-07 19:22:31+05:00, bar@mysql.com +3 -0 Adding test case. mysql-test/r/ctype_recoding.result@1.34, 2007-08-07 19:22:29+05:00, bar@mysql.com +8 -0 Adding test case. mysql-test/t/ctype_recoding.test@1.24, 2007-08-07 19:22:29+05:00, bar@mysql.com +10 -0 Adding test case. sql/sql_string.cc@1.99, 2007-08-07 19:22:29+05:00, bar@mysql.com +0 -2 Adding test case. diff -Nrup a/mysql-test/r/ctype_recoding.result b/mysql-test/r/ctype_recoding.result --- a/mysql-test/r/ctype_recoding.result 2006-10-30 10:13:58 +04:00@@ -187,6 +187,14 @@ select * from t1 where a=_latin1'×ÁÓÑ'; ERROR HY000: Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '=' drop table t1; set names latin1; +set names ascii; +create table t1 (a char(1) character set latin1); +insert into t1 values ('a'); +select * from t1 where a='a'; +a +a +drop table t1; +set names latin1; create table t1 (a char(10) character set utf8 collate utf8_bin); insert into t1 values (' xxx'); select * from t1 where a=lpad('xxx',10,' '); diff -Nrup a/mysql-test/t/ctype_recoding.test b/mysql-test/t/ctype_recoding.test --- a/mysql-test/t/ctype_recoding.test 2006-09-01 11:49:52 +05:00@@ -153,6 +153,16 @@ drop table t1; set names latin1; # +# Test the same with ascii +# +set names ascii; +create table t1 (a char(1) character set latin1); +insert into t1 values ('a'); +select * from t1 where a='a'; +drop table t1; +set names latin1; + +# # Bug#10446 Illegal mix of collations # create table t1 (a char(10) character set utf8 collate utf8_bin); diff -Nrup a/sql/sql_string.cc b/sql/sql_string.cc --- a/sql/sql_string.cc 2007-08-03 15:25:21 +05:00 -- MySQL Code Commits Mailing List For list archives: http://lists.mysql.com/commits To unsubscribe: http://lists.mysql.com/commits?unsub=lists@pantek.comReceived on Tue Aug 7 10:23:41 2007 This archive was generated by hypermail 2.1.8 : Thu Aug 09 2007 - 19:25:36 EDT |
||||||||||
|
|||||||||||