diff options
author | unknown <gshchepa/uchum@gleb.loc> | 2007-06-18 17:08:56 +0500 |
---|---|---|
committer | unknown <gshchepa/uchum@gleb.loc> | 2007-06-18 17:08:56 +0500 |
commit | 751e32072f260a39d9c1b4ca2a5d80fff13ad925 (patch) | |
tree | 5a3f0331e4c22301ccc757da3090d947ac0d598d /mysql-test/r/func_str.result | |
parent | 200c69e3e6dd7a59796f1fd1ac78f90ec402a6c3 (diff) | |
parent | 6e315bfae2fdd147c901647bb28ed09359aa0add (diff) | |
download | mariadb-git-751e32072f260a39d9c1b4ca2a5d80fff13ad925.tar.gz |
Merge gleb.loc:/home/uchum/work/bk/5.0-opt
into gleb.loc:/home/uchum/work/bk/5.1-opt
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 | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/r/func_str.result b/mysql-test/r/func_str.result index 2622e070587..6fbb9c811a7 100644 --- a/mysql-test/r/func_str.result +++ b/mysql-test/r/func_str.result @@ -2470,4 +2470,20 @@ id 3 4 DROP TABLE t1; +SELECT SUBSTR('foo',1,0) FROM DUAL; +SUBSTR('foo',1,0) + +SELECT SUBSTR('foo',1,CAST(0 AS SIGNED)) FROM DUAL; +SUBSTR('foo',1,CAST(0 AS SIGNED)) + +SELECT SUBSTR('foo',1,CAST(0 AS UNSIGNED)) FROM DUAL; +SUBSTR('foo',1,CAST(0 AS UNSIGNED)) + +CREATE TABLE t1 (a varchar(10), len int unsigned); +INSERT INTO t1 VALUES ('bar', 2), ('foo', 0); +SELECT SUBSTR(a,1,len) FROM t1; +SUBSTR(a,1,len) +ba + +DROP TABLE t1; End of 5.0 tests |