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
 
-