summaryrefslogtreecommitdiff
path: root/mysql-test/r/func_in.result
diff options
context:
space:
mode:
authorunknown <bar@mysql.com>2005-01-20 16:08:27 +0400
committerunknown <bar@mysql.com>2005-01-20 16:08:27 +0400
commit95bf833e5d6c8600034f460a51334c1a39c0baa7 (patch)
tree2267dd2a921c7dee8c9919fcae300b4cbe552f57 /mysql-test/r/func_in.result
parent59a68b89647753d1460279c7eb0fcf8d4044036a (diff)
parent9241e34593c94ec65920026d689b118355356c3a (diff)
downloadmariadb-git-95bf833e5d6c8600034f460a51334c1a39c0baa7.tar.gz
Merge mysql.com:/usr/home/bar/mysql-4.1
into mysql.com:/usr/home/bar/mysql-5.0 mysql-test/r/func_in.result: Auto merged sql/item_cmpfunc.cc: Auto merged
Diffstat (limited to 'mysql-test/r/func_in.result')
-rw-r--r--mysql-test/r/func_in.result8
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/r/func_in.result b/mysql-test/r/func_in.result
index fa603fd16d5..f75fe0d1627 100644
--- a/mysql-test/r/func_in.result
+++ b/mysql-test/r/func_in.result
@@ -157,6 +157,14 @@ a
bbbb
цццц
drop table t1;
+create table t1 (a char(10) character set latin1 not null);
+insert into t1 values ('a'),('b'),('c');
+select a from t1 where a IN ('a','b','c') order by a;
+a
+a
+b
+c
+drop table t1;
set names latin1;
select '1.0' in (1,2);
'1.0' in (1,2)