diff options
| author | Martin Hansson <mhansson@mysql.com> | 2009-06-16 16:36:15 +0200 |
|---|---|---|
| committer | Martin Hansson <mhansson@mysql.com> | 2009-06-16 16:36:15 +0200 |
| commit | aa8677bc32fd80ee9ab08717369d23a4ef011717 (patch) | |
| tree | 4e202e6d5e7d51dc49fb2e560a3ccd568144b324 /mysql-test/t/func_set.test | |
| parent | ed7f0f3023041cc1749077ad45cd5a8bb8fa784e (diff) | |
| download | mariadb-git-aa8677bc32fd80ee9ab08717369d23a4ef011717.tar.gz | |
Bug#45168: assertion with convert() and empty set value
The assertion in String::copy was added in order to avoid
valgrind errors when the destination was the same as the source.
Eased restriction to allow for the case when str == NULL.
mysql-test/r/func_set.result:
Bug#45168: Test result
mysql-test/t/func_set.test:
Bug#45168: Test case
sql/item_strfunc.cc:
Bug#45168: Code cleanup and grammar correction in comment
sql/sql_string.cc:
Bug#45168: Fix
Diffstat (limited to 'mysql-test/t/func_set.test')
| -rw-r--r-- | mysql-test/t/func_set.test | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/t/func_set.test b/mysql-test/t/func_set.test index 5f37cd2a13e..294efa8caf1 100644 --- a/mysql-test/t/func_set.test +++ b/mysql-test/t/func_set.test @@ -84,3 +84,16 @@ engine=myisam default charset=latin1; insert into t1 values (''),(null),(null),(''),(''),(''); select find_in_set(f1,f1) as a from t1,(select find_in_set(f1,f1) as b from t1) a; drop table t1; +# +# Bug#45168: assertion with convert() and empty set value +# +CREATE TABLE t1( a SET('a', 'b', 'c') ); +CREATE TABLE t2( a SET('a', 'b', 'c') ); + +INSERT INTO t1 VALUES ('d'); +INSERT INTO t2 VALUES (''); + +SELECT CONVERT( a USING latin1 ) FROM t1; +SELECT CONVERT( a USING latin1 ) FROM t2; + +DROP TABLE t1, t2; |