db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Shreyas Kaushik <Shreyas.Kaus...@Sun.COM>
Subject Re: [jira] Created: (DERBY-448) delete on an empty table generates warning
Date Fri, 08 Jul 2005 07:53:22 GMT


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.
>
>
>
>  
>

Mime
View raw message