diff options
| author | unknown <msvensson@pilot.blaudden> | 2007-03-28 09:34:04 +0200 |
|---|---|---|
| committer | unknown <msvensson@pilot.blaudden> | 2007-03-28 09:34:04 +0200 |
| commit | 2473c35960d540950215c2e12d3f533ce33c9cba (patch) | |
| tree | 6744c0f02cd85c7f8eb60dc91905a0354eb7b466 /mysql-test | |
| parent | 563a50770e5a079c8415d587eb8a0ecbc21246c4 (diff) | |
| parent | e9b606bf3e0ccc9d9ff27541371cc5faf72dd813 (diff) | |
| download | mariadb-git-2473c35960d540950215c2e12d3f533ce33c9cba.tar.gz | |
Merge pilot.blaudden:/home/msvensson/mysql/bug25197/my50-bug25197
into pilot.blaudden:/home/msvensson/mysql/mysql-5.0-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 e06e7ffe00c..92265c77984 100644 --- a/mysql-test/r/func_str.result +++ b/mysql-test/r/func_str.result @@ -1964,6 +1964,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 d42be70c057..0e4b404fe3a 100644 --- a/mysql-test/t/func_str.test +++ b/mysql-test/t/func_str.test @@ -1038,6 +1038,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; # |