Bug #100783 wrong result with hash join
Submitted: 9 Sep 2020 12:29 Modified: 10 Sep 2020 4:50
Reporter: lou shuai (OCA) Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S2 (Serious)
Version:8.0.19 OS:Any
Assigned to: CPU Architecture:Any
Tags: hash join

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:

[9 Sep 2020 13:49] lou shuai
hash join bug test file

Attachment: hj_bug.test (application/octet-stream, text), 1.10 KiB.

[9 Sep 2020 14:11] lou shuai
plz ignore the hj_bug.test file. this patch file contains test file, result file. And i tried to fix it

Attachment: hash_join_weedout_patch.diff (application/octet-stream, text), 5.50 KiB.