diff options
| author | unknown <gluh@gluh.mysql.r18.ru> | 2004-09-11 15:48:23 +0400 |
|---|---|---|
| committer | unknown <gluh@gluh.mysql.r18.ru> | 2004-09-11 15:48:23 +0400 |
| commit | 9ecf15ed749782df0736dd8d355385b75a15c3c2 (patch) | |
| tree | 5aea81bb73ba1be0950c72662d025c2b4b67e1b7 /mysql-test | |
| parent | cd573513a3744adf86b68ffd50887baa9d12bbe1 (diff) | |
| download | mariadb-git-9ecf15ed749782df0736dd8d355385b75a15c3c2.tar.gz | |
Fix for bug #5513: FIND_IN_SET fails if set ends with a comma
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/func_set.result | 3 | ||||
| -rw-r--r-- | mysql-test/t/func_set.test | 5 |
2 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/r/func_set.result b/mysql-test/r/func_set.result index 2431406c128..ca6e0a8c319 100644 --- a/mysql-test/r/func_set.result +++ b/mysql-test/r/func_set.result @@ -64,3 +64,6 @@ find_in_set('a',binary 'A,B,C') select find_in_set(binary 'a', 'A,B,C'); find_in_set(binary 'a', 'A,B,C') 0 +select find_in_set('1','3,1,'); +find_in_set('1','3,1,') +2 diff --git a/mysql-test/t/func_set.test b/mysql-test/t/func_set.test index d669739bcb4..98ef1e07bfe 100644 --- a/mysql-test/t/func_set.test +++ b/mysql-test/t/func_set.test @@ -47,3 +47,8 @@ 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'); +# +# Bug5513:FIND_IN_SET fails if set ends with a comma +# +select find_in_set('1','3,1,'); + |