[DERBY-4943] TRUNCATE TABLE docs should state that it doesn't work for temporary tables

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 10.7.1.1, 10.7.1.4, 10.8.1.2
• Fix Version/s: 10.8.1.2
• Component/s: Documentation
• Issue & fix info: Newcomer
• Assignee: Dag H. Wanvik
• Reporter: Dag H. Wanvik
• Created: 10/Dec/10 16:20
• Updated: 19/Apr/11 12:39
• Resolved: 13/Dec/10 22:49

Description

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.