db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jeremy Boynes (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-448) delete on an empty table generates warning
Date Fri, 08 Jul 2005 15:56:10 GMT
    [ http://issues.apache.org/jira/browse/DERBY-448?page=comments#action_12315317 ] 

Jeremy Boynes commented on DERBY-448:
-------------------------------------

The SQL spec says the no data condition must be raised if no rows are deleted so the engine
is correct here.

The definition of <direct select statement: multiple rows> also says that a no data
condition is raised if the result of the query is empty so if we aren't raising a warning
there I think we should.

> 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