3 Commits

Author	SHA1	Message	Date
Dave Gosselin	e25edf2f46	MDEV-33616 Tests failing on macOS ... compat/oracle.sp-inout now uses lowercase object names for test compatibility with both case-insensitive and case-sensitive filesystems.	2024-04-24 08:44:24 -04:00
Oleksandr Byelkin	34a8e78581	Merge branch '10.6' into 10.9	2023-08-04 08:01:06 +02:00
ManoharKB	4572dc23f7	MDEV-10654 add support IN, OUT, INOUT parameter qualifiers for stored functions ... Problem: Currently stored function does not support IN/OUT/INOUT parameter qualifiers. This is needed for Oracle compatibility (sql_mode = ORACLE). Solution: Implemented parameter qualifier support to CREATE FUNCTION (reference: CREATE PROCEDURE) Implemented return by reference for OUT/INOUT parameters in execute_function() (reference: execute_procedure()) Files changed: sql/sql_yacc.yy: Added IN, OUT, INOUT parameter qualifiers for CREATE FUNCTION. sql/sp_head.cc: Added input and output parameter binding for IN/OUT/INOUT parameters in execute_function() so that OUT/INOUT can return by reference. sql/share/errmsg-utf8.txt: Added error message to restrict OUT/INOUT parameters while function being called from SQL query. mysql-test/suite/compat/oracle/t/sp-inout.test: Added test cases mysql-test/suite/compat/oracle/r/sp-inout.result: Added test results Reviewed-by: iqbal@hasprime.com	2022-01-24 19:46:27 +04:00