[jira] [Resolved] (CALCITE-420) Add REPLACE character string function

["Julian Hyde (JIRA)" <ji...@apache.org>]

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

Julian Hyde resolved CALCITE-420.
---------------------------------
       Resolution: Fixed
    Fix Version/s: 1.12.0

My remarks about javadoc no longer apply: I realized that we did not need an explicit class for the function, so removed it.

Fixed in http://git-wip-us.apache.org/repos/asf/calcite/commit/5184aa7b. Thanks for the PR, [~rictomm]!

> Add REPLACE character string function
> -------------------------------------
>
>                 Key: CALCITE-420
>                 URL: https://issues.apache.org/jira/browse/CALCITE-420
>             Project: Calcite
>          Issue Type: Bug
>            Reporter: Julian Hyde
>            Assignee: Julian Hyde
>              Labels: newbie
>             Fix For: 1.12.0
>
>
> Oracle and MSSQL have a REPLACE function (see http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions134.htm). It is not in the SQL standard, and in fact the standard has no equivalent function.
> Syntax:
> {code:sql}
> REPLACE(char, search_string [, replace_string])
> {code}
> REPLACE is not a reserved word. Therefore the implementation will need to add REPLACE to CommonNonReservedKeyWord() in the parser.
> Note that Drill and potentially other users of Optiq use REPLACE as part of CREATE OR REPLACE syntax. Careful not to break that.



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