[MDEV-17278] CURSOR FOR LOOP - ERROR: unexpected end of stream, read 0 bytes (SERVER CRASH) - Jira

XML

Word

Printable

The following code in a stored procedure produces the correct result when CALLed:

	FOR rec IN (SELECT Orders.Order_ID, Customers.State FROM Orders join Customers using (Customer_ID) where State is not null) DO

		set ans = concat(ans, '/', rec.Order_ID, '-', rec.State);

	END FOR;

However, if the field list is replaced by * it just crashes the server:

	FOR rec IN (SELECT * FROM Orders join Customers using (Customer_ID) where State is not null) DO

		set ans = concat(ans, '/', rec.Order_ID, '-', rec.State);

	END FOR;

with the message:

ERROR: (conn=10) unexpected end of stream, read 0 bytes from 4 (socket was closed by server)

relates to

MDEV-12098 sql_mode=ORACLE: Implicit cursor FOR loop

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.