diff options
| author | unknown <bar@bar.intranet.mysql.r18.ru> | 2003-12-25 17:42:17 +0400 |
|---|---|---|
| committer | unknown <bar@bar.intranet.mysql.r18.ru> | 2003-12-25 17:42:17 +0400 |
| commit | 8fac0f4d2753277928a5bb4c2a5fc5a5a8becc64 (patch) | |
| tree | 6386d5103a8d78819da523843660e04e55656670 /mysql-test/r/cast.result | |
| parent | 229cc612776f757de6822eb97eb4e9a97226e760 (diff) | |
| download | mariadb-git-8fac0f4d2753277928a5bb4c2a5fc5a5a8becc64.tar.gz | |
Bug 2202: CAST from binary to char still returns a binary string
Diffstat (limited to 'mysql-test/r/cast.result')
| -rw-r--r-- | mysql-test/r/cast.result | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/r/cast.result b/mysql-test/r/cast.result index acca50b45dd..24d33e79411 100644 --- a/mysql-test/r/cast.result +++ b/mysql-test/r/cast.result @@ -101,6 +101,21 @@ t1 CREATE TABLE `t1` ( `c5` char(2) character set utf8 NOT NULL default '' ) ENGINE=MyISAM DEFAULT CHARSET=latin1 drop table t1; +create table t1 (a binary(10), b char(10) character set koi8r); +insert into t1 values (_binary'ΤΕΣΤ',_binary'ΤΕΣΤ'); +select a,b,cast(a as char character set cp1251),cast(b as binary) from t1; +a b cast(a as char character set cp1251) cast(b as binary) +ΤΕΣΤ ΤΕΣΤ ΤΕΣΤ ΤΕΣΤ +set names koi8r; +select a,b,cast(a as char character set cp1251),cast(b as binary) from t1; +a b cast(a as char character set cp1251) cast(b as binary) +ΤΕΣΤ ΤΕΣΤ ζευζ ΤΕΣΤ +set names cp1251; +select a,b,cast(a as char character set cp1251),cast(b as binary) from t1; +a b cast(a as char character set cp1251) cast(b as binary) +ΤΕΣΤ ςερς ΤΕΣΤ ΤΕΣΤ +drop table t1; +set names binary; select cast("2001-1-1" as date) = "2001-01-01"; cast("2001-1-1" as date) = "2001-01-01" 1 |