db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel John Debrunner (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-2504) SQL warning "01501: The view V21VIEWTEST has been dropped" can be lost (ie. not seen when it should be)
Date Fri, 30 Mar 2007 00:50:25 GMT
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.2.0, 10.2.1.6, 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.


Mime
View raw message