diff options
| author | unknown <igor@rurik.mysql.com> | 2004-11-04 20:39:52 -0800 |
|---|---|---|
| committer | unknown <igor@rurik.mysql.com> | 2004-11-04 20:39:52 -0800 |
| commit | 62ded37e365041e315f0f6317bdeda99f7a55ad0 (patch) | |
| tree | d391297d0aa15aa8b3ffb743dd1af8b6b38edca3 /mysql-test | |
| parent | 7f3749c82ff55deb4f25626084b242ce6c2306e1 (diff) | |
| download | mariadb-git-62ded37e365041e315f0f6317bdeda99f7a55ad0.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.
sql/item_cmpfunc.cc:
Fixed bug #6365 : Server crash when list of values
in IN predicate contains NULL while the tested field is
of the character type of 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.
mysql-test/t/func_in.test:
Added a case for bug #6365.
mysql-test/r/func_in.result:
Added a case for bug #6365.
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/func_in.result | 6 | ||||
| -rw-r--r-- | mysql-test/t/func_in.test | 7 |
2 files changed, 13 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; diff --git a/mysql-test/t/func_in.test b/mysql-test/t/func_in.test index 22079377ad2..3cd8c064817 100644 --- a/mysql-test/t/func_in.test +++ b/mysql-test/t/func_in.test @@ -89,3 +89,10 @@ select 1 in ('1.0',2.0); select 1 in (1.0,'2.0'); select 1 in ('1.1',2); select 1 in ('1.1',2.0); + +# Test case for bug #6365 + +create table t1 (a char(20) character set binary); +insert into t1 values ('aa'), ('bb'); +select * from t1 where a in (NULL, 'aa'); +drop table t1; |