PL/SQL parser (MDEV-10142)

[MDEV-12143] sql_mode=ORACLE: Make the CONCAT function ignore NULL arguments Created: 2017-02-27  Updated: 2018-08-31  Resolved: 2017-02-27

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

Type: Technical task Priority: Major
Reporter: Alexander Barkov Assignee: Alexander Barkov
Resolution: Fixed Votes: 0
Labels: Compatibility

Issue Links:
Duplicate
is duplicated by MDEV-12076 CONCAT behavior with NULL is differen... Closed
Relates
relates to MDEV-11880 sql_mode=ORACLE: Make the concatenati... Closed
Sprint: 10.2.2-3, 10.2.2-1, 10.2.2-2, 10.2.2-4, 10.1.18

 Description   

Under terms of MDEV-11880, we fixed the concatenation operator || to ignore NULL arguments.

In addition to the concatenation operator, Oracle has also the function CONCAT with two arguments, so these two queries should be equivalent:

SELECT a||b FROM t1;
 
SELECT CONCAT(a,b) FROM t1;

The patch for MDEV-11880 changed only behavior of the concatenation operator ||.
Under terms of this task we'll also change CONCAT to ignore NULL arguments.

 Comments   
Comment by Alexander Barkov [ 2017-02-27 ]

Pushed to bb-10.2-compatibility

Comment by Alexander Barkov [ 2017-03-02 ]

Alvin, yes they are duplicates. I forgot that we already had the task and created a new one. Sorry for confusion.

Generated at Thu Feb 08 07:55:27 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.