diff options
| author | unknown <hf@deer.(none)> | 2003-07-03 23:24:23 +0500 |
|---|---|---|
| committer | unknown <hf@deer.(none)> | 2003-07-03 23:24:23 +0500 |
| commit | 33c416f67e6ba11ca1e21888be6cd9c0cc647813 (patch) | |
| tree | 1fe0dfdc51ca6c291c4889661490603f58cecd73 /mysql-test/r/func_str.result | |
| parent | fd0ecf1e47baca9e288e8cf038ca731962afdf14 (diff) | |
| download | mariadb-git-33c416f67e6ba11ca1e21888be6cd9c0cc647813.tar.gz | |
Fix for #739
check for negative count in RPAD added
mysql-test/r/func_str.result:
Appropriate result
mysql-test/t/func_str.test:
testcase added
sql/item_strfunc.cc:
we return NULL if count < 0
Diffstat (limited to 'mysql-test/r/func_str.result')
| -rw-r--r-- | mysql-test/r/func_str.result | 10 |
1 files changed, 10 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; |