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

[MDEV-12252] ROW data type for stored function return values Created: 2017-03-14  Updated: 2024-02-03

Status: In Review
Project: MariaDB Server
Component/s: Parser, Stored routines
Affects Version/s: None
Fix Version/s: 11.5

Type: Technical task Priority: Critical
Reporter: Alexander Barkov Assignee: Sergei Golubchik
Resolution: Unresolved Votes: 3
Labels: None

Issue Links:
Blocks
blocks MDEV-12308 Accessing ROW type function fields Open
is blocked by MDEV-4912 Data type plugin API version 1 Closed
is blocked by MDEV-10914 ROW data type for stored routine vari... Closed
Relates
relates to MDEV-12307 ROW data type for built-in function r... Stalled
relates to MDEV-23353 Qualified data types in SP Open
relates to MDEV-31250 ROW variables do not get assigned fro... Closed
relates to MDEV-32380 Array data type for stored routnes Stalled

 Description   

The task MDEV-10914 implements the ROW data type for stored routine local variables and parameters.

This task will additionally allow to use ROW in stored function return data type.

DROP FUNCTION IF EXISTS f1;
 
DELIMITER $$
 
CREATE FUNCTION f1(a INT, b VARCHAR(32)) RETURNS ROW(a INT, b VARCHAR(32))
 
BEGIN
 
  RETURN ROW(a,b);
 
END;
 
$$
 
DELIMITER ;
 
SELECT f1(1,'b1') = ROW(1,'b1');



 Comments   
Comment by Alexander Barkov [ 2023-12-04 ]

Hi serg,
Can you please review:
https://github.com/MariaDB/server/commit/388b72578cdee7afbd0403e94077ee90ed648008
?
Thanks.

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