Bug #105637 left join + semijoin produce wrong results when using materialization strategy
Submitted: 19 Nov 2021 9:52 Modified: 19 Nov 2021 10:18
Reporter: Xiaodi Z Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S2 (Serious)
Version:8.0.25, 8.0.27 OS:Any
Assigned to: CPU Architecture:Any
Tags: left join, materialization, semijoin

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: