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

[29 Jan 2019 12:53] Ragesh Kandathil
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 2019 14:28] MySQL Verification Team
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.