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

Reply via email to