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

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

monkeyfriend123 edited a comment on issue #2291: Select resultset sometimes missing
URL: https://github.com/apache/incubator-shardingsphere/issues/2291#issuecomment-487444214
 
 
   I use mybatis to select data from mysql dbs about 10000 times, each times select {min-create_time to max-create_time} range orders . it sometimes return less data.  
   the below is my sql
   ```sql
   select
           t.`id`,t.`order_no`,t.`order_amount` ,t.`finish_type`,t.`finish_time`,t.`create_time`
           from <include refid="ORDER_TABLE_NAME"/> t
           where
           UNIX_TIMESTAMP(t.create_time)*1000  >= #{searchStartTime}
           and <![CDATA[ UNIX_TIMESTAMP(t.create_time)*1000  <= #{searchEndTime}]]>
           and t.channel_id in ('100')
           order by t.order_no
           limit 0,100
   ```

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