db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "simmi iyer (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-448) delete on an empty table generates warning
Date Mon, 11 Jul 2005 04:40:10 GMT
    [ http://issues.apache.org/jira/browse/DERBY-448?page=comments#action_12315460 ] 

simmi iyer commented on DERBY-448:
----------------------------------

Design wise, ij might be doing the right thing but from a user's perspective, the message
is really misleading.

The message should be just "0 rows deleted". 

Getting an output with inserted/updated/deleted when a delete was issued and generating a
WARNING does not seem to be the right thing . Technically it might be just displaying the
JDBC output but some filtering needs to be done to make the message apt.

> 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


Mime
View raw message