[#MDEV-10654] IN, OUT, INOUT parameters in CREATE FUNCTION

As you can imagine a collection of tests outside the framework isn't easily consumable.

I pushed a commit to the end of your pull request (and is on your branch) that includes a sample test case.

$ mysql-test/mtr  mysql-test/suite/compat/oracle/t/func_inout.test

Logging: /home/dan/repos/mariadb-server-10.7/mysql-test/mariadb-test-run.pl  mysql-test/suite/compat/oracle/t/func_inout.test

vardir: /home/dan/repos/build-mariadb-server-10.7/mysql-test/var

Checking leftover processes...

Removing old var directory...

Creating var directory '/home/dan/repos/build-mariadb-server-10.7/mysql-test/var'...

Checking supported features...

MariaDB Version 10.7.1-MariaDB

 - SSL connections supported

 - binaries built with wsrep patch

Collecting tests...

Installing system database...

==============================================================================

TEST                                      RESULT   TIME (ms) or COMMENT

--------------------------------------------------------------------------

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019

SET sql_mode=ORACLE;

CREATE PACKAGE pkg2

AS

FUNCTION add_func4 (a IN INT, b IN INT, c OUT INT, d INOUT INT) RETURN INT;

END|

SHOW CREATE PACKAGE pkg2|

Package	pkg2

sql_mode	PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ORACLE,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS,NO_AUTO_CREATE_USER,SIMULTANEOUS_ASSIGNMENT

Create Package	CREATE DEFINER="root"@"localhost" PACKAGE "pkg2" AS

FUNCTION add_func4 (a IN INT, b IN INT, c OUT INT, d INOUT INT) RETURN INT;

END

character_set_client	latin1

collation_connection	latin1_swedish_ci

Database Collation	latin1_swedish_ci

CREATE PACKAGE BODY pkg2

AS

FUNCTION add_func4(a IN INT, b IN INT, c OUT INT, d INOUT INT) RETURN INT

AS

BEGIN

c := 100;

d := d + 1;

RETURN a + b;

END;

END|

SHOW CREATE PACKAGE BODY pkg2;

Package body	pkg2

sql_mode	PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ORACLE,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS,NO_AUTO_CREATE_USER,SIMULTANEOUS_ASSIGNMENT

Create Package Body	CREATE DEFINER="root"@"localhost" PACKAGE BODY "pkg2" AS

FUNCTION add_func4(a IN INT, b IN INT, c OUT INT, d INOUT INT) RETURN INT

AS

BEGIN

c := 100;

d := d + 1;

RETURN a + b;

END;

END

character_set_client	latin1

collation_connection	latin1_swedish_ci

Database Collation	latin1_swedish_ci

DROP PACKAGE pkg2;

compat/oracle.func_inout                 [ pass ]      2

PL/SQL parser - Phase 2 (MDEV-10764) [MDEV-10654] IN, OUT, INOUT parameters in CREATE FUNCTION Created: 2016-08-24 Updated: 2023-03-21 Resolved: 2022-01-24
Status:	Closed
Project:	MariaDB Server
Component/s:	Parser, Stored routines
Affects Version/s:	None
Fix Version/s:	10.8.1