MySQL Bugs: #94112: give wrong result when using between filter in the select statement

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:	None
Category:	MySQL Server: DML	Severity:	S1 (Critical)
Version:	5.7.21	OS:	Red Hat
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

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.

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.