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 1c78db0 Optimize create / alter / drop language SQL parser test case
for PostgreSQL & openGauss. (#14519)
1c78db0 is described below
commit 1c78db0f701f4fe8e46d418a9ed11c35bb2ee743
Author: Zonglei Dong <[email protected]>
AuthorDate: Wed Jan 5 11:16:36 2022 +0800
Optimize create / alter / drop language SQL parser test case for PostgreSQL
& openGauss. (#14519)
* Add create conversion SQL parser test case for PostgreSQL & openGauss.
* Add create / alter / drop language SQL parser test case for PostgreSQL &
openGauss.
* Add create / alter / drop language SQL parser test case for PostgreSQL &
openGauss.
---
.../jaxb/cases/domain/SQLParserTestCases.java | 28 ++++++++++++++++++----
.../ddl/AlterLanguageStatementTestCase.java | 26 ++++++++++++++++++++
.../ddl/CreateConversionStatementTestCase.java | 26 ++++++++++++++++++++
.../ddl/CreateLanguageStatementTestCase.java | 26 ++++++++++++++++++++
.../ddl/DropLanguageStatementTestCase.java | 26 ++++++++++++++++++++
.../src/main/resources/case/ddl/alter-language.xml | 6 ++---
.../main/resources/case/ddl/create-conversion.xml | 4 ++--
.../main/resources/case/ddl/create-language.xml | 6 ++---
.../src/main/resources/case/ddl/drop-language.xml | 4 ++--
9 files changed, 138 insertions(+), 14 deletions(-)
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 07b5c17..661e48d 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
@@ -90,6 +90,7 @@ import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain
import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.ddl.AlterDatabaseStatementTestCase;
import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.ddl.AlterFunctionStatementTestCase;
import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.ddl.AlterIndexStatementTestCase;
+import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.ddl.AlterLanguageStatementTestCase;
import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.ddl.AlterProcedureStatementTestCase;
import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.ddl.AlterSchemaStatementTestCase;
import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.ddl.AlterSequenceStatementTestCase;
@@ -104,11 +105,13 @@ import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain
import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.ddl.AssociateStatisticsStatementTestCase;
import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.ddl.AuditStatementTestCase;
import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.ddl.CommentStatementTestCase;
+import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.ddl.CreateConversionStatementTestCase;
import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.ddl.CreateDatabaseLinkStatementTestCase;
import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.ddl.CreateDatabaseStatementTestCase;
import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.ddl.CreateDomainStatementTestCase;
import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.ddl.CreateFunctionStatementTestCase;
import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.ddl.CreateIndexStatementTestCase;
+import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.ddl.CreateLanguageStatementTestCase;
import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.ddl.CreateProcedureStatementTestCase;
import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.ddl.CreateRuleStatementTestCase;
import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.ddl.CreateSchemaStatementTestCase;
@@ -126,6 +129,7 @@ import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain
import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.ddl.DropDomainStatementTestCase;
import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.ddl.DropFunctionStatementTestCase;
import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.ddl.DropIndexStatementTestCase;
+import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.ddl.DropLanguageStatementTestCase;
import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.ddl.DropProcedureStatementTestCase;
import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.ddl.DropSchemaStatementTestCase;
import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.ddl.DropSequenceStatementTestCase;
@@ -928,11 +932,14 @@ public final class SQLParserTestCases {
@XmlElement(name = "alter-sql-parser-rule")
private final List<AlterSQLParserRuleStatementTestCase>
alterSQLParserRuleStatementTestCases = new LinkedList<>();
+ @XmlElement(name = "create-conversion")
+ private final List<CreateConversionStatementTestCase>
createConversionStatementTestCase = new LinkedList<>();
+
@XmlElement(name = "drop-conversion")
- private final List<DropConversionStatementTestCase> dropConversionTestCase
= new LinkedList<>();
+ private final List<DropConversionStatementTestCase>
dropConversionStatementTestCase = new LinkedList<>();
@XmlElement(name = "alter-conversion")
- private final List<AlterConversionStatementTestCase>
alterConversionTestCase = new LinkedList<>();
+ private final List<AlterConversionStatementTestCase>
alterConversionStatementTestCase = new LinkedList<>();
@XmlElement(name = "create-text-search")
private final List<CreateTextSearchStatementTestCase>
createTextSearchStatementTestCases = new LinkedList<>();
@@ -940,6 +947,15 @@ public final class SQLParserTestCases {
@XmlElement(name = "alter-text-search")
private final List<AlterTextSearchStatementTestCase>
alterTextSearchStatementTestCases = new LinkedList<>();
+ @XmlElement(name = "create-language")
+ private final List<CreateLanguageStatementTestCase>
createLanguageStatementTestCases = new LinkedList<>();
+
+ @XmlElement(name = "alter-language")
+ private final List<AlterLanguageStatementTestCase>
alterLanguageStatementTestCases = new LinkedList<>();
+
+ @XmlElement(name = "drop-language")
+ private final List<DropLanguageStatementTestCase>
dropLanguageStatementTestCases = new LinkedList<>();
+
/**
* Get all SQL parser test cases.
*
@@ -1170,10 +1186,14 @@ public final class SQLParserTestCases {
putAll(showTransactionRuleStatementTestCases, result);
putAll(alterSQLParserRuleStatementTestCases, result);
putAll(createTypeStatementTestCases, result);
- putAll(dropConversionTestCase, result);
- putAll(alterConversionTestCase, result);
+ putAll(createConversionStatementTestCase, result);
+ putAll(dropConversionStatementTestCase, result);
+ putAll(alterConversionStatementTestCase, result);
putAll(createTextSearchStatementTestCases, result);
putAll(alterTextSearchStatementTestCases, result);
+ putAll(createLanguageStatementTestCases, result);
+ putAll(alterLanguageStatementTestCases, result);
+ putAll(dropLanguageStatementTestCases, result);
return result;
}
// CHECKSTYLE:ON
diff --git
a/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/jaxb/cases/domain/statement/ddl/AlterLanguageStatementTestCase.java
b/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/jaxb/cases/domain/statement/ddl/AlterLanguageStatementTestCase.java
new file mode 100644
index 0000000..c2ddf29
--- /dev/null
+++
b/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/jaxb/cases/domain/statement/ddl/AlterLanguageStatementTestCase.java
@@ -0,0 +1,26 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed with
+ * this work for additional information regarding copyright ownership.
+ * The ASF licenses this file to You under the Apache License, Version 2.0
+ * (the "License"); you may not use this file except in compliance with
+ * the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+
+package
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.ddl;
+
+import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.SQLParserTestCase;
+
+/**
+ * Alter language statement test case.
+ */
+public final class AlterLanguageStatementTestCase extends SQLParserTestCase {
+}
diff --git
a/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/jaxb/cases/domain/statement/ddl/CreateConversionStatementTestCase.java
b/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/jaxb/cases/domain/statement/ddl/CreateConversionStatementTestCase.java
new file mode 100644
index 0000000..7fa10a1
--- /dev/null
+++
b/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/jaxb/cases/domain/statement/ddl/CreateConversionStatementTestCase.java
@@ -0,0 +1,26 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed with
+ * this work for additional information regarding copyright ownership.
+ * The ASF licenses this file to You under the Apache License, Version 2.0
+ * (the "License"); you may not use this file except in compliance with
+ * the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+
+package
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.ddl;
+
+import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.SQLParserTestCase;
+
+/**
+ * Create conversion statement test case.
+ */
+public final class CreateConversionStatementTestCase extends SQLParserTestCase
{
+}
diff --git
a/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/jaxb/cases/domain/statement/ddl/CreateLanguageStatementTestCase.java
b/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/jaxb/cases/domain/statement/ddl/CreateLanguageStatementTestCase.java
new file mode 100644
index 0000000..f468da0
--- /dev/null
+++
b/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/jaxb/cases/domain/statement/ddl/CreateLanguageStatementTestCase.java
@@ -0,0 +1,26 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed with
+ * this work for additional information regarding copyright ownership.
+ * The ASF licenses this file to You under the Apache License, Version 2.0
+ * (the "License"); you may not use this file except in compliance with
+ * the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+
+package
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.ddl;
+
+import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.SQLParserTestCase;
+
+/**
+ * Create language statement test case.
+ */
+public final class CreateLanguageStatementTestCase extends SQLParserTestCase {
+}
diff --git
a/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/jaxb/cases/domain/statement/ddl/DropLanguageStatementTestCase.java
b/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/jaxb/cases/domain/statement/ddl/DropLanguageStatementTestCase.java
new file mode 100644
index 0000000..0cc6417
--- /dev/null
+++
b/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/jaxb/cases/domain/statement/ddl/DropLanguageStatementTestCase.java
@@ -0,0 +1,26 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed with
+ * this work for additional information regarding copyright ownership.
+ * The ASF licenses this file to You under the Apache License, Version 2.0
+ * (the "License"); you may not use this file except in compliance with
+ * the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+
+package
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.ddl;
+
+import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.SQLParserTestCase;
+
+/**
+ * Drop language statement test case.
+ */
+public final class DropLanguageStatementTestCase extends SQLParserTestCase {
+}
diff --git
a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/ddl/alter-language.xml
b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/ddl/alter-language.xml
index de56d35..2f5dd8c 100644
---
a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/ddl/alter-language.xml
+++
b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/ddl/alter-language.xml
@@ -17,7 +17,7 @@
-->
<sql-parser-test-cases>
- <create-trigger sql-case-id="alter_language" />
- <create-trigger sql-case-id="alter_language_owner" />
- <create-trigger sql-case-id="alter_language_owner_user" />
+ <alter-language sql-case-id="alter_language" />
+ <alter-language sql-case-id="alter_language_owner" />
+ <alter-language sql-case-id="alter_language_owner_user" />
</sql-parser-test-cases>
diff --git
a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/ddl/create-conversion.xml
b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/ddl/create-conversion.xml
index f501439..a5b5823 100644
---
a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/ddl/create-conversion.xml
+++
b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/ddl/create-conversion.xml
@@ -17,6 +17,6 @@
-->
<sql-parser-test-cases>
- <create-trigger sql-case-id="create_conversion" />
- <create-trigger sql-case-id="create_conversion_default" />
+ <create-conversion sql-case-id="create_conversion" />
+ <create-conversion sql-case-id="create_conversion_default" />
</sql-parser-test-cases>
diff --git
a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/ddl/create-language.xml
b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/ddl/create-language.xml
index 42ea382..93aa446 100644
---
a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/ddl/create-language.xml
+++
b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/ddl/create-language.xml
@@ -17,7 +17,7 @@
-->
<sql-parser-test-cases>
- <create-trigger sql-case-id="create_language" />
- <create-trigger sql-case-id="create_or_replace_language" />
- <create-trigger sql-case-id="create_language_inline_validator" />
+ <create-language sql-case-id="create_language" />
+ <create-language sql-case-id="create_or_replace_language" />
+ <create-language sql-case-id="create_language_inline_validator" />
</sql-parser-test-cases>
diff --git
a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/ddl/drop-language.xml
b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/ddl/drop-language.xml
index 6aa4854..db90edc 100644
---
a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/ddl/drop-language.xml
+++
b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/ddl/drop-language.xml
@@ -17,6 +17,6 @@
-->
<sql-parser-test-cases>
- <create-trigger sql-case-id="drop_language" />
- <create-trigger sql-case-id="drop_language_with_exist" />
+ <drop-language sql-case-id="drop_language" />
+ <drop-language sql-case-id="drop_language_with_exist" />
</sql-parser-test-cases>
