Subject Clear Query Cache Firebird 2.1
Author Christian Waldmann
Hello



I am developing stored procedures that are used in queries. It looks
like my test queries do not use the output of the newest version of my
stored procedure, but takes the result from the "query result cache" of
the database.



Stepping the procedure returns the expected results!



Does the altering of stored procedure not clear the corresponding query
cache?

Is there a command to clear the cache or to force a query to generate
new results?



I am using Firebird Version "WI-V2.1.2.18118 Firebird 2.1" and IBExpert
2009.03.25



Christian



[Non-text portions of this message have been removed]