[GitHub] [shardingsphere] peilinqian commented on issue #21250: In XA transaction,the cursor syntax is abnormal.

[GitBox <gi...@apache.org>]

peilinqian commented on issue #21250:
URL: https://github.com/apache/shardingsphere/issues/21250#issuecomment-1274565813

   we find java version: java8, full_version=1.8.0_282, full_path=/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.282.b08-1.el7_9.x86_64/bin/java
   ShardingSphere-5.2.1-SNAPSHOT
   Commit ID: dirty-bcde6f374c4a3a025173fbc9f6d0e66ed686a042
   Commit Message: Fix fetch forward all error in openGauss(#21421) (#21471)
   Branch: bcde6f374c4a3a025173fbc9f6d0e66ed686a042
   Build time: 2022-10-11T19:13:56+0800
   
   ```
   test_db=> create table t_broadcast(id int,c_id int,a int,b text);
   CREATE TABLE
   test_db=> insert into t_broadcast values (1,1,10,'test1'),(2,2,20,'test2'),
   test_db-> (3,3,10,'test3'),(4,4,40,'test4'),(5,5,50,'test5');
   INSERT 0 5
   test_db=>
   test_db=> show transaction rule;
    default_type | provider_type | props
   --------------+---------------+-------
    XA           | Narayana      |
   (1 row)
   
   test_db=> start transaction;
   START TRANSACTION
   test_db=> cursor cur_test_01 for select * from t_broadcast order by 1;
   DECLARE CURSOR
   test_db=> fetch from cur_test_01;
    id | c_id | a  |   b
   ----+------+----+-------
     1 |    1 | 10 | test1
   (1 row)
   
   test_db=> end;
   COMMIT
   test_db=>
   
   ```


-- 
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