[jira] [Commented] (ASTERIXDB-2657) Add 1-based string functions and 0-based aliases for existing string functions

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

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

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

Commit 2a76a0fe83fc5534c00923cd0f09f8477eac713a in asterixdb's branch refs/heads/master from Hussain Towaileb
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=2a76a0f ]

[ASTERIXDB-2657][FUN] String 1-based functions + function aliases

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

Details:
- Removed compiler property compiler.stringoffset.
- Add 1-based string function to the following functions:
  position, regex_position
- Add aliases to the following functions:
  position, substring, regex_contains, regex_like,
  regex_position, regex_replace
- Add test cases for the above mentioned functions and
  aliases.

Change-Id: I0df799f197e430a9cd7d1b2a45e372a0cd77347e
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/3643
Tested-by: Jenkins <je...@fulliautomatix.ics.uci.edu>
Integration-Tests: Jenkins <je...@fulliautomatix.ics.uci.edu>
Reviewed-by: Hussain Towaileb <hu...@gmail.com>


> Add 1-based string functions and 0-based aliases for existing string functions
> ------------------------------------------------------------------------------
>
>                 Key: ASTERIXDB-2657
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-2657
>             Project: Apache AsterixDB
>          Issue Type: Bug
>          Components: FUN - Functions
>    Affects Versions: 0.9.4.1
>            Reporter: Hussain Towaileb
>            Assignee: Hussain Towaileb
>            Priority: Major
>             Fix For: 0.9.5
>
>
> String functions are currently 0-based (POSITION, etc).  We need to create 1-based string functions (POSITION1, etc), and 0-based aliases (POSITION0, etc)
> Here's the list of functions/aliases the need to be implemented:
> POS (= POSITION)
> POSITION0 (=POSITION)
> POS0 (=POSITION)
> POSITION1 
> POS1 (=POSITION1)
> SUBSTR0 (=SUBSTR)
> SUBSTR1
> CONTAINS_REGEX (=REGEXP_CONTAINS)
> CONTAINS_REGEXP (=REGEXP_CONTAINS)
> REGEX_CONTAINS (=REGEXP_CONTAINS)
> REGEX_LIKE (=REGEXP_LIKE)
> REGEX_POSITION0 (=REGEXP_POSITION0)
> REGEX_POS0 (=REGEXP_POSITION0)
> REGEXP_POSITION0
> REGEXP_POS0 (=REGEXP_POSITION0)
> REGEX_POSITION1 (=REGEXP_POSITION1)
> REGEX_POS1 (=REGEXP_POSITION1)
> REGEXP_POSITION1 
> REGEXP_POS1 (=REGEXP_POSITION1)
> REGEX_POSITION (=REGEXP_POSITION0)
> REGEX_POS (=REGEXP_POSITION0)
> REGEX_REPLACE (=REGEXP_REPLACE)
> REGEXP_POSITION (=REGEXP_POSITION0)
> REGEXP_POS (=REGEXP_POSITION0)



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