Some basic datatypes and functions in oracle compatibility mode do not work (MDEV-19162)

[MDEV-19488] sql_mode="oracle" - add Oracle function NVL Created: 2019-05-15  Updated: 2021-04-01  Resolved: 2021-03-18

Status: Closed
Project: MariaDB Server
Component/s: Parser
Affects Version/s: None
Fix Version/s: 10.3.0

Type: Technical task Priority: Major
Reporter: Austin Rutherford (Inactive) Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: Compatibility, Oracle

Issue Links:
Relates
relates to MDEV-10342 Providing compatibility for basic SQL... Closed

 Description   

Oracle has a regularly used function called NVL(expr1,expr2). It appears to be the same as mariadb expression IFNULL(expr1,expr2). This request is to create a NVL function for Oracle compatibility.

______

Syntax
The syntax for the NVL function in Oracle/PLSQL is:

NVL( string1, replace_with )
Parameters or Arguments
string1
The string to test for a null value.
replace_with
The value returned if string1 is null.
Returns
The NVL function returns a substitute value.

This task also included function NVL2(expr1,expr2,expr3)
If expr1 is TRUE .. then it returns exp2, otherwise returns expr3

 Comments   
Comment by Ian Gilfillan [ 2021-03-18 ]

This was done in MariaDB 10.3 - https://github.com/mariadb/server/commit/30bec863cf710f9135439f410e1c31e4df873fd1

Generated at Thu Feb 08 08:52:04 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.