zhang.lei created TRAFODION-3136:
------------------------------------
Summary: Improve on split_part builtin-function
Key: TRAFODION-3136
URL: https://issues.apache.org/jira/browse/TRAFODION-3136
Project: Apache Trafodion
Issue Type: Improvement
Reporter: zhang.lei
Assignee: zhang.lei
{color:#FF0000}use like below descripyon:{color}
>>select split_part('sa:sbl:sc', ':', 1) from t038sf;
(EXPR)
---------
sa
--- 1 row(s) selected.
>>select split_part('sa:sbl:sc', ':', 2) from t038sf;
(EXPR)
---------
sbl
--- 1 row(s) selected.
>>select split_part('sa:sbl:sc', ':', 3) from t038sf;
(EXPR)
---------
sc
--- 1 row(s) selected.
>>
>>-- **ERROR**
>>select split_part('sa:sbl:sc', ':', 0) from t038sf;
*** ERROR[4497] The Third operand of split_part must be greater than 0
--- 0 row(s) selected.
>>–**EMPTY RESULT**
>>select split_part('sa:sbl:sc', ':', 4) from t038sf;
(EXPR)
---------
--- 1 row(s) selected.
>> create table T038sf(a int, b char(10), c varchar(30));
>>insert into T038sf values(110, 'a/b/c', 'sa/dsd/s');
--- 1 row(s) inserted.
>>insert into T038sf values(111, 'sasd', 'dsa:/~sd');
--- 1 row(s) inserted.
>>insert into T038sf values(112, '#$%$#@', 'dsasggggsad');
--- 1 row(s) inserted.
>>insert into T038sf values(114, 'a', '这是^中文：测试');
--- 1 row(s) inserted.
>>select split_part(c, '/', 2) from t038sf;
(EXPR)
------------------------------
dsd
~sd
--- 4 row(s) selected.
>>select split_part(c, 'ggg', 2) from t038sf;
(EXPR)
------------------------------
gsad
--- 4 row(s) selected.
>>select split_part(c, 'sd', 1) from t038sf;
(EXPR)
------------------------------
sa/d
dsa:/~
--- 4 row(s) selected.
>>select split_part(c, '：', 1) from t038sf;
(EXPR)
------------------------------
这是^中文
--- 4 row(s) selected.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
