|
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
|
WX20230816-191159.png