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 <[email protected]>
Authored: Fri Jul 20 13:10:30 2018 +0800
Committer: zlei929 <[email protected]>
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');
