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');