diff options
| author | hf@deer.(none) <> | 2003-07-03 23:24:23 +0500 |
|---|---|---|
| committer | hf@deer.(none) <> | 2003-07-03 23:24:23 +0500 |
| commit | fd4a1d4e549d10ca36ce76a9a0e6c1ca8605332e (patch) | |
| tree | 1fe0dfdc51ca6c291c4889661490603f58cecd73 /mysql-test/t/func_str.test | |
| parent | b2769e279239cca52c3f264724286b052357ed14 (diff) | |
| download | mariadb-git-fd4a1d4e549d10ca36ce76a9a0e6c1ca8605332e.tar.gz | |
Fix for #739
check for negative count in RPAD added
Diffstat (limited to 'mysql-test/t/func_str.test')
| -rw-r--r-- | mysql-test/t/func_str.test | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/t/func_str.test b/mysql-test/t/func_str.test index 476629f98d3..5ea3654134b 100644 --- a/mysql-test/t/func_str.test +++ b/mysql-test/t/func_str.test @@ -137,3 +137,17 @@ INSERT INTO t1 VALUES (8,NULL,'real'); INSERT INTO t1 VALUES (9,NULL,'nowy'); SELECT elt(status_wnio,data_podp) FROM t1 GROUP BY wid; DROP TABLE t1; + +# +# test for #739 + +CREATE TABLE t1 ( + title text +) TYPE=MyISAM; + +INSERT INTO t1 VALUES ('Congress reconvenes in September to debate welfare and adult education'); +INSERT INTO t1 VALUES ('House passes the CAREERS bill'); + +SELECT CONCAT("</a>",RPAD("",(55 - LENGTH(title)),".")) from t1; + +DROP TABLE t1; |