diff options
| author | igor@rurik.mysql.com <> | 2004-11-04 20:39:52 -0800 |
|---|---|---|
| committer | igor@rurik.mysql.com <> | 2004-11-04 20:39:52 -0800 |
| commit | 4df18b1aaebc408c1f60a8c155121d7350e28c94 (patch) | |
| tree | d391297d0aa15aa8b3ffb743dd1af8b6b38edca3 /mysql-test/r/func_in.result | |
| parent | 31962735902dfee0c8983af504c024926f7d3824 (diff) | |
| download | mariadb-git-4df18b1aaebc408c1f60a8c155121d7350e28c94.tar.gz | |
func_in.result, func_in.test:
Added a case for bug #6365.
item_cmpfunc.cc:
Fixed bug #6365 : Server crashed when list of values
in IN predicate contains NULL while the tested field is
of the character type and not of the default set;
e.g. when f in 'f IN (NULL,'aa') belongs to binary
character set, while the default character set is latin1.
Diffstat (limited to 'mysql-test/r/func_in.result')
| -rw-r--r-- | mysql-test/r/func_in.result | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/r/func_in.result b/mysql-test/r/func_in.result index 374affce8c5..daeda51a12a 100644 --- a/mysql-test/r/func_in.result +++ b/mysql-test/r/func_in.result @@ -179,3 +179,9 @@ select 1 in ('1.1',2); select 1 in ('1.1',2.0); 1 in ('1.1',2.0) 0 +create table t1 (a char(20) character set binary); +insert into t1 values ('aa'), ('bb'); +select * from t1 where a in (NULL, 'aa'); +a +aa +drop table t1; |