Bug #102359 Functional Index ignored by Select query from within a Stored Function
Submitted: 24 Jan 2021 8:57 Modified: 19 Dec 2021 2:02
Reporter: Robert Roland Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S2 (Serious)
Version:8.0.23 OS:Any
Assigned to: CPU Architecture:Any
Tags: functional index, stored routine

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:

[26 Jan 2021 21:29] Robert Roland
UDF using composite index

Attachment: UDF_using_composite_index.txt (text/plain), 334 bytes.

[26 Jan 2021 21:29] Robert Roland
UDF using functional index

Attachment: UDF_using_functional_index.txt (text/plain), 267 bytes.