This is an automated email from the ASF dual-hosted git repository.
chengzhang 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 745258769d3 Remove useless DCLStatementBindEngine (#38362)
745258769d3 is described below
commit 745258769d32c139af63da8b76c51f930b21383f
Author: Zhengqiang Duan <[email protected]>
AuthorDate: Fri Mar 6 16:19:59 2026 +0800
Remove useless DCLStatementBindEngine (#38362)
---
.../infra/binder/engine/SQLBindEngine.java | 5 --
.../engine/statement/dcl/GrantStatementBinder.java | 57 --------------
.../statement/dcl/RevokeStatementBinder.java | 62 ---------------
.../binder/engine/type/DCLStatementBindEngine.java | 48 ------------
.../statement/dcl/GrantStatementBinderTest.java | 90 ----------------------
.../src/test/resources/cases/dcl/deny-user.xml | 28 -------
.../binder/src/test/resources/cases/dcl/grant.xml | 28 -------
.../binder/src/test/resources/cases/dcl/revoke.xml | 55 -------------
.../src/test/resources/sqls/dcl/deny-user.xml | 21 -----
.../binder/src/test/resources/sqls/dcl/grant.xml | 21 -----
.../binder/src/test/resources/sqls/dcl/revoke.xml | 24 ------
11 files changed, 439 deletions(-)
diff --git
a/infra/binder/core/src/main/java/org/apache/shardingsphere/infra/binder/engine/SQLBindEngine.java
b/infra/binder/core/src/main/java/org/apache/shardingsphere/infra/binder/engine/SQLBindEngine.java
index 0f4976d8713..f8f0a005a05 100644
---
a/infra/binder/core/src/main/java/org/apache/shardingsphere/infra/binder/engine/SQLBindEngine.java
+++
b/infra/binder/core/src/main/java/org/apache/shardingsphere/infra/binder/engine/SQLBindEngine.java
@@ -23,7 +23,6 @@ import
org.apache.shardingsphere.infra.binder.context.SQLStatementContextFactory
import
org.apache.shardingsphere.infra.binder.context.statement.SQLStatementContext;
import
org.apache.shardingsphere.infra.binder.engine.statement.SQLStatementBinderContext;
import
org.apache.shardingsphere.infra.binder.engine.type.DALStatementBindEngine;
-import
org.apache.shardingsphere.infra.binder.engine.type.DCLStatementBindEngine;
import
org.apache.shardingsphere.infra.binder.engine.type.DDLStatementBindEngine;
import
org.apache.shardingsphere.infra.binder.engine.type.DMLStatementBindEngine;
import org.apache.shardingsphere.infra.hint.HintManager;
@@ -31,7 +30,6 @@ import org.apache.shardingsphere.infra.hint.HintValueContext;
import org.apache.shardingsphere.infra.metadata.ShardingSphereMetaData;
import
org.apache.shardingsphere.sql.parser.statement.core.statement.SQLStatement;
import
org.apache.shardingsphere.sql.parser.statement.core.statement.type.dal.DALStatement;
-import
org.apache.shardingsphere.sql.parser.statement.core.statement.type.dcl.DCLStatement;
import
org.apache.shardingsphere.sql.parser.statement.core.statement.type.ddl.DDLStatement;
import
org.apache.shardingsphere.sql.parser.statement.core.statement.type.dml.DMLStatement;
@@ -75,9 +73,6 @@ public final class SQLBindEngine {
if (sqlStatement instanceof DDLStatement) {
return new DDLStatementBindEngine().bind((DDLStatement)
sqlStatement, binderContext);
}
- if (sqlStatement instanceof DCLStatement) {
- return new DCLStatementBindEngine().bind((DCLStatement)
sqlStatement, binderContext);
- }
if (sqlStatement instanceof DALStatement) {
return new DALStatementBindEngine().bind((DALStatement)
sqlStatement, binderContext);
}
diff --git
a/infra/binder/core/src/main/java/org/apache/shardingsphere/infra/binder/engine/statement/dcl/GrantStatementBinder.java
b/infra/binder/core/src/main/java/org/apache/shardingsphere/infra/binder/engine/statement/dcl/GrantStatementBinder.java
deleted file mode 100644
index 284d494dfe5..00000000000
---
a/infra/binder/core/src/main/java/org/apache/shardingsphere/infra/binder/engine/statement/dcl/GrantStatementBinder.java
+++ /dev/null
@@ -1,57 +0,0 @@
-/*
- * 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.infra.binder.engine.statement.dcl;
-
-import com.cedarsoftware.util.CaseInsensitiveMap.CaseInsensitiveString;
-import com.google.common.collect.LinkedHashMultimap;
-import com.google.common.collect.Multimap;
-import
org.apache.shardingsphere.infra.binder.engine.segment.dml.from.context.TableSegmentBinderContext;
-import
org.apache.shardingsphere.infra.binder.engine.segment.dml.from.type.SimpleTableSegmentBinder;
-import
org.apache.shardingsphere.infra.binder.engine.statement.SQLStatementBinder;
-import
org.apache.shardingsphere.infra.binder.engine.statement.SQLStatementBinderContext;
-import
org.apache.shardingsphere.infra.binder.engine.statement.SQLStatementCopyUtils;
-import
org.apache.shardingsphere.sql.parser.statement.core.segment.generic.table.SimpleTableSegment;
-import
org.apache.shardingsphere.sql.parser.statement.core.statement.type.dcl.GrantStatement;
-
-import java.util.Collection;
-import java.util.stream.Collectors;
-
-/**
- * Grant statement binder.
- */
-public final class GrantStatementBinder implements
SQLStatementBinder<GrantStatement> {
-
- @Override
- public GrantStatement bind(final GrantStatement sqlStatement, final
SQLStatementBinderContext binderContext) {
- Collection<SimpleTableSegment> tables = sqlStatement.getTables();
- if (tables.isEmpty()) {
- return sqlStatement;
- }
- Multimap<CaseInsensitiveString, TableSegmentBinderContext>
tableBinderContexts = LinkedHashMultimap.create();
- return copyGrantStatement(sqlStatement, tables.stream().map(each ->
SimpleTableSegmentBinder.bind(each, binderContext,
tableBinderContexts)).collect(Collectors.toList()));
- }
-
- private GrantStatement copyGrantStatement(final GrantStatement
sqlStatement, final Collection<SimpleTableSegment> tables) {
- if (tables.equals(sqlStatement.getTables())) {
- return sqlStatement;
- }
- GrantStatement result = new
GrantStatement(sqlStatement.getDatabaseType(), tables);
- SQLStatementCopyUtils.copyAttributes(sqlStatement, result);
- return result;
- }
-}
diff --git
a/infra/binder/core/src/main/java/org/apache/shardingsphere/infra/binder/engine/statement/dcl/RevokeStatementBinder.java
b/infra/binder/core/src/main/java/org/apache/shardingsphere/infra/binder/engine/statement/dcl/RevokeStatementBinder.java
deleted file mode 100644
index 3a23a737e04..00000000000
---
a/infra/binder/core/src/main/java/org/apache/shardingsphere/infra/binder/engine/statement/dcl/RevokeStatementBinder.java
+++ /dev/null
@@ -1,62 +0,0 @@
-/*
- * 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.infra.binder.engine.statement.dcl;
-
-import com.cedarsoftware.util.CaseInsensitiveMap.CaseInsensitiveString;
-import com.google.common.collect.LinkedHashMultimap;
-import com.google.common.collect.Multimap;
-import
org.apache.shardingsphere.infra.binder.engine.segment.dml.from.context.TableSegmentBinderContext;
-import
org.apache.shardingsphere.infra.binder.engine.segment.dml.from.type.SimpleTableSegmentBinder;
-import
org.apache.shardingsphere.infra.binder.engine.statement.SQLStatementBinder;
-import
org.apache.shardingsphere.infra.binder.engine.statement.SQLStatementBinderContext;
-import
org.apache.shardingsphere.infra.binder.engine.statement.SQLStatementCopyUtils;
-import
org.apache.shardingsphere.sql.parser.statement.core.segment.generic.table.SimpleTableSegment;
-import
org.apache.shardingsphere.sql.parser.statement.core.statement.type.dcl.RevokeStatement;
-
-import java.util.Collection;
-import java.util.LinkedList;
-
-/**
- * Revoke statement binder.
- */
-public final class RevokeStatementBinder implements
SQLStatementBinder<RevokeStatement> {
-
- @Override
- public RevokeStatement bind(final RevokeStatement sqlStatement, final
SQLStatementBinderContext binderContext) {
- Multimap<CaseInsensitiveString, TableSegmentBinderContext>
tableBinderContexts = LinkedHashMultimap.create();
- Collection<SimpleTableSegment> boundTables = new LinkedList<>();
- for (SimpleTableSegment each : sqlStatement.getTables()) {
- boundTables.add(SimpleTableSegmentBinder.bind(each, binderContext,
tableBinderContexts));
- }
- return copy(sqlStatement, boundTables);
- }
-
- private RevokeStatement copy(final RevokeStatement sqlStatement, final
Collection<SimpleTableSegment> tables) {
- if (tables.equals(sqlStatement.getTables())) {
- return sqlStatement;
- }
- RevokeStatement result;
- try {
- result =
sqlStatement.getClass().getDeclaredConstructor(sqlStatement.getDatabaseType().getClass()).newInstance(sqlStatement.getDatabaseType());
- } catch (final ReflectiveOperationException ex) {
- result = new RevokeStatement(sqlStatement.getDatabaseType(),
tables);
- }
- SQLStatementCopyUtils.copyAttributes(sqlStatement, result);
- return result;
- }
-}
diff --git
a/infra/binder/core/src/main/java/org/apache/shardingsphere/infra/binder/engine/type/DCLStatementBindEngine.java
b/infra/binder/core/src/main/java/org/apache/shardingsphere/infra/binder/engine/type/DCLStatementBindEngine.java
deleted file mode 100644
index 7c71af57399..00000000000
---
a/infra/binder/core/src/main/java/org/apache/shardingsphere/infra/binder/engine/type/DCLStatementBindEngine.java
+++ /dev/null
@@ -1,48 +0,0 @@
-/*
- * 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.infra.binder.engine.type;
-
-import
org.apache.shardingsphere.infra.binder.engine.statement.SQLStatementBinderContext;
-import
org.apache.shardingsphere.infra.binder.engine.statement.dcl.RevokeStatementBinder;
-import
org.apache.shardingsphere.infra.binder.engine.statement.dcl.GrantStatementBinder;
-import
org.apache.shardingsphere.sql.parser.statement.core.statement.type.dcl.DCLStatement;
-import
org.apache.shardingsphere.sql.parser.statement.core.statement.type.dcl.RevokeStatement;
-import
org.apache.shardingsphere.sql.parser.statement.core.statement.type.dcl.GrantStatement;
-
-/**
- * DCL statement bind engine.
- */
-public final class DCLStatementBindEngine {
-
- /**
- * Bind DCL statement.
- *
- * @param statement to be bound DCL statement
- * @param binderContext binder context
- * @return bound DCL statement
- */
- public DCLStatement bind(final DCLStatement statement, final
SQLStatementBinderContext binderContext) {
- if (statement instanceof RevokeStatement) {
- return new RevokeStatementBinder().bind((RevokeStatement)
statement, binderContext);
- }
- if (statement instanceof GrantStatement) {
- return new GrantStatementBinder().bind((GrantStatement) statement,
binderContext);
- }
- return statement;
- }
-}
diff --git
a/infra/binder/core/src/test/java/org/apache/shardingsphere/infra/binder/engine/statement/dcl/GrantStatementBinderTest.java
b/infra/binder/core/src/test/java/org/apache/shardingsphere/infra/binder/engine/statement/dcl/GrantStatementBinderTest.java
deleted file mode 100644
index e5035538100..00000000000
---
a/infra/binder/core/src/test/java/org/apache/shardingsphere/infra/binder/engine/statement/dcl/GrantStatementBinderTest.java
+++ /dev/null
@@ -1,90 +0,0 @@
-/*
- * 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.infra.binder.engine.statement.dcl;
-
-import org.apache.shardingsphere.database.connector.core.type.DatabaseType;
-import
org.apache.shardingsphere.infra.binder.engine.statement.SQLStatementBinderContext;
-import org.apache.shardingsphere.infra.hint.HintValueContext;
-import org.apache.shardingsphere.infra.metadata.ShardingSphereMetaData;
-import
org.apache.shardingsphere.infra.metadata.database.ShardingSphereDatabase;
-import
org.apache.shardingsphere.infra.metadata.database.schema.model.ShardingSphereSchema;
-import
org.apache.shardingsphere.infra.metadata.database.schema.model.ShardingSphereTable;
-import org.apache.shardingsphere.infra.spi.type.typed.TypedSPILoader;
-import
org.apache.shardingsphere.sql.parser.statement.core.segment.generic.table.SimpleTableSegment;
-import
org.apache.shardingsphere.sql.parser.statement.core.segment.generic.table.TableNameSegment;
-import
org.apache.shardingsphere.sql.parser.statement.core.statement.type.dcl.GrantStatement;
-import
org.apache.shardingsphere.sql.parser.statement.core.value.identifier.IdentifierValue;
-import org.junit.jupiter.api.Test;
-import org.junit.jupiter.api.extension.ExtendWith;
-import org.mockito.Mock;
-import org.mockito.junit.jupiter.MockitoExtension;
-
-import java.util.Collection;
-import java.util.Collections;
-
-import static org.hamcrest.Matchers.is;
-import static org.hamcrest.MatcherAssert.assertThat;
-import static org.junit.jupiter.api.Assertions.assertTrue;
-import static org.mockito.Mockito.when;
-
-@ExtendWith(MockitoExtension.class)
-class GrantStatementBinderTest {
-
- private final DatabaseType databaseType =
TypedSPILoader.getService(DatabaseType.class, "FIXTURE");
-
- @Mock
- private ShardingSphereMetaData metaData;
-
- @Mock
- private ShardingSphereDatabase database;
-
- @Mock
- private ShardingSphereSchema schema;
-
- @Mock
- private ShardingSphereTable table;
-
- @Test
- void assertBind() {
- when(metaData.containsDatabase("foo_db")).thenReturn(true);
- when(metaData.getDatabase("foo_db")).thenReturn(database);
- when(database.containsSchema("foo_db")).thenReturn(true);
- when(database.getSchema("foo_db")).thenReturn(schema);
- when(schema.containsTable("test_table")).thenReturn(true);
- when(schema.getTable("test_table")).thenReturn(table);
- when(table.getAllColumns()).thenReturn(Collections.emptyList());
- HintValueContext hintValueContext = new HintValueContext();
- hintValueContext.setSkipMetadataValidate(true);
- GrantStatement original = new GrantStatement(databaseType,
Collections.singleton(new SimpleTableSegment(new TableNameSegment(0, 0, new
IdentifierValue("test_table")))));
- SQLStatementBinderContext binderContext = new
SQLStatementBinderContext(metaData, "foo_db", hintValueContext, original);
- GrantStatement actual = new GrantStatementBinder().bind(original,
binderContext);
- Collection<SimpleTableSegment> actualTables = actual.getTables();
- assertThat(actualTables.size(), is(1));
-
assertThat(actualTables.iterator().next().getTableName().getIdentifier().getValue(),
is("test_table"));
- }
-
- @Test
- void assertBindWithEmptyTables() {
- GrantStatement original = new GrantStatement(databaseType,
Collections.emptyList());
- HintValueContext hintValueContext = new HintValueContext();
- hintValueContext.setSkipMetadataValidate(true);
- SQLStatementBinderContext binderContext = new
SQLStatementBinderContext(metaData, "foo_db", hintValueContext, original);
- GrantStatement actual = new GrantStatementBinder().bind(original,
binderContext);
- assertTrue(actual.getTables().isEmpty());
- }
-}
diff --git a/test/it/binder/src/test/resources/cases/dcl/deny-user.xml
b/test/it/binder/src/test/resources/cases/dcl/deny-user.xml
deleted file mode 100644
index 2c15b8a5197..00000000000
--- a/test/it/binder/src/test/resources/cases/dcl/deny-user.xml
+++ /dev/null
@@ -1,28 +0,0 @@
-<?xml version="1.0" encoding="UTF-8"?>
-<!--
- ~ 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.
- -->
-
-<sql-parser-test-cases>
- <deny-user sql-case-id="deny_user">
- <table name="t_order" start-index="15" stop-index="21">
- <table-bound>
- <original-database name="foo_db_1" />
- <original-schema name="dbo" />
- </table-bound>
- </table>
- </deny-user>
-</sql-parser-test-cases>
diff --git a/test/it/binder/src/test/resources/cases/dcl/grant.xml
b/test/it/binder/src/test/resources/cases/dcl/grant.xml
deleted file mode 100644
index a20b46d2246..00000000000
--- a/test/it/binder/src/test/resources/cases/dcl/grant.xml
+++ /dev/null
@@ -1,28 +0,0 @@
-<?xml version="1.0" encoding="UTF-8"?>
-<!--
- ~ 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.
- -->
-
-<sql-parser-test-cases>
- <grant sql-case-id="grant_select_on_table">
- <table name="t_order" start-index="16" stop-index="22">
- <table-bound>
- <original-database name="foo_db_1" />
- <original-schema name="foo_db_1" />
- </table-bound>
- </table>
- </grant>
-</sql-parser-test-cases>
diff --git a/test/it/binder/src/test/resources/cases/dcl/revoke.xml
b/test/it/binder/src/test/resources/cases/dcl/revoke.xml
deleted file mode 100644
index 44a5ec002fb..00000000000
--- a/test/it/binder/src/test/resources/cases/dcl/revoke.xml
+++ /dev/null
@@ -1,55 +0,0 @@
-<?xml version="1.0" encoding="UTF-8"?>
-<!--
- ~ 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.
- -->
-
-<sql-parser-test-cases>
- <revoke sql-case-id="revoke_user_without_hostname">
- <table name="t_order" start-index="25" stop-index="31">
- <table-bound>
- <original-database name="foo_db_1" />
- <original-schema name="dbo" />
- </table-bound>
- </table>
- </revoke>
-
- <revoke sql-case-id="revoke_crud_on_table">
- <table name="t_order" start-index="36" stop-index="42">
- <table-bound>
- <original-database name="foo_db_1" />
- <original-schema name="dbo" />
- </table-bound>
- </table>
- </revoke>
-
- <revoke sql-case-id="revoke_select_on_table_for_sqlserver">
- <table name="t_order" start-index="17" stop-index="23">
- <table-bound>
- <original-database name="foo_db_1" />
- <original-schema name="dbo" />
- </table-bound>
- </table>
- </revoke>
-
- <revoke sql-case-id="revoke_select_to_users">
- <table name="t_order" start-index="23" stop-index="29">
- <table-bound>
- <original-database name="foo_db_1" />
- <original-schema name="dbo" />
- </table-bound>
- </table>
- </revoke>
-</sql-parser-test-cases>
diff --git a/test/it/binder/src/test/resources/sqls/dcl/deny-user.xml
b/test/it/binder/src/test/resources/sqls/dcl/deny-user.xml
deleted file mode 100644
index c741bc71445..00000000000
--- a/test/it/binder/src/test/resources/sqls/dcl/deny-user.xml
+++ /dev/null
@@ -1,21 +0,0 @@
-<?xml version="1.0" encoding="UTF-8"?>
-<!--
- ~ 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.
- -->
-
-<sql-cases>
- <sql-case id="deny_user" value="DENY UPDATE ON t_order TO user_dev"
db-types="SQLServer" />
-</sql-cases>
diff --git a/test/it/binder/src/test/resources/sqls/dcl/grant.xml
b/test/it/binder/src/test/resources/sqls/dcl/grant.xml
deleted file mode 100644
index 557e3db966d..00000000000
--- a/test/it/binder/src/test/resources/sqls/dcl/grant.xml
+++ /dev/null
@@ -1,21 +0,0 @@
-<?xml version="1.0" encoding="UTF-8"?>
-<!--
- ~ 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.
- -->
-
-<sql-cases>
- <sql-case id="grant_select_on_table" value="GRANT SELECT ON t_order TO
user1" db-types="MySQL"/>
-</sql-cases>
diff --git a/test/it/binder/src/test/resources/sqls/dcl/revoke.xml
b/test/it/binder/src/test/resources/sqls/dcl/revoke.xml
deleted file mode 100644
index e924a1783a5..00000000000
--- a/test/it/binder/src/test/resources/sqls/dcl/revoke.xml
+++ /dev/null
@@ -1,24 +0,0 @@
-<?xml version="1.0" encoding="UTF-8"?>
-<!--
- ~ 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.
- -->
-
-<sql-cases>
- <sql-case id="revoke_user_without_hostname" value="REVOKE SELECT, UPDATE
on t_order from user_dev" db-types="Oracle,PostgreSQL,openGauss,SQLServer" />
- <sql-case id="revoke_crud_on_table" value="REVOKE INSERT, SELECT, UPDATE,
DELETE ON t_order FROM user1" db-types="SQLServer" />
- <sql-case id="revoke_select_on_table_for_sqlserver" value="REVOKE SELECT
ON t_order FROM user1" db-types="SQLServer" />
- <sql-case id="revoke_select_to_users" value="REVOKE SELECT (order_id) ON
t_order FROM user1, user2" db-types="SQLServer" />
-</sql-cases>
