db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dag H. Wanvik (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-268) Add Support for truncate table
Date Tue, 21 Sep 2010 18:56:41 GMT

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

Dag H. Wanvik commented on DERBY-268:
-------------------------------------

I haven't been following this issue closely, but allow me just a quick question.. Is it well
defined what would happen for open cursors (result sets), holdable, not holdable, when a table
is attempted truncated? forward-only, scrollable, updatable.. 

Cf SQL 2008, section 14.10 GR 2,3 onwards.

Note also GR 7: " If no rows are deleted from T, then a completion condition is raised: no
data."

Do we have/need a functional specification for this feature?

> Add Support for truncate table
> ------------------------------
>
>                 Key: DERBY-268
>                 URL: https://issues.apache.org/jira/browse/DERBY-268
>             Project: Derby
>          Issue Type: Improvement
>          Components: SQL
>            Reporter: Lance Andersen
>            Assignee: Eranda Sooriyabandara
>            Priority: Minor
>         Attachments: derby-268-01-ab-enableForInsaneBuilds.diff, derby-268-02-aa-permsTest.diff,
Derby-268.diff, tests.diff
>
>
> Adding support for truncate table command will aid to portability

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