MySQL Bugs: #98942: Inconsistent results for the queries which should return same result

Bug #98942	Inconsistent results for the queries which should return same result
Submitted:	13 Mar 2020 11:53	Modified:	13 Mar 2020 23:20
Reporter:	Andrews B A	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server: Optimizer	Severity:	S3 (Non-critical)
Version:	8.0.19	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

File:	Maximum allowed size is 50MB.
Description:
Privacy:

If the data you need to attach is more than 50MB, you should create a compressed archive of the data, split it to 50MB chunks, and upload each of them as a separate attachment.

To split a large file:

On *nix platforms use the split command e.g. split -b 50MB <my_large_archive> <my_split_archive_prefix>
On windows use WinZip or a similar utility to split the large file

The Dump is taken in 8.0.16, But this is the data that fails to work in 8.0.19

Attachment: MySQLBug.sql (application/sql, text), 2.78 KiB.

Use the aboe dump file to reproduce the issue

Attachment: T_5542000022057953.sql (application/sql, text), 2.09 MiB.