diff options
| author | unknown <venu@myvenu.com> | 2003-07-11 18:56:39 -0700 |
|---|---|---|
| committer | unknown <venu@myvenu.com> | 2003-07-11 18:56:39 -0700 |
| commit | 2bc79e0876d1456471a2c66bf7edc7da546e99cf (patch) | |
| tree | 2b2e1aabf865029fd4926f655bbec5299c6162e0 /mysql-test | |
| parent | d1d636de8fa3438b1bff24a13bd74c6e8ca399f2 (diff) | |
| parent | a5ce6a49dd0dc782e225d24735b1af40ed8e3b18 (diff) | |
| download | mariadb-git-2bc79e0876d1456471a2c66bf7edc7da546e99cf.tar.gz | |
Merge
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/func_str.result | 21 | ||||
| -rw-r--r-- | mysql-test/t/func_str.test | 11 |
2 files changed, 32 insertions, 0 deletions
diff --git a/mysql-test/r/func_str.result b/mysql-test/r/func_str.result index c2a921e1a54..611660675c8 100644 --- a/mysql-test/r/func_str.result +++ b/mysql-test/r/func_str.result @@ -532,3 +532,24 @@ t1 CREATE TABLE `t1` ( `replace(_latin2'abcd',_latin2'b',_latin2'B')` char(4) character set latin2 NOT NULL default '' ) TYPE=MyISAM CHARSET=latin1 drop table t1; +select SUBSTR('abcdefg',3,2); +SUBSTR('abcdefg',3,2) +cd +select SUBSTRING('abcdefg',3,2); +SUBSTRING('abcdefg',3,2) +cd +select SUBSTR('abcdefg',-3,2) FROM DUAL; +SUBSTR('abcdefg',-3,2) +ef +select SUBSTR('abcdefg',-1,5) FROM DUAL; +SUBSTR('abcdefg',-1,5) +g +select SUBSTR('abcdefg',0,0) FROM DUAL; +SUBSTR('abcdefg',0,0) + +select SUBSTR('abcdefg',-1,-1) FROM DUAL; +SUBSTR('abcdefg',-1,-1) + +select SUBSTR('abcdefg',1,-1) FROM DUAL; +SUBSTR('abcdefg',1,-1) + diff --git a/mysql-test/t/func_str.test b/mysql-test/t/func_str.test index c9e7b1a529d..1fabd997366 100644 --- a/mysql-test/t/func_str.test +++ b/mysql-test/t/func_str.test @@ -294,3 +294,14 @@ select ; show create table t1; drop table t1; + +# +# test for SUBSTR +# +select SUBSTR('abcdefg',3,2); +select SUBSTRING('abcdefg',3,2); +select SUBSTR('abcdefg',-3,2) FROM DUAL; +select SUBSTR('abcdefg',-1,5) FROM DUAL; +select SUBSTR('abcdefg',0,0) FROM DUAL; +select SUBSTR('abcdefg',-1,-1) FROM DUAL; +select SUBSTR('abcdefg',1,-1) FROM DUAL; |