[DERBY-105] drop table statement shows wrong message after dropping table

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 10.0.2.2
• Component/s: Tools
• Environment: generic
• Assignee: Unassigned
• Reporter: Amit Handa
• Created: 17/Dec/04 11:21
• Updated: 07/May/09 21:36

Description

If we drop a table using the ij tool,
it returns a message that "0 rows inserted/updated/deleted"
giving an impression as if the table is still there and some update has been done
(as if executed a DML statement) to the table, whereas this is not the case.

Note that the same message appears while we execute a DML(insert/update/delete) query on the table.
which further confuses the user as if a table hasn't been dropped and updations still happenning
on the table instead of dropping(and creating)

The same is the case when a table is created.

Rather it when a table is created

ij> create table temp(cv char(10));
0 rows inserted/updated/deleted <-- Wrong message
ij> select * from temp;
CV
----------

0 rows selected
ij> insert into temp values('a');
1 row inserted/updated/deleted
ij> drop table temp;
0 rows inserted/updated/deleted <-- Wrong message
ij>