Bug #96549 MySQL query optimizer rewrites query and gets different results than MySQL5.5
Submitted: 15 Aug 2019 10:59 Modified: 28 Aug 2019 12:23
Reporter: lalit Choudhary Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S3 (Non-critical)
Version:5.6,5.7,8.0, 5.6.45, 5.7.27, 8.0.17 OS:Any
Assigned to: CPU Architecture:Any

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:

[15 Aug 2019 10:59] lalit Choudhary
load data

Attachment: bug_dump_mysql.sql (application/sql, text), 6.41 KiB.

[19 Aug 2019 5:48] Umesh Shastry
Test results - 8.0.17, 5.7.27, 5.6.45 and 5.5.62

Attachment: 96549.results (application/octet-stream, text), 40.92 KiB.