Bug #119861 Inconsistent query results when using <=> to compare row data with empty set subquery result
Submitted: 9 Feb 9:01 Modified: 16 Feb 8:35
Reporter: Xingyu Yang (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S3 (Non-critical)
Version:8.0.44 OS:Any
Assigned to: CPU Architecture:Any

To submit contributions, please log in.

[9 Feb 9:02] Xingyu Yang 
Reset the values of all columns in the single-row subquery result when the subquery returns an empty set,

(*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Attachment: 0001-bugfix-Inconsistent-query-results-when-using-to-comp.patch (application/octet-stream, text), 1.02 KiB.