Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <10769090.101591292281681109.JavaMail.jira@thor>
Date: Mon, 13 Dec 2010 18:08:01 -0500 (EST)
From: "Dag H. Wanvik (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Commented: (DERBY-4943) TRUNCATE TABLE docs should state
 that it doesn't work for temporary tables
In-Reply-To: <22332894.60261291998061781.JavaMail.jira@thor>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


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

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

Backported fix to 10.7 branch as svn 1045415.


> TRUNCATE TABLE docs should state that it doesn't work for temporary tables
> --------------------------------------------------------------------------
>
>                 Key: DERBY-4943
>                 URL: https://issues.apache.org/jira/browse/DERBY-4943
>             Project: Derby
>          Issue Type: Bug
>          Components: Documentation
>    Affects Versions: 10.7.1.1, 10.7.1.2, 10.8.0.0
>            Reporter: Dag H. Wanvik
>            Assignee: Dag H. Wanvik
>            Priority: Minor
>             Fix For: 10.8.0.0
>
>         Attachments: derby-4943-a.diff, rrefsqljtruncatetable.html
>
>
> ij> declare global temporary table t(i int) on commit preserve rows not logged;
> 0 rows inserted/updated/deleted
> ij> insert into session.t values 1,2,3,4,5,6,7,8,9,10;
> 10 rows inserted/updated/deleted
> ij> truncate table session.t;
> ERROR 42995: The requested function does not apply to global temporary tables.
> This limitation is not documented presently.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.