diff options
| author | Magnus Svensson <msvensson@mysql.com> | 2008-05-30 11:12:07 +0200 |
|---|---|---|
| committer | Magnus Svensson <msvensson@mysql.com> | 2008-05-30 11:12:07 +0200 |
| commit | 867b60e08be9887aa6b7a61b763f44edcca1c221 (patch) | |
| tree | 2c436ada208ddcfb89206130a251a9bc72631891 /mysql-test/t/func_concat.test | |
| parent | ecc6795c45fc676dca657d4144cc5e5a6ec47e70 (diff) | |
| parent | 14aef9781ad64ab89e1bf61ad8a09565f14f5147 (diff) | |
| download | mariadb-git-867b60e08be9887aa6b7a61b763f44edcca1c221.tar.gz | |
Merge 5.1->5.1-rpl
Fix paths and name of a few files to make it work with new mtr.pl
Diffstat (limited to 'mysql-test/t/func_concat.test')
| -rw-r--r-- | mysql-test/t/func_concat.test | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/t/func_concat.test b/mysql-test/t/func_concat.test index 5487ad9c56b..f2aa0d004e5 100644 --- a/mysql-test/t/func_concat.test +++ b/mysql-test/t/func_concat.test @@ -68,3 +68,13 @@ create table t1(f1 varchar(6)) charset=utf8; insert into t1 values ("123456"); select concat(f1, 2) a from t1 union select 'x' a from t1; drop table t1; + +# +# Bug #36488: regexp returns false matches, concatenating with previous rows +# +CREATE TABLE t1 (c1 varchar(100), c2 varchar(100)); +INSERT INTO t1 VALUES ('',''), ('','First'), ('Random','Random'); +SELECT * FROM t1 WHERE CONCAT(c1,' ',c2) REGEXP 'First.*'; +DROP TABLE t1; + +--echo # End of 5.0 tests |