You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by du...@apache.org on 2021/10/22 00:25:37 UTC
[shardingsphere] branch master updated: support Administration
Statements sql parse REPAIR TABLE (#13197)
This is an automated email from the ASF dual-hosted git repository.
duanzhengqiang 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 2dc81c0 support Administration Statements sql parse REPAIR TABLE (#13197)
2dc81c0 is described below
commit 2dc81c0ae605525f3f5f6029fe72874b9ec63102
Author: liguoping <xd...@163.com>
AuthorDate: Fri Oct 22 08:24:47 2021 +0800
support Administration Statements sql parse REPAIR TABLE (#13197)
* repair table
* use collection tables
---
.../impl/MySQLDALStatementSQLVisitor.java | 5 +++-
.../core/database/visitor/SQLVisitorRule.java | 2 ++
.../mysql/dal/MySQLRepairTableStatement.java | 8 ++++++
.../asserts/statement/dal/DALStatementAssert.java | 7 ++++-
.../impl/MySQLOptimizeTableStatementAssert.java | 15 +++++------
...t.java => MySQLRepairTableStatementAssert.java} | 31 ++++++++++------------
.../jaxb/cases/domain/SQLParserTestCases.java | 6 +++++
.../dal/OptimizeTableStatementTestCase.java | 6 +++--
...Case.java => RepairTableStatementTestCase.java} | 10 ++++---
.../src/main/resources/case/dal/optimize.xml | 3 ++-
.../case/dal/{optimize.xml => repair.xml} | 7 ++---
.../optimize.xml => sql/supported/dal/repair.xml} | 8 +++---
12 files changed, 65 insertions(+), 43 deletions(-)
diff --git a/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-mysql/src/main/java/org/apache/shardingsphere/sql/parser/mysql/visitor/statement/impl/MySQLDALStatementSQLVisitor.java b/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-mysql/src/main/java/org/apache/shardingsphere/sql/parser/mysql/visitor/statement/impl/MySQLDALStatementSQLVisitor.java
index 4fe5b39..8d495b2 100644
--- a/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-mysql/src/main/java/org/apache/shardingsphere/sql/parser/mysql/visitor/statement/impl/MySQLDALStatementSQLVisitor.java
+++ b/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-mysql/src/main/java/org/apache/shardingsphere/sql/parser/mysql/visitor/statement/impl/MySQLDALStatementSQLVisitor.java
@@ -233,9 +233,12 @@ public final class MySQLDALStatementSQLVisitor extends MySQLStatementSQLVisitor
return new MySQLResetStatement();
}
+ @SuppressWarnings("unchecked")
@Override
public ASTNode visitRepairTable(final RepairTableContext ctx) {
- return new MySQLRepairTableStatement();
+ MySQLRepairTableStatement result = new MySQLRepairTableStatement();
+ result.getTables().addAll(((CollectionValue<SimpleTableSegment>) visit(ctx.tableList())).getValue());
+ return result;
}
@SuppressWarnings("unchecked")
diff --git a/shardingsphere-sql-parser/shardingsphere-sql-parser-engine/src/main/java/org/apache/shardingsphere/sql/parser/core/database/visitor/SQLVisitorRule.java b/shardingsphere-sql-parser/shardingsphere-sql-parser-engine/src/main/java/org/apache/shardingsphere/sql/parser/core/database/visitor/SQLVisitorRule.java
index e4f96d6..24315e8 100644
--- a/shardingsphere-sql-parser/shardingsphere-sql-parser-engine/src/main/java/org/apache/shardingsphere/sql/parser/core/database/visitor/SQLVisitorRule.java
+++ b/shardingsphere-sql-parser/shardingsphere-sql-parser-engine/src/main/java/org/apache/shardingsphere/sql/parser/core/database/visitor/SQLVisitorRule.java
@@ -276,6 +276,8 @@ public enum SQLVisitorRule {
CLONE("Clone", SQLStatementType.DAL),
+ REPAIR_TABLE("RepairTable", SQLStatementType.DAL),
+
CALL("Call", SQLStatementType.DML),
CHANGE_MASTER("ChangeMaster", SQLStatementType.RL),
diff --git a/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLRepairTableStatement.java b/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLRepairTableStatement.java
index 16f5f08..1a76b54 100644
--- a/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLRepairTableStatement.java
+++ b/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLRepairTableStatement.java
@@ -17,14 +17,22 @@
package org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.dal;
+import lombok.Getter;
import lombok.ToString;
+import org.apache.shardingsphere.sql.parser.sql.common.segment.generic.table.SimpleTableSegment;
import org.apache.shardingsphere.sql.parser.sql.common.statement.AbstractSQLStatement;
import org.apache.shardingsphere.sql.parser.sql.common.statement.dal.DALStatement;
import org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.MySQLStatement;
+import java.util.Collection;
+import java.util.LinkedList;
+
/**
* MySQL repair table statement.
*/
+@Getter
@ToString
public final class MySQLRepairTableStatement extends AbstractSQLStatement implements DALStatement, MySQLStatement {
+
+ private final Collection<SimpleTableSegment> tables = new LinkedList<>();
}
diff --git a/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/asserts/statement/dal/DALStatementAssert.java b/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/asserts/statement/dal/DALStatementAssert.java
index 0e436e1..3b75f07 100644
--- a/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/asserts/statement/dal/DALStatementAssert.java
+++ b/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/asserts/statement/dal/DALStatementAssert.java
@@ -28,6 +28,7 @@ import org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.dal.MySQ
import org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.dal.MySQLInstallComponentStatement;
import org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.dal.MySQLInstallPluginStatement;
import org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.dal.MySQLOptimizeTableStatement;
+import org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.dal.MySQLRepairTableStatement;
import org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.dal.MySQLSetResourceGroupStatement;
import org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.dal.MySQLShowColumnsStatement;
import org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.dal.MySQLShowCreateTableStatement;
@@ -49,6 +50,7 @@ import org.apache.shardingsphere.test.sql.parser.parameterized.asserts.statement
import org.apache.shardingsphere.test.sql.parser.parameterized.asserts.statement.dal.impl.InstallPluginStatementAssert;
import org.apache.shardingsphere.test.sql.parser.parameterized.asserts.statement.dal.impl.MySQLCreateResourceGroupStatementAssert;
import org.apache.shardingsphere.test.sql.parser.parameterized.asserts.statement.dal.impl.MySQLOptimizeTableStatementAssert;
+import org.apache.shardingsphere.test.sql.parser.parameterized.asserts.statement.dal.impl.MySQLRepairTableStatementAssert;
import org.apache.shardingsphere.test.sql.parser.parameterized.asserts.statement.dal.impl.MySQLSetResourceGroupStatementAssert;
import org.apache.shardingsphere.test.sql.parser.parameterized.asserts.statement.dal.impl.MySQLUseStatementAssert;
import org.apache.shardingsphere.test.sql.parser.parameterized.asserts.statement.dal.impl.SetParameterStatementAssert;
@@ -64,13 +66,14 @@ import org.apache.shardingsphere.test.sql.parser.parameterized.asserts.statement
import org.apache.shardingsphere.test.sql.parser.parameterized.asserts.statement.dal.impl.UninstallComponentStatementAssert;
import org.apache.shardingsphere.test.sql.parser.parameterized.asserts.statement.dal.impl.UninstallPluginStatementAssert;
import org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.SQLParserTestCase;
-import org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.dal.CreateResourceGroupStatementTestCase;
import org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.dal.CloneStatementTestCase;
+import org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.dal.CreateResourceGroupStatementTestCase;
import org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.dal.ExplainStatementTestCase;
import org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.dal.FlushStatementTestCase;
import org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.dal.InstallComponentStatementTestCase;
import org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.dal.InstallPluginStatementTestCase;
import org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.dal.OptimizeTableStatementTestCase;
+import org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.dal.RepairTableStatementTestCase;
import org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.dal.SetParameterStatementTestCase;
import org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.dal.SetResourceGroupStatementTestCase;
import org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.dal.ShowColumnsStatementTestCase;
@@ -142,6 +145,8 @@ public final class DALStatementAssert {
MySQLSetResourceGroupStatementAssert.assertIs(assertContext, (MySQLSetResourceGroupStatement) actual, (SetResourceGroupStatementTestCase) expected);
} else if (actual instanceof MySQLOptimizeTableStatement) {
MySQLOptimizeTableStatementAssert.assertIs(assertContext, (MySQLOptimizeTableStatement) actual, (OptimizeTableStatementTestCase) expected);
+ } else if (actual instanceof MySQLRepairTableStatement) {
+ MySQLRepairTableStatementAssert.assertIs(assertContext, (MySQLRepairTableStatement) actual, (RepairTableStatementTestCase) expected);
}
}
}
diff --git a/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/asserts/statement/dal/impl/MySQLOptimizeTableStatementAssert.java b/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/asserts/statement/dal/impl/MySQLOptimizeTableStatementAssert.java
index ba7af82..e2e33f7 100644
--- a/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/asserts/statement/dal/impl/MySQLOptimizeTableStatementAssert.java
+++ b/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/asserts/statement/dal/impl/MySQLOptimizeTableStatementAssert.java
@@ -21,14 +21,9 @@ import lombok.AccessLevel;
import lombok.NoArgsConstructor;
import org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.dal.MySQLOptimizeTableStatement;
import org.apache.shardingsphere.test.sql.parser.parameterized.asserts.SQLCaseAssertContext;
+import org.apache.shardingsphere.test.sql.parser.parameterized.asserts.segment.table.TableAssert;
import org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.dal.OptimizeTableStatementTestCase;
-import java.util.stream.Collectors;
-
-import static org.hamcrest.CoreMatchers.is;
-import static org.junit.Assert.assertNotNull;
-import static org.junit.Assert.assertThat;
-
/**
* Optimize table statement assert.
*/
@@ -43,8 +38,10 @@ public final class MySQLOptimizeTableStatementAssert {
* @param expected expected optimize table statement test case
*/
public static void assertIs(final SQLCaseAssertContext assertContext, final MySQLOptimizeTableStatement actual, final OptimizeTableStatementTestCase expected) {
- assertNotNull("expected optimize table should be not null", expected.getTable());
- String actualTables = actual.getTables().stream().map(simpleTableSegment -> simpleTableSegment.getTableName().getIdentifier().getValue()).collect(Collectors.joining(","));
- assertThat(actualTables, is(expected.getTable().getName()));
+ assertTables(assertContext, actual, expected);
+ }
+
+ private static void assertTables(final SQLCaseAssertContext assertContext, final MySQLOptimizeTableStatement actual, final OptimizeTableStatementTestCase expected) {
+ TableAssert.assertIs(assertContext, actual.getTables(), expected.getTables());
}
}
diff --git a/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/asserts/statement/dal/impl/MySQLOptimizeTableStatementAssert.java b/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/asserts/statement/dal/impl/MySQLRepairTableStatementAssert.java
similarity index 57%
copy from shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/asserts/statement/dal/impl/MySQLOptimizeTableStatementAssert.java
copy to shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/asserts/statement/dal/impl/MySQLRepairTableStatementAssert.java
index ba7af82..7bee05b 100644
--- a/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/asserts/statement/dal/impl/MySQLOptimizeTableStatementAssert.java
+++ b/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/asserts/statement/dal/impl/MySQLRepairTableStatementAssert.java
@@ -19,32 +19,29 @@ package org.apache.shardingsphere.test.sql.parser.parameterized.asserts.statemen
import lombok.AccessLevel;
import lombok.NoArgsConstructor;
-import org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.dal.MySQLOptimizeTableStatement;
+import org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.dal.MySQLRepairTableStatement;
import org.apache.shardingsphere.test.sql.parser.parameterized.asserts.SQLCaseAssertContext;
-import org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.dal.OptimizeTableStatementTestCase;
-
-import java.util.stream.Collectors;
-
-import static org.hamcrest.CoreMatchers.is;
-import static org.junit.Assert.assertNotNull;
-import static org.junit.Assert.assertThat;
+import org.apache.shardingsphere.test.sql.parser.parameterized.asserts.segment.table.TableAssert;
+import org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.dal.RepairTableStatementTestCase;
/**
- * Optimize table statement assert.
+ * Repair table statement assert.
*/
@NoArgsConstructor(access = AccessLevel.PRIVATE)
-public final class MySQLOptimizeTableStatementAssert {
+public final class MySQLRepairTableStatementAssert {
/**
- * Assert optimize table statement is correct with expected parser result.
+ * Assert repair table statement is correct with expected parser result.
*
* @param assertContext assert context
- * @param actual actual optimize table statement
- * @param expected expected optimize table statement test case
+ * @param actual actual repair table statement
+ * @param expected expected repair table statement test case
*/
- public static void assertIs(final SQLCaseAssertContext assertContext, final MySQLOptimizeTableStatement actual, final OptimizeTableStatementTestCase expected) {
- assertNotNull("expected optimize table should be not null", expected.getTable());
- String actualTables = actual.getTables().stream().map(simpleTableSegment -> simpleTableSegment.getTableName().getIdentifier().getValue()).collect(Collectors.joining(","));
- assertThat(actualTables, is(expected.getTable().getName()));
+ public static void assertIs(final SQLCaseAssertContext assertContext, final MySQLRepairTableStatement actual, final RepairTableStatementTestCase expected) {
+ assertTables(assertContext, actual, expected);
+ }
+
+ private static void assertTables(final SQLCaseAssertContext assertContext, final MySQLRepairTableStatement actual, final RepairTableStatementTestCase expected) {
+ TableAssert.assertIs(assertContext, actual.getTables(), expected.getTables());
}
}
diff --git a/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/jaxb/cases/domain/SQLParserTestCases.java b/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/jaxb/cases/domain/SQLParserTestCases.java
index caf14cb..51815b0 100644
--- a/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/jaxb/cases/domain/SQLParserTestCases.java
+++ b/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/jaxb/cases/domain/SQLParserTestCases.java
@@ -28,6 +28,7 @@ import org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain
import org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.dal.InstallComponentStatementTestCase;
import org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.dal.InstallPluginStatementTestCase;
import org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.dal.OptimizeTableStatementTestCase;
+import org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.dal.RepairTableStatementTestCase;
import org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.dal.SetParameterStatementTestCase;
import org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.dal.SetResourceGroupStatementTestCase;
import org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.dal.ShowColumnsStatementTestCase;
@@ -653,8 +654,12 @@ public final class SQLParserTestCases {
@XmlElement(name = "optimize-table")
private final List<OptimizeTableStatementTestCase> optimizeTableStatementTestCases = new LinkedList<>();
+ @XmlElement(name = "repair-table")
+ private final List<RepairTableStatementTestCase> repairTableStatementTestCases = new LinkedList<>();
+
@XmlElement(name = "create-sharding-algorithm")
private final List<CreateShardingAlgorithmStatementTestCase> createShardingAlgorithmStatementTestCases = new LinkedList<>();
+
/**
* Get all SQL parser test cases.
*
@@ -817,6 +822,7 @@ public final class SQLParserTestCases {
putAll(showSingleTableRulesStatementTestCases, result);
putAll(setResourceGroupStatementTestCases, result);
putAll(optimizeTableStatementTestCases, result);
+ putAll(repairTableStatementTestCases, result);
putAll(createShardingAlgorithmStatementTestCases, result);
return result;
}
diff --git a/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/jaxb/cases/domain/statement/dal/OptimizeTableStatementTestCase.java b/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/jaxb/cases/domain/statement/dal/OptimizeTableStatementTestCase.java
index c742602..831b6ee 100644
--- a/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/jaxb/cases/domain/statement/dal/OptimizeTableStatementTestCase.java
+++ b/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/jaxb/cases/domain/statement/dal/OptimizeTableStatementTestCase.java
@@ -23,6 +23,8 @@ import org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain
import org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.SQLParserTestCase;
import javax.xml.bind.annotation.XmlElement;
+import java.util.LinkedList;
+import java.util.List;
/**
* Optimize table statement test case.
@@ -31,6 +33,6 @@ import javax.xml.bind.annotation.XmlElement;
@Setter
public final class OptimizeTableStatementTestCase extends SQLParserTestCase {
- @XmlElement
- private ExpectedSimpleTable table;
+ @XmlElement(name = "table")
+ private List<ExpectedSimpleTable> tables = new LinkedList<>();
}
diff --git a/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/jaxb/cases/domain/statement/dal/OptimizeTableStatementTestCase.java b/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/jaxb/cases/domain/statement/dal/RepairTableStatementTestCase.java
similarity index 82%
copy from shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/jaxb/cases/domain/statement/dal/OptimizeTableStatementTestCase.java
copy to shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/jaxb/cases/domain/statement/dal/RepairTableStatementTestCase.java
index c742602..fffa0c9 100644
--- a/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/jaxb/cases/domain/statement/dal/OptimizeTableStatementTestCase.java
+++ b/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/jaxb/cases/domain/statement/dal/RepairTableStatementTestCase.java
@@ -23,14 +23,16 @@ import org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain
import org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.SQLParserTestCase;
import javax.xml.bind.annotation.XmlElement;
+import java.util.LinkedList;
+import java.util.List;
/**
- * Optimize table statement test case.
+ * Repair table statement test case.
*/
@Getter
@Setter
-public final class OptimizeTableStatementTestCase extends SQLParserTestCase {
+public final class RepairTableStatementTestCase extends SQLParserTestCase {
- @XmlElement
- private ExpectedSimpleTable table;
+ @XmlElement(name = "table")
+ private List<ExpectedSimpleTable> tables = new LinkedList<>();
}
diff --git a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/dal/optimize.xml b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/dal/optimize.xml
index 93a2de5..cebc4f1 100644
--- a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/dal/optimize.xml
+++ b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/dal/optimize.xml
@@ -18,6 +18,7 @@
<sql-parser-test-cases>
<optimize-table sql-case-id="optimize_table">
- <table name="table1,table2"/>
+ <table name="table1" start-index="15" stop-index="20"/>
+ <table name="table2" start-index="22" stop-index="27"/>
</optimize-table>
</sql-parser-test-cases>
diff --git a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/dal/optimize.xml b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/dal/repair.xml
similarity index 82%
copy from shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/dal/optimize.xml
copy to shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/dal/repair.xml
index 93a2de5..9abb181 100644
--- a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/dal/optimize.xml
+++ b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/dal/repair.xml
@@ -17,7 +17,8 @@
-->
<sql-parser-test-cases>
- <optimize-table sql-case-id="optimize_table">
- <table name="table1,table2"/>
- </optimize-table>
+ <repair-table sql-case-id="repair_table">
+ <table name="table1" start-index="13" stop-index="18"/>
+ <table name="table2" start-index="20" stop-index="25"/>
+ </repair-table>
</sql-parser-test-cases>
diff --git a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/dal/optimize.xml b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/dal/repair.xml
similarity index 84%
copy from shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/dal/optimize.xml
copy to shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/dal/repair.xml
index 93a2de5..91d3a71 100644
--- a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/dal/optimize.xml
+++ b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/dal/repair.xml
@@ -16,8 +16,6 @@
~ limitations under the License.
-->
-<sql-parser-test-cases>
- <optimize-table sql-case-id="optimize_table">
- <table name="table1,table2"/>
- </optimize-table>
-</sql-parser-test-cases>
+<sql-cases>
+ <sql-case id="repair_table" value="REPAIR TABLE table1,table2" db-types="MySQL" />
+</sql-cases>