db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel John Debrunner (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-448) delete on an empty table generates warning
Date Fri, 01 Feb 2008 21:35:08 GMT

    [ https://issues.apache.org/jira/browse/DERBY-448?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12564946#action_12564946
] 

Daniel John Debrunner commented on DERBY-448:
---------------------------------------------

Syntax errors (and any error that causes the statement to fail to complete) are SQLExceptions
and are thrown. Thus they are not returned through the getWarnings() mechanism.

The multiple 01003 issue is probably a bug, most likely the engine (not ij) should not be
creating multiple warnings, that should be a separate issue.

> delete on an empty table generates warning
> ------------------------------------------
>
>                 Key: DERBY-448
>                 URL: https://issues.apache.org/jira/browse/DERBY-448
>             Project: Derby
>          Issue Type: Bug
>          Components: Tools
>    Affects 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.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message