[
https://issues.apache.org/jira/browse/CALCITE-1066?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15116262#comment-15116262
]
Julian Hyde commented on CALCITE-1066:
--------------------------------------
On my dev branch I have now implemented DECODE, NVL, LTRIM, RTRIM, GREATEST,
LEAST.
If folks would like to work on other functions, please pitch in!
DECODE is a little inefficient because I use 'is not distinct from' for each
searched value, to handle nulls correctly, and 'x is not distinct from y'
translates to 'case when x is null then y is not null when y is null then x is
not null else x = y end'. Maybe someone could work on simplifying that
expression.
> Add an extension operator table with Oracle-specific operators
> --------------------------------------------------------------
>
> Key: CALCITE-1066
> URL: https://issues.apache.org/jira/browse/CALCITE-1066
> Project: Calcite
> Issue Type: Bug
> Reporter: Julian Hyde
> Assignee: Julian Hyde
>
> Add a mechanism to allow connections to use additional operator tables, the
> first of which will be one with Oracle-specific functions. We don't aim to do
> every function.
> Important functions:
> * DECODE
> * NVL
> * RTRIM
> * LTRIM
> * LPAD
> * RPAD
> * TO_CHAR
> * TO_NUMBER
> * TO_DATE
> * TRUNC
> * SUBSTR (different from standard SUBSTRING)
> * INSTR
> Easy:
> * PI
> * DEGREES
> * RADIANS
> * SIGN
> * GREATEST
> * LEAST
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
