[jira] [Created] (DRILL-4688) String functions may produce incorrect result when input has multi-byte character

["Jinfeng Ni (JIRA)" <ji...@apache.org>]

Jinfeng Ni created DRILL-4688:
---------------------------------

             Summary: String functions may produce incorrect result when input has multi-byte character
                 Key: DRILL-4688
                 URL: https://issues.apache.org/jira/browse/DRILL-4688
             Project: Apache Drill
          Issue Type: Bug
            Reporter: Jinfeng Ni
            Priority: Critical


As discussed in DRILL-4573, the patch of DRILL-4573 would cause regression  of query correctness, when the input, encoded as utf-8, contains multi-byte characters.

For example,

{code:sql}
select regexp_matches('München', 'München') res3 from (values(1));
+--------+
| res3 |
+--------+
| false |
+--------+
{code}

Here is the result before the patch of DRILL-4573. 
 
{code}
select regexp_matches('München', 'München') res3 from (values(1));
+-------+
| res3 |
+-------+
| true |
+-------+
{code}

Once this issue has been resolved, QA would add functional testcases to cover the case of multip-byte characters, so that we will be able to catch such regression in the first place in the future.





--
This message was sent by Atlassian JIRA
(v6.3.4#6332)