peilinqian opened a new issue, #18540: URL: https://github.com/apache/shardingsphere/issues/18540
## 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? we find java version: java8, full_version=1.8.0_181 ShardingSphere-5.1.3-SNAPSHOT Commit ID: 9cdbba7caebafc59be9842f7dd73aaad7721d12b Commit Message: Refactor RulesUsedResourceQueryResultSet (#18520) Branch: master Build time: 2022-06-22T19:07:02+0000 ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy? ShardingSphere-Proxy ### Expected behavior After the "cursor, close, fetch, move" sql is executed successfully. return success message ### Actual behavior After the "cursor, close, fetch, move" sql is executed successfully. no return information ### Reason analyze (If you can) ### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc. ``` --数据创建 drop table if exists t_broadcast; create table t_broadcast(id int,c_id int,a int,b text); insert into t_broadcast values (1,1,10,'test1'),(2,2,20,'test2'), (3,3,10,'test3'),(4,4,40,'test4'),(5,5,50,'test5'),(6,6,60,'test6'); --查询fetch、move功能 start transaction; --cursor子句正序功能验证 cursor cur_test_01 for select * from t_broadcast order by 1; ----默认移动，不指定 move from cur_test_01; move cur_test_01; ----forward方式，不指定count fetch forward from cur_test_01; ----forward方式，指定count fetch forward 2 from cur_test_01; ----forward方式，指定all fetch forward all from cur_test_01; ----获取结果下一行为空 fetch forward from cur_test_01; close cur_test_01; end; ``` ### 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
