Bug #112913 Select performs inconsistently on MYISAM and MEMORY
Submitted: 1 Nov 2023 9:01 Modified: 3 Nov 2023 12:29
Reporter: Ying FU Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Storage Engines Severity:S3 (Non-critical)
Version:8.0 OS:Linux
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:

[1 Nov 2023 9:01] Ying FU
create-MEMORY.sql

Attachment: create-MEMORY.sql (application/octet-stream, text), 252.92 KiB.

[1 Nov 2023 9:01] Ying FU
create-MYISAM.sql

Attachment: create-MYISAM.sql (application/octet-stream, text), 252.92 KiB.

[1 Nov 2023 9:01] Ying FU
select.sql

Attachment: select.sql (application/octet-stream, text), 13.89 KiB.

[2 Nov 2023 1:54] Ying FU
my reproduction pic

Attachment: my_reproduction.png (image/png, text), 211.07 KiB.

[2 Nov 2023 1:59] Ying FU
my_production_MEMORY

Attachment: my_production_MEMORY.png (image/png, text), 128.15 KiB.