gzwz commented on issue #25063:
URL:
https://github.com/apache/shardingsphere/issues/25063#issuecomment-1501082615
org.apache.shardingsphere:shardingsphere-jdbc-core:5.3.2
this is mys sql
---------------------------------------------------------------------------
SELECT
DISTINCT RES.*
FROM
( SELECT
PROCDEF.* ,
INSTANCE.INSTANCE_COUNT_ ,
INC.INCIDENT_TYPE_ ,
INC.INCIDENT_COUNT_
FROM
ACT_RE_PROCDEF PROCDEF
LEFT OUTER JOIN
( SELECT
E.PROC_DEF_ID_ ,
COUNT(E.PROC_INST_ID_) AS INSTANCE_COUNT_
FROM
ACT_RU_EXECUTION E
WHERE
E.PARENT_ID_ IS NULL
GROUP BY
E.PROC_DEF_ID_ ) INSTANCE
ON
PROCDEF.ID_ = INSTANCE.PROC_DEF_ID_
LEFT OUTER JOIN
( SELECT
I.PROC_DEF_ID_ ,
I.INCIDENT_TYPE_ ,
COUNT(I.ID_) AS INCIDENT_COUNT_
FROM
ACT_RU_INCIDENT I
WHERE
I.ID_ = I.ROOT_CAUSE_INCIDENT_ID_
GROUP BY
I.PROC_DEF_ID_,
I.INCIDENT_TYPE_ ) INC
ON
PROCDEF.ID_ = INC.PROC_DEF_ID_ ) RES
ORDER BY
RES.ID_ ASC
------------------------------------------------------------------------
the query result of the query is 18 columns
and
The original results found in the above figure are still correct, but at
this point, errors begin to occur
After taking column 19 here, it will cause the boundary to be crossed later
on
--
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]
