taigam commented on issue #8480:
URL: https://github.com/apache/shardingsphere/issues/8480#issuecomment-737672489
5.0.0
ShardingSphere-JDBC
the param i give in is 6
but actual change it to 2147483647
something was wrong with it
the log :
`2020-12-03 11:13:15.309 INFO
[http-nio-8443-exec-10]ShardingSphere-SQL.log:74 -Actual SQL: magic-image0 :::
SELECT count(0) FROM (SELECT app_code, group_id, matrix_pwd FROM matrix_info0
GROUP BY matrix_pwd HAVING count(matrix_pwd) >= ?) table_count ::: [6]
2020-12-03 11:13:15.309 INFO
[http-nio-8443-exec-10]ShardingSphere-SQL.log:74 -Actual SQL: magic-image0 :::
SELECT count(0) FROM (SELECT app_code, group_id, matrix_pwd FROM matrix_info1
GROUP BY matrix_pwd HAVING count(matrix_pwd) >= ?) table_count ::: [6]
2020-12-03 11:13:15.309 INFO
[http-nio-8443-exec-10]ShardingSphere-SQL.log:74 -Actual SQL: magic-image1 :::
SELECT count(0) FROM (SELECT app_code, group_id, matrix_pwd FROM matrix_info0
GROUP BY matrix_pwd HAVING count(matrix_pwd) >= ?) table_count ::: [6]
2020-12-03 11:13:15.309 INFO
[http-nio-8443-exec-10]ShardingSphere-SQL.log:74 -Actual SQL: magic-image1 :::
SELECT count(0) FROM (SELECT app_code, group_id, matrix_pwd FROM matrix_info1
GROUP BY matrix_pwd HAVING count(matrix_pwd) >= ?) table_count ::: [6]
2020-12-03 11:13:15.309 INFO
[http-nio-8443-exec-10]ShardingSphere-SQL.log:74 -Actual SQL: magic-image2 :::
SELECT count(0) FROM (SELECT app_code, group_id, matrix_pwd FROM matrix_info0
GROUP BY matrix_pwd HAVING count(matrix_pwd) >= ?) table_count ::: [6]
2020-12-03 11:13:15.309 INFO
[http-nio-8443-exec-10]ShardingSphere-SQL.log:74 -Actual SQL: magic-image2 :::
SELECT count(0) FROM (SELECT app_code, group_id, matrix_pwd FROM matrix_info1
GROUP BY matrix_pwd HAVING count(matrix_pwd) >= ?) table_count ::: [6]
2020-12-03 11:13:15.318 INFO
[http-nio-8443-exec-10]ShardingSphere-SQL.log:74 -Logic SQL: select
app_code,
group_id,
matrix_pwd
from
matrix_info
group by
matrix_pwd
having count(matrix_pwd) >= ?
order by
count(matrix_pwd) desc LIMIT ?
2020-12-03 11:13:15.319 INFO
[http-nio-8443-exec-10]ShardingSphere-SQL.log:74 -SQLStatement:
MySQLSelectStatement(limit=Optional[org.apache.shardingsphere.sql.parser.sql.common.segment.dml.pagination.limit.LimitSegment@64ba7b61],
lock=Optional.empty)
2020-12-03 11:13:15.319 INFO
[http-nio-8443-exec-10]ShardingSphere-SQL.log:74 -Actual SQL: magic-image0 :::
select
app_code,
group_id,
matrix_pwd
, count(matrix_pwd) AS ORDER_BY_DERIVED_0
from
matrix_info0
group by
matrix_pwd
having count(matrix_pwd) >= ?
order by
count(matrix_pwd) desc LIMIT ? ::: [2147483647, 20]`
----------------------------------------------------------------
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]
