Bug #94112 give wrong result when using between filter in the select statement
Submitted: 29 Jan 12:53 Modified: 29 Jan 14:28
Reporter: Ragesh Kandathil Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: DML Severity:S1 (Critical)
Version:5.7.21 OS:Red Hat
Assigned to: CPU Architecture:Any

[29 Jan 12:53] Ragesh Kandathil
Description:
See the below same select statement we are executing but some time we are getting the count as one. when we are select the txnid some times we are getting only the first value 100300000000000000000047671950'. if we run again we will get the correct output.

How to repeat:
We are still getting the error.
[29 Jan 14:28] Miguel Solorzano
Thank you for the bug report. Please test with latest released version 5.7.25, if still you get the not expected result provide a complete test case (create table, insert data, queries, real result, expected result). Thanks.