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 | |
| parent | b2769e279239cca52c3f264724286b052357ed14 (diff) | |
| download | mariadb-git-fd4a1d4e549d10ca36ce76a9a0e6c1ca8605332e.tar.gz | |
Fix for #739
check for negative count in RPAD added
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/func_str.result | 10 | ||||
| -rw-r--r-- | mysql-test/t/func_str.test | 14 |
2 files changed, 24 insertions, 0 deletions
diff --git a/mysql-test/r/func_str.result b/mysql-test/r/func_str.result index 09818c14462..0bac5111a05 100644 --- a/mysql-test/r/func_str.result +++ b/mysql-test/r/func_str.result @@ -247,3 +247,13 @@ elt(status_wnio,data_podp) NULL NULL DROP TABLE t1; +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; +CONCAT("</a>",RPAD("",(55 - LENGTH(title)),".")) +NULL +</a>.......................... +DROP TABLE t1; 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; |