diff options
| author | unknown <msvensson@pilot.blaudden> | 2007-03-28 09:33:16 +0200 |
|---|---|---|
| committer | unknown <msvensson@pilot.blaudden> | 2007-03-28 09:33:16 +0200 |
| commit | cce2cb5733909279d6ff2b1687b1082a8035fd58 (patch) | |
| tree | 70ad22a58fe62de3be7b97b8eba11811ac842666 /mysql-test/r/func_str.result | |
| parent | 7c152303c62b4d812552e3dc476f6ada5a307cc4 (diff) | |
| parent | e9b606bf3e0ccc9d9ff27541371cc5faf72dd813 (diff) | |
| download | mariadb-git-cce2cb5733909279d6ff2b1687b1082a8035fd58.tar.gz | |
Merge pilot.blaudden:/home/msvensson/mysql/bug25197/my50-bug25197
into pilot.blaudden:/home/msvensson/mysql/bug25197/my51-bug25197
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/r/func_str.result')
| -rw-r--r-- | mysql-test/r/func_str.result | 23 |
1 files changed, 23 insertions, 0 deletions
diff --git a/mysql-test/r/func_str.result b/mysql-test/r/func_str.result index e6c323276ea..f5c1c5cfe39 100644 --- a/mysql-test/r/func_str.result +++ b/mysql-test/r/func_str.result @@ -2273,4 +2273,27 @@ abcxx select lpad('abc', cast(5 as unsigned integer), 'x'); lpad('abc', cast(5 as unsigned integer), 'x') xxabc +DROP TABLE IF EXISTS t1; +CREATE TABLE `t1` ( +`id` varchar(20) NOT NULL, +`tire` tinyint(3) unsigned NOT NULL, +PRIMARY KEY (`id`) +); +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`; +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; End of 5.0 tests |