[GitHub] [incubator-shardingsphere] monkeyfriend123 commented on issue #2291: Select resultset sometimes missing

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

monkeyfriend123 commented on issue #2291: Select resultset sometimes missing
URL: https://github.com/apache/incubator-shardingsphere/issues/2291#issuecomment-489482803
 
 
   I found my problem is that , my sql limit rowcount.value is dynamic  then in multi thread context serveral selectstatements use the same Limit object , in the below code, the `limit.getRowCountValue()` maybe the other selectstatement setted, so it reads less data
   `  @Override
       public boolean next() throws SQLException {
           if (skipAll) {
               return false;
           }
           if (limit.getRowCountValue() < 0) {
               return getMergedResult().next();
           }
           return ++rowNumber <= limit.getRowCountValue() && getMergedResult().next();
       }.`  when i use a static rowcount , it is correct

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


With regards,
Apache Git Services