diff options
| author | unknown <msvensson@pilot.blaudden> | 2007-03-28 09:35:03 +0200 |
|---|---|---|
| committer | unknown <msvensson@pilot.blaudden> | 2007-03-28 09:35:03 +0200 |
| commit | 55883e9628d9419632bae1e0ab8c72d3e6ba97b9 (patch) | |
| tree | f2874939148ed07480219819763b67e1efbc8124 /mysql-test | |
| parent | d8ddc1aa833728a1bc685f313f1585299f0ebd51 (diff) | |
| parent | cce2cb5733909279d6ff2b1687b1082a8035fd58 (diff) | |
| download | mariadb-git-55883e9628d9419632bae1e0ab8c72d3e6ba97b9.tar.gz | |
Merge pilot.blaudden:/home/msvensson/mysql/bug25197/my51-bug25197
into pilot.blaudden:/home/msvensson/mysql/mysql-5.1-maint
mysql-test/r/func_str.result:
Auto merged
mysql-test/t/func_str.test:
Auto merged
sql/item_strfunc.cc:
Auto merged
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/func_str.result | 9 | ||||
| -rw-r--r-- | mysql-test/t/func_str.test | 4 |
2 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/r/func_str.result b/mysql-test/r/func_str.result index 8bc613be4c0..283327430ba 100644 --- a/mysql-test/r/func_str.result +++ b/mysql-test/r/func_str.result @@ -2297,6 +2297,15 @@ A B tire 0 # # 1 ## ## 2 +SELECT REPEAT('0', CAST(0 AS UNSIGNED)); +REPEAT('0', CAST(0 AS UNSIGNED)) + +SELECT REPEAT('0', -2); +REPEAT('0', -2) + +SELECT REPEAT('0', 2); +REPEAT('0', 2) +00 DROP TABLE t1; SELECT UNHEX('G'); UNHEX('G') diff --git a/mysql-test/t/func_str.test b/mysql-test/t/func_str.test index 849d39cfc32..ca78ced134b 100644 --- a/mysql-test/t/func_str.test +++ b/mysql-test/t/func_str.test @@ -1145,6 +1145,10 @@ INSERT INTO `t1` (`id`, `tire`) VALUES ('A', 0), ('B', 1),('C', 2); SELECT REPEAT( '#', tire ) AS A, REPEAT( '#', tire % 999 ) AS B, tire FROM `t1`; +SELECT REPEAT('0', CAST(0 AS UNSIGNED)); +SELECT REPEAT('0', -2); +SELECT REPEAT('0', 2); + DROP TABLE t1; # |