type_cursor.type_sys_refcursor-myisam ER_SUBQUERY_NO_1_ROW

type_cursor.type_sys_refcursor-myisam    w6 [ fail ]

        Test ended at 2026-04-01 23:01:25

CURRENT_TEST: type_cursor.type_sys_refcursor-myisam

mysqltest: In included file "/usr/share/mariadb/mariadb-test/plugin/type_cursor/type_cursor/type_sys_refcursor-select_for_update.inc": 

included from /usr/share/mariadb/mariadb-test/plugin/type_cursor/type_cursor/type_sys_refcursor-myisam.test at line 7:

At line 99: query 'CALL p1($for_update)' failed: ER_SUBQUERY_NO_1_ROW (1242): Subquery returns more than 1 row

The result from queries just before the failure was:

< snip >

SET session_id= (SELECT ID FROM INFORMATION_SCHEMA.PROCESSLIST

WHERE INFO LIKE '%SLEEP(%)');

SELECT CONCAT('p1: session_id IS NOT NULL:', session_id IS NOT NULL) AS msg;

IF session_id IS NOT NULL

THEN

KILL QUERY session_id;

END IF;

END;

/

------------ for_update=0  do_fetch=0

TRUNCATE TABLE t1;

TRUNCATE TABLE t2;

BEGIN;

INSERT INTO t1 (id) VALUES (0),(1),(2),(3),(4),(5),(6),(7);

COMMIT;

connect con2,localhost,root;

connection con2;

CALL p2(0, 0);

connection default;

CALL p1(0);