db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Eranda Sooriyabandara (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-268) Add Support for truncate table
Date Sat, 04 Sep 2010 05:48:34 GMT

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

eranda@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.


Mime
View raw message