[ https://issues.apache.org/jira/browse/DERBY-3102?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12532297 ]
Daniel John Debrunner commented on DERBY-3102: ---------------------------------------------- Is this a bug or an improvement? I would say improvement as no incorrect behaviour occurs to due the plans being left in the cache. If it's a bug then I would say it's minor, not major. > Statements are not removed from the cache, even when they are of no use, e.g. > statements that reference a dropped table. > ------------------------------------------------------------------------------------------------------------------------ > > Key: DERBY-3102 > URL: https://issues.apache.org/jira/browse/DERBY-3102 > Project: Derby > Issue Type: Bug > Components: SQL > Affects Versions: 10.3.1.4 > Reporter: Kathey Marsden > Attachments: TestCache.java > > > Dan pointed this out in DERBY-2344 and I thought it worthy of its own bug. > The attached program shows the number of statements in the cache growing even > though the table is dropped. > [C:/kmarsden/repro/DERBY-2344] java TestCache > number of cache entries: 5 > number of cache entries: 9 > number of cache entries: 13 > number of cache entries: 17 > number of cache entries: 21 > number of cache entries: 25 > number of cache entries: 29 > number of cache entries: 33 > number of cache entries: 37 > number of cache entries: 41 -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.