Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.3.9, 10.3(EOL)
-
None
-
CentOS7
Description
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)
|
Attachments
Issue Links
- relates to
-
MDEV-12098
sql_mode=ORACLE: Implicit cursor FOR loop
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Assignee | Alice Sherepa [ alice ] |
| Affects Version/s | 10.3 [ 22126 ] |
| Fix Version/s | 10.3 [ 22126 ] |
| Status | Open [ 1 ] | Confirmed [ 10101 ] |
| Link |
This issue relates to |
| Assignee | Alice Sherepa [ alice ] | Alexander Barkov [ bar ] |
| Priority | Major [ 3 ] | Critical [ 2 ] |
| Status | Confirmed [ 10101 ] | In Progress [ 3 ] |
| Assignee | Alexander Barkov [ bar ] | Oleksandr Byelkin [ sanja ] |
| Status | In Progress [ 3 ] | In Review [ 10002 ] |
| Assignee | Oleksandr Byelkin [ sanja ] | Alexander Barkov [ bar ] |
| Status | In Review [ 10002 ] | Stalled [ 10000 ] |
| Fix Version/s | 10.3.11 [ 23141 ] | |
| Fix Version/s | 10.3 [ 22126 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Stalled [ 10000 ] | Closed [ 6 ] |
| Workflow | MariaDB v3 [ 89737 ] | MariaDB v4 [ 154975 ] |