[jira] Commented: (DERBY-3102) Statements are not removed from the cache, even when they are of no use, e.g. statements that reference a dropped table.

["Daniel John Debrunner (JIRA)" <ji...@apache.org>]

    [ 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.