diff options
| author | unknown <gluh@gluh.mysql.r18.ru> | 2004-08-24 17:29:08 +0400 |
|---|---|---|
| committer | unknown <gluh@gluh.mysql.r18.ru> | 2004-08-24 17:29:08 +0400 |
| commit | 1868a53d2740bc126bc647ef3f443871c1a8cd21 (patch) | |
| tree | ec19864e831406b3c58ccbe4faa5688c2bcb36b3 /mysql-test/t/func_set.test | |
| parent | ad46a4b6a6320508504c8ef70a5047086249fa67 (diff) | |
| download | mariadb-git-1868a53d2740bc126bc647ef3f443871c1a8cd21.tar.gz | |
Fix for bug #4340: find_in_set is case insensitive even on binary operators(2nd version)
mysql-test/r/func_set.result:
Fix for bug #4340: find_in_set is case insensitive even on binary operators
mysql-test/t/func_set.test:
Fix for bug #4340: find_in_set is case insensitive even on binary operators
sql/item_func.cc:
Fix for bug #4340: find_in_set is case insensitive even on binary operators
Diffstat (limited to 'mysql-test/t/func_set.test')
| -rw-r--r-- | mysql-test/t/func_set.test | 8 |
1 files changed, 8 insertions, 0 deletions
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'); |