Bug #110017 SELECT returns incorrect value when ORDER BY a CASE WHEN value in left-joined su
Submitted: 10 Feb 2023 6:27 Modified: 10 Feb 2023 9:03
Reporter: Taro Suzuki Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S3 (Non-critical)
Version:5.7.41 OS:Ubuntu
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:

[16 Feb 2023 4:47] huahua xu
The patch will work well

Attachment: case_when_not_null_value_in_left_join_bugfix.patch (application/octet-stream, text), 988 bytes.