You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "Arina Ielchiieva (JIRA)" <ji...@apache.org> on 2016/03/01 09:27:18 UTC

[jira] [Created] (CALCITE-1115) Add support for translate (expession, from_string, to_string)

Arina Ielchiieva created CALCITE-1115:
-----------------------------------------

             Summary: Add support for translate (expession, from_string, to_string)
                 Key: CALCITE-1115
                 URL: https://issues.apache.org/jira/browse/CALCITE-1115
             Project: Calcite
          Issue Type: Improvement
    Affects Versions: 1.7.0
            Reporter: Arina Ielchiieva
            Assignee: Julian Hyde
             Fix For: next


Calcite follows the standard SQL reference.
SQL reference,  ISO/IEC 9075-2:2011(E), section 6.30

<character transliteration> ::=
  TRANSLATE <left paren> <character value expression>
USING <transliteration name> <right paren>

Need to add support for translate (expession, from_string, to_string) alternative syntax.
Ex: Add the Oracle-style TRANSLATE function to SqlStdOperatorTable
(call it say TRANSLATE3, since it has 3 parameters)





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