Bug #111471 Unexpected Error: Memory capacity exceeded
Submitted: 17 Jun 2023 14:28 Modified: 18 Jun 2023 13:26
Reporter: JINSHENG BA Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S2 (Serious)
Version:8.0.33 OS:Ubuntu
Assigned to: CPU Architecture:x86

[17 Jun 2023 14:28] JINSHENG BA 
Description:
CREATE TABLE t1(c0 INT UNIQUE);
CREATE TABLE t2(c0 FLOAT);
SET SESSION range_alloc_block_size = 18446744073709550592;
INSERT INTO t2(c0) VALUES(1);

SELECT * FROM t2, t1 WHERE (t2.c0) <= (t1.c0); --ERROR 34 (HY000) at line 10: Memory capacity exceeded (capacity 8388608 bytes)

The error information seems unexpected.

How to repeat:
$ sudo docker run -it -p 13306:3306 -e MYSQL_ROOT_PASSWORD=123456 mysql
$ mysql --host 127.0.0.1 -u root --password=123456 --port 13306

Execute the above test case.
[18 Jun 2023 13:26] MySQL Verification Team 
Hello Jinsheng Ba,

Thank you for the report and test case.

regards,
Umesh