CTO-xk commented on issue #11455:
URL:
https://github.com/apache/shardingsphere/issues/11455#issuecomment-886167614
版本是
><dependency>
<groupId>org.apache.shardingsphere</groupId>
<artifactId>sharding-jdbc-spring-boot-starter</artifactId>
<version>4.1.1</version>
</dependency>
sql 是
SELECT
res.id,
res.parent_id,
res.resource_name,
res.resource_type,
res.resource_code,
res.resource_url,
res.sort,
rid
FROM
t_resource res
LEFT JOIN (
SELECT
res.id,
rr.roid rid
FROM
t_resource res
LEFT JOIN t_role_resource rr ON res.id = rr.reid
WHERE
res.parent_id = 0
AND res.resource_type = '1'
AND rr.roid = 1379400291016765441
AND res.state = '1'
AND res.is_delete = '0'
AND rr.is_delete = '0'
ORDER BY
res.sort
) t ON res.id = t.id
WHERE
res.parent_id = 0
AND res.resource_type = '1'
AND res.state = '1'
AND res.is_delete = '0'
AND res.application_code = 'agent'
ORDER BY
res.sort
--
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.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
