Bug #104388 Multi-valued index is not in possible keys when there is a subquery
Submitted: 23 Jul 2021 1:11 Modified: 9 Aug 2021 16:52
Reporter: Jinlin Yang Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S2 (Serious)
Version:8.0.25 OS:Any
Assigned to: CPU Architecture:Any
Tags: multi-valued index, subquery

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:

[23 Jul 2021 1:13] Jinlin Yang
Script to repro the issue

Attachment: repro-script.sql (application/octet-stream, text), 982 bytes.

[23 Jul 2021 1:13] Jinlin Yang
Output of the repro script

Attachment: repro-script-output.txt (text/plain), 9.10 KiB.