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.
2. WARNING should not be shown.

thx
Simmi.



-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

Reply via email to