[jira] [Commented] (ASTERIXDB-2651) Handle matching a literal backslash properly in LIKE

["ASF subversion and git services (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/ASTERIXDB-2651?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16951979#comment-16951979 ] 

ASF subversion and git services commented on ASTERIXDB-2651:
------------------------------------------------------------

Commit a14b016ba1645bef2d015843e15bdba6c1c2859d in asterixdb's branch refs/heads/master from Ali Alsuliman
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=a14b016 ]

[ASTERIXDB-2651][RT][FUN] Handle matching a literal backslash properly in LIKE

- user model changes: no
- storage format changes: no
- interface changes: no

Details:

- fixed an issue in the build() of RegExpMatcher where the "flags" argument gets ignored if the flags
  argument does not change in the subsequent evaluation of the regexp_* functions over the tuples of dataset.
- added the missing Java regex meta characters.
- split test case "regexp_replace" into two, "regexp_replace" & "regexp_replace_with_flag".

Change-Id: I4f218f87f0c1736e2d8b5de07221d7efa0f9aef1
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/3614
Integration-Tests: Jenkins <je...@fulliautomatix.ics.uci.edu>
Tested-by: Jenkins <je...@fulliautomatix.ics.uci.edu>
Reviewed-by: Ali Alsuliman <al...@gmail.com>
Reviewed-by: Dmitry Lychagin <dm...@couchbase.com>


> Handle matching a literal backslash properly in LIKE
> ----------------------------------------------------
>
>                 Key: ASTERIXDB-2651
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-2651
>             Project: Apache AsterixDB
>          Issue Type: Bug
>          Components: FUN - Functions
>    Affects Versions: 0.9.4
>            Reporter: Ali Alsuliman
>            Assignee: Ali Alsuliman
>            Priority: Major
>             Fix For: 0.9.5
>
>
> Fix matching a literal backslash in LIKE. As an example,
>   
> {code:java}
> SELECT "test\\string" LIKE "%\\\\%"
> {code}
> Also, fix the issue with a dynamic and changing pattern in regexp_*() functions (and functions using regex matcher class). Here is an example, for a dataset with the below tuples
> {code:java}
> { "id": 1, "test_str": "hello world", "pattern": "h"}
> { "id": 2, "test_str": "hello world", "pattern": "H"}
> FROM ds SELECT regexp_contains(test_str, pattern, "i"); -- "i" flag means case insenstive{code}



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