[shardingsphere] branch master updated: #6872, use delete instead of truncate to improve performance

[menghaoran]

This is an automated email from the ASF dual-hosted git repository.

menghaoran pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/shardingsphere.git


The following commit(s) were added to refs/heads/master by this push:
     new 1b3215d  #6872, use delete instead of truncate to improve performance
     new 98275f6  Merge pull request #7333 from tuohai666/use_delete
1b3215d is described below

commit 1b3215d2c4c6736f38bdc843cc9de98419451ba0
Author: Zhang Yonglun <zhangyong...@apache.org>
AuthorDate: Tue Sep 8 21:08:58 2020 +0800

    #6872, use delete instead of truncate to improve performance
---
 .../shardingsphere/dbtest/env/dataset/DataSetEnvironmentManager.java    | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git 
a/shardingsphere-integration-test/shardingsphere-test-suite/src/test/java/org/apache/shardingsphere/dbtest/env/dataset/DataSetEnvironmentManager.java
 
b/shardingsphere-integration-test/shardingsphere-test-suite/src/test/java/org/apache/shardingsphere/dbtest/env/dataset/DataSetEnvironmentManager.java
index c56eedf..1ba6408 100644
--- 
a/shardingsphere-integration-test/shardingsphere-test-suite/src/test/java/org/apache/shardingsphere/dbtest/env/dataset/DataSetEnvironmentManager.java
+++ 
b/shardingsphere-integration-test/shardingsphere-test-suite/src/test/java/org/apache/shardingsphere/dbtest/env/dataset/DataSetEnvironmentManager.java
@@ -197,7 +197,7 @@ public final class DataSetEnvironmentManager {
             try (Connection connection = dataSource.getConnection()) {
                 for (String each : tableNames) {
                     String tableName = generateTableName(each, 
DatabaseTypes.getDatabaseTypeByURL(connection.getMetaData().getURL()));
-                    try (PreparedStatement preparedStatement = 
connection.prepareStatement(String.format("TRUNCATE TABLE %s", tableName))) {
+                    try (PreparedStatement preparedStatement = 
connection.prepareStatement(String.format("DELETE FROM %s", tableName))) {
                         preparedStatement.execute();
                     }
                 }