Bug #112451 Incorrect result if there are non-deterministic expressions in in-subquery
Submitted: 25 Sep 2023 6:35 Modified: 25 Sep 2023 7:36
Reporter: quan chen (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S3 (Non-critical)
Version:8.0,8.1 OS:Any
Assigned to: CPU Architecture:Any
Tags: semi join

To submit contributions, please log in.

[25 Sep 2023 6:37] quan chen 
add RAND_TABLE_BIT to the last table of sj-nest

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

Attachment: fix.patch (application/octet-stream, text), 1.31 KiB.