iblilife commented on issue #8605:
URL: https://github.com/apache/shardingsphere/issues/8605#issuecomment-751251954
> @iblilife Thanks for your detailed info. Which SQL were you running for
debugging?
> @strongduanmu Could you give it a check?
table
```sql
CREATE TABLE `card_type` (
`id` bigint NOT NULL,
`name` varchar(50) NOT NULL DEFAULT '' COMMENT '',
`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) NOT NULL DEFAULT '',
PRIMARY KEY (`id`) USING BTREE
)
```
sql of debuging
```sql
select
ct.*,
emp.name
from card_type ct
left join shop_employee emp on (emp.id = ct.create_employee_id)
```
----------------------------------------------------------------
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]
