[GitHub] [shardingsphere] CTO-xk commented on issue #11455: nested exception is org.apache.ibatis.executor.ExecutorException:

[GitBox <gi...@apache.org>]

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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org