MySQL Bug#59331 filesort with priority queue: handling of out-of-memory

--echo #

--echo # Bug#59331 filesort with priority queue: handling of out-of-memory

--echo #

CREATE TABLE t1(f0 int auto_increment primary key, f1 int, f2 varchar(200));

INSERT INTO t1(f1, f2) VALUES

(0,"0"),(1,"1"),(2,"2"),(3,"3"),(4,"4"),(5,"5"),

(6,"6"),(7,"7"),(8,"8"),(9,"9"),(10,"10");

set debug= '+d,bounded_queue_init_fail';

--replace_regex /Needed [0-9]* bytes/Needed NN bytes/

--error 5

SELECT * FROM t1 ORDER BY f1 ASC, f0 LIMIT 1;

SET session debug= @old_debug;

DROP TABLE t1;