This is an automated email from the ASF dual-hosted git repository.
zhangliang 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 3995c13e98a Add SubqueryProjectionSegmentBinderTest (#37149)
3995c13e98a is described below
commit 3995c13e98a81a031bb85fb19af421424feff749
Author: Liang Zhang <[email protected]>
AuthorDate: Thu Nov 20 22:45:44 2025 +0800
Add SubqueryProjectionSegmentBinderTest (#37149)
---
.../type/SubqueryProjectionSegmentBinderTest.java | 64 ++++++++++++++++++++++
1 file changed, 64 insertions(+)
diff --git
a/infra/binder/core/src/test/java/org/apache/shardingsphere/infra/binder/engine/segment/dml/projection/type/SubqueryProjectionSegmentBinderTest.java
b/infra/binder/core/src/test/java/org/apache/shardingsphere/infra/binder/engine/segment/dml/projection/type/SubqueryProjectionSegmentBinderTest.java
new file mode 100644
index 00000000000..cac295e5aaa
--- /dev/null
+++
b/infra/binder/core/src/test/java/org/apache/shardingsphere/infra/binder/engine/segment/dml/projection/type/SubqueryProjectionSegmentBinderTest.java
@@ -0,0 +1,64 @@
+/*
+ * 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.segment.dml.projection.type;
+
+import com.cedarsoftware.util.CaseInsensitiveMap.CaseInsensitiveString;
+import com.google.common.collect.LinkedHashMultimap;
+import com.google.common.collect.Multimap;
+import org.apache.shardingsphere.database.connector.core.type.DatabaseType;
+import
org.apache.shardingsphere.infra.binder.engine.segment.dml.expression.type.SubquerySegmentBinder;
+import
org.apache.shardingsphere.infra.binder.engine.segment.dml.from.context.TableSegmentBinderContext;
+import
org.apache.shardingsphere.infra.binder.engine.statement.SQLStatementBinderContext;
+import
org.apache.shardingsphere.sql.parser.statement.core.segment.dml.expr.subquery.SubquerySegment;
+import
org.apache.shardingsphere.sql.parser.statement.core.segment.dml.item.SubqueryProjectionSegment;
+import
org.apache.shardingsphere.sql.parser.statement.core.segment.generic.AliasSegment;
+import
org.apache.shardingsphere.sql.parser.statement.core.statement.type.dml.SelectStatement;
+import
org.apache.shardingsphere.sql.parser.statement.core.value.identifier.IdentifierValue;
+import
org.apache.shardingsphere.test.infra.framework.extension.mock.AutoMockExtension;
+import
org.apache.shardingsphere.test.infra.framework.extension.mock.StaticMockSettings;
+import org.junit.jupiter.api.Test;
+import org.junit.jupiter.api.extension.ExtendWith;
+
+import static org.hamcrest.CoreMatchers.is;
+import static org.hamcrest.MatcherAssert.assertThat;
+import static org.junit.jupiter.api.Assertions.assertTrue;
+import static org.mockito.Mockito.mock;
+import static org.mockito.Mockito.when;
+
+@ExtendWith(AutoMockExtension.class)
+@StaticMockSettings(SubquerySegmentBinder.class)
+class SubqueryProjectionSegmentBinderTest {
+
+ @Test
+ void assertBindWithAlias() {
+ SubquerySegment subquerySegment = new SubquerySegment(0, 0, new
SelectStatement(mock(DatabaseType.class)), "SELECT 1");
+ SubqueryProjectionSegment projectionSegment = new
SubqueryProjectionSegment(subquerySegment, "SELECT 1");
+ AliasSegment aliasSegment = new AliasSegment(0, 0, new
IdentifierValue("subquery_alias"));
+ projectionSegment.setAlias(aliasSegment);
+ SQLStatementBinderContext binderContext =
mock(SQLStatementBinderContext.class);
+ Multimap<CaseInsensitiveString, TableSegmentBinderContext>
tableBinderContexts = LinkedHashMultimap.create();
+ SubquerySegment boundSubquerySegment = new SubquerySegment(0, 0, new
SelectStatement(mock(DatabaseType.class)), "SELECT 1");
+ when(SubquerySegmentBinder.bind(subquerySegment, binderContext,
tableBinderContexts)).thenReturn(boundSubquerySegment);
+ SubqueryProjectionSegment actual =
SubqueryProjectionSegmentBinder.bind(projectionSegment, binderContext,
tableBinderContexts);
+ assertThat(actual.getSubquery(), is(boundSubquerySegment));
+ assertTrue(actual.getAlias().isPresent());
+ assertThat(actual.getAlias().get().getValue(), is("subquery_alias"));
+ assertTrue(actual.getAliasSegment().isPresent());
+ assertThat(actual.getAliasSegment().get(), is(aliasSegment));
+ }
+}
