Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
Description
Hi,
The following test case triggers an unexpected error:
CREATE TABLE t0(c0 BIGINT); |
CREATE TABLE t1(c0 BOOLEAN); |
SET SESSION join_cache_level = 4; |
SET SESSION optimizer_switch = 'optimize_join_buffer_size=off'; |
SET SESSION join_buffer_size = 6241697776319798288; |
SELECT * FROM t0 NATURAL JOIN t1; -- Could not create a join buffer. Please check and adjust the value of the variables 'JOIN_BUFFER_SIZE (6241697776319798272)' and 'JOIN_BUFFER_SPACE_LIMIT (2097152)' |
I checked the supported value of join_buffer_size, and found that this value is a valid value (i.e., less than 18446744073709547520).