[DERBY-2504] SQL warning "01501: The view V21VIEWTEST has been dropped" can be lost (ie. not seen when it should be)

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 10.2.1.6, 10.2.2.0, 10.3.1.4
• Component/s: SQL
• Labels: derby_triage10_5_2
• Urgency: Normal
• Assignee: Unassigned
• Reporter: Daniel John Debrunner
• Created: 30/Mar/07 00:49
• Updated: 15/Feb/11 21:08

Description

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.