very strange limit in stored function return param
---------------------------------------------------
Key: CORE-5595
URL: http://tracker.firebirdsql.org/browse/CORE-5595
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0.2
Environment: Test on FB302w64
Reporter: Holger Klemt
Priority: Minor
just tried to use a udf replacement using the stored function and received
very strange out of memory errors from firebird 3.0.2
can be easy reproduced when creating this function in an empty fb302 database
CREATE OR ALTER FUNCTION RTRIM (
S1 VARCHAR(32765))
RETURNS VARCHAR(10889)
AS
DECLARE VARIABLE S VARCHAR(32765);
begin
s=trim(S1);
return S;
end
when executing the following statement, the error "out of memory" is shown
workaround: change return declaration to VARCHAR(10888) or any other length
smaller than 10888 and all works fine.
(the exact number is always different when doing different statements
I think this is an error in the handling of expressions in stored functions
params, since when doing the same statement with trim insted of rtrim, all
works fine
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
