[ 
https://issues.apache.org/jira/browse/FLINK-19194?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

fa zheng updated FLINK-19194:
-----------------------------
    Description: 
If we run sql

{code:sql}
select split_index('ab-123"xyz\cd','-',1) ;
{code}
or

{code:sql}
select split('ab-123"xyz\cd','-')[2] ;
{code}

{noformat}
 in sql-client, we should get result 123"xyz\cd, not 123\"xyz\\cd 
{noformat}


  was:
If we run sql

{code:sql}
select split_index('ab-123"xyz\cd','-',1) ;
{code}
or

{code:sql}
select split('ab-123"xyz\cd','-')[2] ;
{code}

in sql-client, we should get result 123"xyz\cd, not 123\"xyz\\cd 


> The UDF split and split_index get wrong result 
> -----------------------------------------------
>
>                 Key: FLINK-19194
>                 URL: https://issues.apache.org/jira/browse/FLINK-19194
>             Project: Flink
>          Issue Type: Bug
>          Components: Table SQL / Runtime
>    Affects Versions: 1.10.0, 1.10.1
>            Reporter: fa zheng
>            Priority: Major
>
> If we run sql
> {code:sql}
> select split_index('ab-123"xyz\cd','-',1) ;
> {code}
> or
> {code:sql}
> select split('ab-123"xyz\cd','-')[2] ;
> {code}
> {noformat}
>  in sql-client, we should get result 123"xyz\cd, not 123\"xyz\\cd 
> {noformat}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to