strongduanmu commented on issue #13814:
URL:
https://github.com/apache/shardingsphere/issues/13814#issuecomment-979890225
@wj-li This statement seems to be a paging subquery, and a complex aggregate
query is performed internally. ShardingSphere currently cannot support the
logical processing of aggregate query within the subquery.
```sql
SELECT *
FROM (
SELECT TMP.*, ROWNUM AS ROW_ID
FROM (
SELECT TO_CHAR(STATIS_TIME, 'yyyy-mm-dd') AS statisTimeStr,
BUSINESS_NO AS businessNo, BUSINESS_TYPE AS businessType
, BANK_ID AS bankId, SUM(TOTAL_AMOUNT) AS totalAmount
FROM T_DATA_STATIS
WHERE BANK_ID IN (?)
AND STATIS_TIME >= ?
AND STATIS_TIME <= ?
GROUP BY TO_CHAR(STATIS_TIME, 'yyyy-mm-dd'), BUSINESS_NO,
BANK_ID, BUSINESS_TYPE, TOTAL_AMOUNT
) TMP
WHERE ROWNUM <= ?
)
WHERE ROW_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.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
