simmi iyer (JIRA) wrote:
delete on an empty table generates warning
------------------------------------------
Key: DERBY-448
URL: http://issues.apache.org/jira/browse/DERBY-448
Project: Derby
Type: Bug
Components: Build tools
Versions: 10.0.2.1
Environment: Solaris
Reporter: simmi iyer
1. Launch ij to connect to Derby using embedded driver.
2. Issue delete command at ij prompt
ij>delete from table ;
3. This generates a warning
0 rows inserted/updated/deleted
WARNING 02000: No row was found for FETCH, UPDATE or DELETE; or the result of a
query is an empty table.
There are two issues here:
1. It should say 0 rows deleted instead of 0 rows inserted/deleted/updated.
See, http://issues.apache.org/jira/browse/DERBY-105
thanks
Shreyas
2. WARNING should not be shown.
thx
Simmi.
