[GitHub] [incubator-shardingsphere] xfyang1989 opened a new issue #2827: The same transaction executes the following two sqls, and the last one does not acquire the interface after the current transaction has changed

[GitBox]

xfyang1989 opened a new issue #2827: The same transaction executes the 
following two sqls, and the last one does not acquire the interface after the 
current transaction has changed
URL: https://github.com/apache/incubator-shardingsphere/issues/2827
 
 
   The same transaction executes the following two sqls, and the last one does 
not acquire the interface after the current transaction has changed.
   
    UPDATE user
     SET cusum_of_month = cusum_of_month + 10
     where   
        sku= '99985463'
        AND warehouse_code = '0013'
        AND first = '300800'
        AND second = '0';
   
       SELECT 
sku_code,first_channel,second_channel,IFNULL(SUM(cusum_of_month),0) as 
cusum_of_month
            FROM user
           WHERE is_deleted = 0 and 
               (sku = '99985463'
                        AND first = '300800' 
                        and second = '0')
           GROUP BY sku_code,first_channel,second_channel;

----------------------------------------------------------------
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:
us...@infra.apache.org


With regards,
Apache Git Services