Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
None
-
None
Description
CREATE TABLE t1 (i INT); |
INSERT INTO t1 VALUES (1),(2); |
--delimiter |
|
CREATE PROCEDURE p (a INT) |
BEGIN
|
DELETE FROM t1 WHERE i = a RETURNING *; |
INSERT INTO t1 VALUES (a); |
END | |
--delimiter ;
|
|
CALL p(1);
|
SELECT * FROM t1; |
MariaDB [test]> CALL p(1);
|
+------+ |
| i |
|
+------+ |
| 1 |
|
+------+ |
1 row in set (0.03 sec) |
|
MariaDB [test]> SELECT * FROM t1; |
Error: Packets out of order (Found: 6, expected 1) |
ERROR 2013 (HY000): Lost connection to MySQL server during query |
MariaDB [test]>
|
The "Lost connection ..." error does not signify a server crash, only that the client got disconnected:
ERROR 2013 (HY000): Lost connection to MySQL server during query |
MariaDB [test]> SELECT * FROM t1; |
ERROR 2006 (HY000): MySQL server has gone away
|
No connection. Trying to reconnect... |
Connection id: 7 |
Current database: test |
|
+------+ |
| i |
|
+------+ |
| 2 |
|
| 1 |
|
+------+ |
2 rows in set (0.03 sec) |
bzr version-info
revision-id: knielsen@knielsen-hq.org-20130816131025-etjrvmfvupsjzq83
|
revno: 3674
|
branch-nick: 10.0-base
|
Attachments
Issue Links
- relates to
-
MDEV-3814 Implement DELETE with result set (mwl #205)
- Closed