modified:   core/sql/regress/core/EXPECTED038.LINUX
        modified:   core/sql/regress/core/TEST038


Project: http://git-wip-us.apache.org/repos/asf/trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/trafodion/commit/b0541920
Tree: http://git-wip-us.apache.org/repos/asf/trafodion/tree/b0541920
Diff: http://git-wip-us.apache.org/repos/asf/trafodion/diff/b0541920

Branch: refs/heads/master
Commit: b054192046526e9569214f9305ba98d27595358d
Parents: 153368d
Author: zlei929 <z_lei...@163.com>
Authored: Fri Jul 20 13:10:30 2018 +0800
Committer: zlei929 <z_lei...@163.com>
Committed: Fri Jul 20 13:10:30 2018 +0800

----------------------------------------------------------------------
 core/sql/regress/core/EXPECTED038.LINUX | 5 +++++
 core/sql/regress/core/TEST038           | 1 +
 2 files changed, 6 insertions(+)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/trafodion/blob/b0541920/core/sql/regress/core/EXPECTED038.LINUX
----------------------------------------------------------------------
diff --git a/core/sql/regress/core/EXPECTED038.LINUX 
b/core/sql/regress/core/EXPECTED038.LINUX
index aceb087..6fcb4e6 100644
--- a/core/sql/regress/core/EXPECTED038.LINUX
+++ b/core/sql/regress/core/EXPECTED038.LINUX
@@ -4723,6 +4723,11 @@ sc
          
 
 --- 4 row(s) selected.
+>>select split_part('sa:sbl:sc', ':', -4) from t038sf;
+
+*** ERROR[8691] Field position must be greater than zero, currently is -4.
+
+--- 0 row(s) selected.
 >>
 >>insert into T038sf values(110, 'a/b/c', 'sa/dsd/s');
 

http://git-wip-us.apache.org/repos/asf/trafodion/blob/b0541920/core/sql/regress/core/TEST038
----------------------------------------------------------------------
diff --git a/core/sql/regress/core/TEST038 b/core/sql/regress/core/TEST038
index 593822e..cad203e 100755
--- a/core/sql/regress/core/TEST038
+++ b/core/sql/regress/core/TEST038
@@ -1148,6 +1148,7 @@ select split_part('sa:sbl:sc', ':', 3) from t038sf;
 -- **EMPTY RESULT** 
 select split_part('sa:sbl:sc', ':', 0) from t038sf;
 select split_part('sa:sbl:sc', ':', 4) from t038sf;
+select split_part('sa:sbl:sc', ':', -4) from t038sf;
 
 insert into T038sf values(110, 'a/b/c', 'sa/dsd/s');
 insert into T038sf values(111, 'sasd', 'dsa:/~sd');

Reply via email to