db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Hillegas (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-2504) SQL warning "01501: The view V21VIEWTEST has been dropped" can be lost (ie. not seen when it should be)
Date Mon, 06 Jul 2009 19:21:14 GMT

     [ https://issues.apache.org/jira/browse/DERBY-2504?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Rick Hillegas updated DERBY-2504:
---------------------------------

    Urgency: Normal

Triaged for 10.5.2: assigned normal urgency.

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


Mime
View raw message