iblilife opened a new issue #8605:
URL: https://github.com/apache/shardingsphere/issues/8605
### Which version of ShardingSphere did you use?
```xml
<dependency>
<groupId>org.apache.shardingsphere</groupId>
<artifactId>shardingsphere-jdbc-core</artifactId>
<version>5.0.0-alpha</version>
</dependency>
```
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
```ShardingSphere-JDBC```
### Table
```sql
CREATE TABLE `card_type` (
`id` bigint NOT NULL,
`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT
NULL DEFAULT '' COMMENT '',
`code_no` varchar(20) NOT NULL DEFAULT '' COMMENT '',
`shop_id` bigint NOT NULL COMMENT '',
`create_date_time` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
`create_employee_id` bigint NOT NULL DEFAULT '0' COMMENT '',
PRIMARY KEY (`id`) USING BTREE
);
CREATE TABLE `shop_employee` (
`id` bigint NOT NULL COMMENT '',
`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT
NULL DEFAULT '',
PRIMARY KEY (`id`) USING BTREE
)
```
### sharding yaml config
`card_type` `shop_employee` don't need sharding。unconfigured in yaml file。
### Mybatis mapper.xml
```xml
<select id="fetchCardTypeList" resultType="java.util.Map">
SELECT
ct.* ,
se.name as empName
FROM card_type ct
LEFT JOIN shop_employee se ON (se.id = ct.create_employee_id)
</select>
```
### Results
return resultset columns is empty。
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
