You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Whenever you prepare any of these statements
EXECUTE BLOCK (A RDB$FILE_NAME=?) AS BEGIN END
EXECUTE BLOCK AS DECLARE A RDB$FILE_NAME; BEGIN END
EXECUTE BLOCK AS DECLARE A INTEGER; DECLARE B VARCHAR(255); BEGIN B=CAST(A AS RDB$FILE_NAME); END
you will notice memory leak (e.g. in Windows Task Manager).
(in ISQL it is enough to "execute" the statements with SET PLANONLY ON)
The same statements with type names instead of domain names are o.k., e.g.
EXECUTE BLOCK (A INTEGER=?) AS BEGIN END
Just tested latest Firebird-3.0.0.30653 and its still there.
Also tested Execute Procedure instead of Execute Block, and it does not have the problem.
Sholuld I remove all domains from all my execute blocks, or is there chance to fix it soon ? (although I have most commands "permanently" prepared, those that are not easily cause memory leak of several GB during just couple of hours.)
Submitted by: prenosil (prenosil)
Whenever you prepare any of these statements
EXECUTE BLOCK (A RDB$FILE_NAME=?) AS BEGIN END
EXECUTE BLOCK AS DECLARE A RDB$FILE_NAME; BEGIN END
EXECUTE BLOCK AS DECLARE A INTEGER; DECLARE B VARCHAR(255); BEGIN B=CAST(A AS RDB$FILE_NAME); END
you will notice memory leak (e.g. in Windows Task Manager).
(in ISQL it is enough to "execute" the statements with SET PLANONLY ON)
The same statements with type names instead of domain names are o.k., e.g.
EXECUTE BLOCK (A INTEGER=?) AS BEGIN END
Commits: c62e9cf 0b51caa FirebirdSQL/fbt-repository@3d4420a FirebirdSQL/fbt-repository@eaeb34e
The text was updated successfully, but these errors were encountered: