[
https://issues.apache.org/jira/browse/DERBY-2504?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12485392
]
Daniel John Debrunner commented on DERBY-2504:
----------------------------------------------
This is because the ViewDescriptor.makeInvalid() is using the
getLastActivation() method on LanguageConnectionContext.
At runtime there is no guarantee that the currently executing statement is the
last activation.
I just noticed this because the getLastActivation() method caught my eye, I
couldn't see any valid reason for such a method, it should be removed as part
of this bug fix.
> SQL warning "01501: The view V21VIEWTEST has been dropped" can be lost (ie.
> not seen when it should be)
> --------------------------------------------------------------------------------------------------------
>
> Key: DERBY-2504
> URL: https://issues.apache.org/jira/browse/DERBY-2504
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.2.1.6, 10.2.2.0, 10.3.0.0
> Reporter: Daniel John Debrunner
> Priority: Minor
>
> Example, grantRevokeDDL test has this SQL and correct output:
> revoke select on t11ViewTest from public;
> 0 rows inserted/updated/deleted
> WARNING 01501: The view V21VIEWTEST has been dropped.
> But if instead the statement is prepared and another statement prepared
> before the execution then the warning will not appear
> prepare R1 as 'revoke select on t11ViewTest from public';
> ij(MAMTA1)> prepare V1 as 'values 1';
> ij(MAMTA1)> execute R1;
> 0 rows inserted/updated/deleted
> ij(MAMTA1)> execute V1;
> 1
> -----------
> 1
> 1 row selected
> If I don't prepare V1 then the exception is seen, so it's not the prepare
> causing the issue.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
