summaryrefslogtreecommitdiff
path: root/mysql-test/r/ctype_uca.result
diff options
context:
space:
mode:
authorunknown <ramil/ram@ramil.myoffice.izhnet.ru>2007-10-04 10:54:51 +0500
committerunknown <ramil/ram@ramil.myoffice.izhnet.ru>2007-10-04 10:54:51 +0500
commit1981008587319ee1190145ef651d31e29e75a22a (patch)
tree9406811f25393f4adff4fd122803f0487faf92eb /mysql-test/r/ctype_uca.result
parentba0cd51eb19f1f8868901d4b2327e1c8f4745c19 (diff)
parentdb2d3104f90f398f81f5ab8fd7465f67cb950cce (diff)
downloadmariadb-git-1981008587319ee1190145ef651d31e29e75a22a.tar.gz
Merge mysql.com:/home/ram/work/b31070/b31070.4.1
into mysql.com:/home/ram/work/b31070/b31070.5.0 mysql-test/r/ctype_big5.result: Auto merged mysql-test/r/ctype_gbk.result: Auto merged mysql-test/r/ctype_uca.result: Auto merged strings/ctype-big5.c: Auto merged strings/ctype-euc_kr.c: Auto merged strings/ctype-gb2312.c: Auto merged strings/ctype-sjis.c: Auto merged BitKeeper/deleted/.del-ctype-cp932.c: Auto merged
Diffstat (limited to 'mysql-test/r/ctype_uca.result')
-rw-r--r--mysql-test/r/ctype_uca.result11
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/r/ctype_uca.result b/mysql-test/r/ctype_uca.result
index 889702e380c..8a4f0fd3698 100644
--- a/mysql-test/r/ctype_uca.result
+++ b/mysql-test/r/ctype_uca.result
@@ -2587,6 +2587,17 @@ SELECT c1 as want1result from t1 where c1 like 'location%';
want1result
location
DROP TABLE t1;
+create table t1 (a set('a') not null);
+insert into t1 values (),();
+select cast(a as char(1)) from t1;
+cast(a as char(1))
+
+
+select a sounds like a from t1;
+a sounds like a
+1
+1
+drop table t1;
DROP DATABASE d1;
USE test;
SET character_set_server= @safe_character_set_server;