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:
>  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:
For more information on JIRA, see:

View raw message