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] Created: (DERBY-4943) TRUNCATE TABLE docs should state that it doesn't work for temporary tables
Date Fri, 10 Dec 2010 16:21:01 GMT
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
            Priority: Minor


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.


Mime
View raw message