diff options
| author | unknown <bell@sanja.is.com.ua> | 2005-07-06 11:36:27 +0300 |
|---|---|---|
| committer | unknown <bell@sanja.is.com.ua> | 2005-07-06 11:36:27 +0300 |
| commit | 816556007447175fd2523dbb33c2bce7def73906 (patch) | |
| tree | 3e119ca218aa62ca741fef4649518202a2c85c32 /mysql-test/t/func_str.test | |
| parent | 7dbf02354a83f16f58bb5396da255f67f0a99696 (diff) | |
| parent | 2637338014fc335ea872b3c0ca85bb75bc309b51 (diff) | |
| download | mariadb-git-816556007447175fd2523dbb33c2bce7def73906.tar.gz | |
Merge
mysql-test/r/func_str.result:
SCCS merged
mysql-test/t/func_str.test:
SCCS merged
Diffstat (limited to 'mysql-test/t/func_str.test')
| -rw-r--r-- | mysql-test/t/func_str.test | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/t/func_str.test b/mysql-test/t/func_str.test index f5f9ddac3b5..668e865d73a 100644 --- a/mysql-test/t/func_str.test +++ b/mysql-test/t/func_str.test @@ -597,3 +597,12 @@ SELECT CONCAT_WS(' ', trackname, artistname) trackname, artistname WHERE CONCAT_WS(' ', trackname, artistname) LIKE '%In%'; DROP TABLE t1,t2,t3; + +# +# Correct length reporting from substring() (BUG#10269) +# +create table t1 (b varchar(5)); +insert t1 values ('ab'), ('abc'), ('abcd'), ('abcde'); +select *,substring(b,1),substring(b,-1),substring(b,-2),substring(b,-3),substring(b,-4),substring(b,-5) from t1; +select * from (select *,substring(b,1),substring(b,-1),substring(b,-2),substring(b,-3),substring(b,-4),substring(b,-5) from t1) t; +drop table t1; |