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

[MDEV-12308] Accessing ROW type function fields Created: 2017-03-20  Updated: 2023-10-20

Status: Open
Project: MariaDB Server
Component/s: Parser, Stored routines
Affects Version/s: 11.4
Fix Version/s: None

Type: Technical task Priority: Major
Reporter: Alexander Barkov Assignee: Unassigned
Resolution: Unresolved Votes: 1
Labels: Compatibility

Issue Links:
Blocks
is blocked by MDEV-4912 Data type plugin API version 1 Closed
is blocked by MDEV-12252 ROW data type for stored function ret... In Review
is blocked by MDEV-12307 ROW data type for built-in function r... Stalled
PartOf
is part of MDEV-21086 New data types Open

 Description   

The following tasks:

  • MDEV-12307 ROW data type for built-in function return values
  • MDEV-12252 ROW data type for stored function return values
    will implement returning ROW type values from stored and SP functions.

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 ;

Under terms of this task will allow to use fields of the returned values directly:

SELECT f1(1,'b1').a;


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