You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2021/08/26 07:24:46 UTC
[GitHub] [shardingsphere] wenjian-li opened a new issue #12022: Oracle11g pagination limit does not work
wenjian-li opened a new issue #12022:
URL: https://github.com/apache/shardingsphere/issues/12022
## Bug Report
**For English only**, other languages will not accept.
Before report a bug, make sure you have:
- Searched open and closed [GitHub issues](https://github.com/apache/shardingsphere/issues).
- Read documentation: [ShardingSphere Doc](https://shardingsphere.apache.org/document/current/en/overview).
Please pay attention on issues you submitted, because we maybe need more details.
If no response anymore and we cannot reproduce it on current information, we will **close it**.
Please answer these questions before submitting your issue. Thanks!
### Which version of ShardingSphere did you use?
5.0.0-beta
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
ShardingSphere-JDBC
### Expected behavior
return pagination with query limit 1
### Actual behavior
all tables query results are returned.
### Reason analyze (If you can)
### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
`2021-08-26 14:35:02,494 INFO DubboServerHandler-192.168.12.118:20880-thread-3 o.a.s.i.executor.sql.log.SQLLogger 74 log ---- SQLStatement: OracleSelectStatement(lock=Optional.empty)
2021-08-26 14:35:02,494 INFO DubboServerHandler-192.168.12.118:20880-thread-3 o.a.s.i.executor.sql.log.SQLLogger 74 log ---- Actual SQL: ds0 ::: SELECT * FROM ( SELECT TMP.*, ROWNUM ROW_ID FROM ( SELECT id, head_id, machine_id, business_id, currency_name, sno, sno_length, version, tf_flag, error_code, start_time, create_time FROM T_DATA_202108 WHERE (START_TIME >= ? AND START_TIME <= ? AND MACHINE_ID = ?) ORDER BY START_TIME ASC ) TMP WHERE ROWNUM <=?) WHERE ROW_ID > ? ::: [2021-08-26 08:00:00.0, 2021-10-01 11:00:00.0, 1, 1, 0]
2021-08-26 14:35:02,495 INFO DubboServerHandler-192.168.12.118:20880-thread-3 o.a.s.i.executor.sql.log.SQLLogger 74 log ---- Actual SQL: ds0 ::: SELECT * FROM ( SELECT TMP.*, ROWNUM ROW_ID FROM ( SELECT id, head_id, machine_id, business_id, currency_name, sno, sno_length, version, tf_flag, error_code, start_time, create_time FROM T_DATA_202109 WHERE (START_TIME >= ? AND START_TIME <= ? AND MACHINE_ID = ?) ORDER BY START_TIME ASC ) TMP WHERE ROWNUM <=?) WHERE ROW_ID > ? ::: [2021-08-26 08:00:00.0, 2021-10-01 11:00:00.0, 1, 1, 0]
2021-08-26 14:35:02,495 INFO DubboServerHandler-192.168.12.118:20880-thread-3 o.a.s.i.executor.sql.log.SQLLogger 74 log ---- Actual SQL: ds0 ::: SELECT * FROM ( SELECT TMP.*, ROWNUM ROW_ID FROM ( SELECT id, head_id, machine_id, business_id, currency_name, sno, sno_length, version, tf_flag, error_code, start_time, create_time FROM T_DATA_202110 WHERE (START_TIME >= ? AND START_TIME <= ? AND MACHINE_ID = ?) ORDER BY START_TIME ASC ) TMP WHERE ROWNUM <=?) WHERE ROW_ID > ? ::: [2021-08-26 08:00:00.0, 2021-10-01 11:00:00.0, 1, 1, 0]`
### Example codes for reproduce this issue (such as a github link).
--
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
[GitHub] [shardingsphere] wenjian-li edited a comment on issue #12022: Oracle11g pagination limit does not work
Posted by GitBox <gi...@apache.org>.
wenjian-li edited a comment on issue #12022:
URL: https://github.com/apache/shardingsphere/issues/12022#issuecomment-906893716
> Can you provider the Logic SQL?
yes, I've updated the info. thx
--
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
[GitHub] [shardingsphere] avalon5666 commented on issue #12022: Oracle11g pagination limit does not work
Posted by GitBox <gi...@apache.org>.
avalon5666 commented on issue #12022:
URL: https://github.com/apache/shardingsphere/issues/12022#issuecomment-907024216
#8841
--
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
[GitHub] [shardingsphere] wenjian-li commented on issue #12022: Oracle11g pagination limit does not work
Posted by GitBox <gi...@apache.org>.
wenjian-li commented on issue #12022:
URL: https://github.com/apache/shardingsphere/issues/12022#issuecomment-907008043
@avalon5666
--
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
[GitHub] [shardingsphere] avalon5666 commented on issue #12022: Oracle11g pagination limit does not work
Posted by GitBox <gi...@apache.org>.
avalon5666 commented on issue #12022:
URL: https://github.com/apache/shardingsphere/issues/12022#issuecomment-906851468
Can you provider the Logic SQL?
--
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
[GitHub] [shardingsphere] avalon5666 closed issue #12022: Oracle11g pagination limit does not work
Posted by GitBox <gi...@apache.org>.
avalon5666 closed issue #12022:
URL: https://github.com/apache/shardingsphere/issues/12022
--
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
[GitHub] [shardingsphere] wenjian-li edited a comment on issue #12022: Oracle11g pagination limit does not work
Posted by GitBox <gi...@apache.org>.
wenjian-li edited a comment on issue #12022:
URL: https://github.com/apache/shardingsphere/issues/12022#issuecomment-906893716
> Can you provider the Logic SQL?
yes, I've updated the info. thx
--
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
[GitHub] [shardingsphere] wenjian-li commented on issue #12022: Oracle11g pagination limit does not work
Posted by GitBox <gi...@apache.org>.
wenjian-li commented on issue #12022:
URL: https://github.com/apache/shardingsphere/issues/12022#issuecomment-906893716
> Can you provider the Logic SQL?
yes,I've updated the information. thx
--
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