[
https://issues.apache.org/jira/browse/DERBY-268?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12906226#action_12906226
]
Eranda Sooriyabandara commented on DERBY-268:
---------------------------------------------
Hi Rick,
It seems truncate table is working for me in the normal mode (without setting
the debug mode)
era...@eranda:~/Desktop/Derby/Derby-268/trunk/tests$ java
org.apache.derby.tools.ij
ij version 10.7
ij> connect 'jdbc:derby:MyDB';
ij> insert into t1 values(1),(2),(3),(4),(5),(6);
6 rows inserted/updated/deleted
ij> select * from t1;
A
-----------
1
2
3
4
5
6
6 rows selected
ij> truncate table t1;
0 rows inserted/updated/deleted
ij> select * from t1;
A
-----------
0 rows selected
ij>
What is the reason for this?
> 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
>
> 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.
