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

[MDEV-11210] %TYPE in stored function RETURN data type Created: 2016-11-02  Updated: 2023-10-20

Status: Open
Project: MariaDB Server
Component/s: Parser
Affects Version/s: 10.3
Fix Version/s: None

Type: Technical task Priority: Major
Reporter: Alexander Barkov Assignee: Unassigned
Resolution: Unresolved Votes: 3
Labels: None

Issue Links:
Duplicate
is duplicated by MDEV-17057 %TYPE not working for function return... Closed
Relates
relates to MDEV-10914 ROW data type for stored routine vari... Closed

 Description   

The task MDEV-10577 implements using %TYPE for stored routine local variables and parameters.

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

DROP TABLE t1;
 
DROP FUNCTION f1;
 
CREATE TABLE t1 (a INT);
 
CREATE FUNCTION f1 RETURN t1.a%TYPE
 
AS
 
BEGIN
 
  RETURN 0;
 
END;
 
/
 
SELECT f1() FROM DUAL;


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