Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
11.0.3
-
None
-
None
Description
When execute the following simple sql query, "ERROR 1290 (HY000): The MariaDB server is running with the --max-session-mem-used=18446744073709551615 option so it cannot execute this statement" occurred.
18446744073709551615 is a valid value for max_session_mem_used variable.
CREATE TABLE users ( |
id INT PRIMARY KEY, |
username VARCHAR(50), |
email VARCHAR(100), |
birthdate DATE |
);
|
|
|
INSERT INTO users (id, username, email, birthdate) VALUES |
(1, 'john_doe', 'john@example.com', '1990-05-15'), |
(2, 'jane_smith', 'jane@example.com', '1985-09-20'), |
(3, 'bob_johnson', 'bob@example.com', '1998-03-10'); |
|
|
SET SESSION max_session_mem_used = 18446744073709551615; |
|
|
SELECT * FROM users; |
https://mariadb.com/kb/en/server-system-variables/#max_session_mem_used
