[CALCITE-1066] Add an extension operator table with Oracle-specific operators

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.7.0
• Labels: dialect
• Assignee: Julian Hyde
• Reporter: Julian Hyde
• Created: 23/Jan/16 23:49
• Updated: 09/Sep/24 20:24
• Resolved: 05/Mar/16 06:08

Description

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

Issue Links

• depends upon: CALCITE-1054 NPE caused by wrong code generation for Timestamp fields
• is related to: CALCITE-6566 JDBC adapter should generate PI function with parentheses in most dialects
• is related to: CALCITE-5451 Implement LPAD() and RPAD() functions
• links to: Dev branch