PL/SQL parser - Phase 2 (MDEV-10764)

[MDEV-10342] Providing compatibility for basic SQL built-in functions Created: 2016-07-07  Updated: 2023-10-04  Resolved: 2023-10-04

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: N/A

Type: Technical task Priority: Major
Reporter: Dmitry Tolpeko Assignee: Unassigned
Resolution: Incomplete Votes: 1
Labels: Compatibility

Issue Links:
Blocks
is blocked by MDEV-14012 sql_mode=Oracle: substr(): treat posi... Closed
is blocked by MDEV-20017 Implement TO_CHAR() Oracle compatible... Closed
Relates
relates to MCOL-4044 Built In SQL Functions not working wi... Closed
relates to MCOL-4587 sql_mode=ORACLE specific functions do... Closed
relates to MDEV-12685 Oracle-compatible function CHR() Closed
relates to MDEV-12783 sql_mode=ORACLE: Functions LENGTH() a... Closed
relates to MDEV-13863 sql_mode=ORACLE: DECODE does not trea... Closed
relates to MDEV-19488 sql_mode="oracle" - add Oracle functi... Closed
relates to MDEV-23005 sql_mode mixture: a table with DECODE... Open
relates to MDEV-23040 sql_mode mixture: a table with TRIM()... Open

 Description   

Support the following basic SQL built-in functions in MariaDB:

  • DECODE(exp, when, then, ...) – DONE
  • NVL(exp, replacement) – DONE
  • NVL2(exp1, exp2, exp3) – DONE
  • TRUNC(date [,fmt])
  • TO_CHAR 

    TO_CHAR(10)
    		 
    TO_CHAR(SYSTIMESTAMP,'DDMMYYYYHH24MISSFF')  - MDEV-20017
    		 
    TO_CHAR(BIZ_DATE,'yyyymmdd')

  • TO_DATE(str [, fmt [, 'nlsparam']])
  • SYSDATE
  • SYSTIMESTAMP
  • USER

Note, DECODE, NVL, NVL2, SYSTIMESTAMP are not reserved keywords in Oracle, while USER and SYSDATE are.
Generated at Thu Feb 08 07:41:29 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.