diff options
| author | gluh@gluh.mysql.r18.ru <> | 2004-08-24 17:29:08 +0400 |
|---|---|---|
| committer | gluh@gluh.mysql.r18.ru <> | 2004-08-24 17:29:08 +0400 |
| commit | 1786a388e4ce0a476767aa71b749dace5473f035 (patch) | |
| tree | ec19864e831406b3c58ccbe4faa5688c2bcb36b3 /mysql-test | |
| parent | 7bfc78f573c271ff4dd8943747216e3333f9e286 (diff) | |
| download | mariadb-git-1786a388e4ce0a476767aa71b749dace5473f035.tar.gz | |
Fix for bug #4340: find_in_set is case insensitive even on binary operators(2nd version)
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/func_set.result | 9 | ||||
| -rw-r--r-- | mysql-test/t/func_set.test | 8 |
2 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/r/func_set.result b/mysql-test/r/func_set.result index eeeb216d142..9181fe9e54d 100644 --- a/mysql-test/r/func_set.result +++ b/mysql-test/r/func_set.result @@ -28,3 +28,12 @@ find_in_set("abc","abc") find_in_set("ab","abc") find_in_set("abcd","abc") select interval(null, 1, 10, 100); interval(null, 1, 10, 100) -1 +select find_in_set(binary 'a',binary 'A,B,C'); +find_in_set(binary 'a',binary 'A,B,C') +0 +select find_in_set('a',binary 'A,B,C'); +find_in_set('a',binary 'A,B,C') +0 +select find_in_set(binary 'a', 'A,B,C'); +find_in_set(binary 'a', 'A,B,C') +0 diff --git a/mysql-test/t/func_set.test b/mysql-test/t/func_set.test index 81f561989d5..a1ee293ae05 100644 --- a/mysql-test/t/func_set.test +++ b/mysql-test/t/func_set.test @@ -16,3 +16,11 @@ select elt(2,1),field(NULL,"a","b","c"); select find_in_set("","a,b,c"),find_in_set("","a,b,c,"),find_in_set("",",a,b,c"); select find_in_set("abc","abc"),find_in_set("ab","abc"),find_in_set("abcd","abc"); select interval(null, 1, 10, 100); + +# +# Bug4340: find_in_set is case insensitive even on binary operators +# + +select find_in_set(binary 'a',binary 'A,B,C'); +select find_in_set('a',binary 'A,B,C'); +select find_in_set(binary 'a', 'A,B,C'); |