diff options
author | Sergei Petrunia <psergey@askmonty.org> | 2014-06-26 22:03:13 +0400 |
---|---|---|
committer | Sergei Petrunia <psergey@askmonty.org> | 2014-06-26 22:03:13 +0400 |
commit | 3d7eeb6307242a7b4a810732322d043b736c5919 (patch) | |
tree | 982cf83c8d3da9ef79cc7e04c5290be0cfddc127 | |
parent | be885ebe8c3df78d090c2ad25772959fc2ae9fc9 (diff) | |
download | mariadb-git-3d7eeb6307242a7b4a810732322d043b736c5919.tar.gz |
MDEV-6394: ANALYZE DELETE .. RETURNING fails with ERROR 2027 Malformed packet
- Add support for DELETE .. RETURNING statement in ANALYZE code.
-rw-r--r-- | mysql-test/r/analyze_stmt.result | 8 | ||||
-rw-r--r-- | mysql-test/t/analyze_stmt.test | 8 |
2 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/r/analyze_stmt.result b/mysql-test/r/analyze_stmt.result index 8df6fe5127a..53c3188cd4c 100644 --- a/mysql-test/r/analyze_stmt.result +++ b/mysql-test/r/analyze_stmt.result @@ -251,3 +251,11 @@ analyze select * from t1 into @var; id select_type table type possible_keys key key_len ref rows r_rows filtered r_filtered Extra 1 SIMPLE t1 system NULL NULL NULL NULL 1 NULL 100.00 NULL drop table t1; +# +# MDEV-6394: ANALYZE DELETE .. RETURNING fails with ERROR 2027 Malformed packet +# +create table t1 (i int); +analyze delete from t1 returning *; +id select_type table type possible_keys key key_len ref rows r_rows filtered r_filtered Extra +1 SIMPLE t1 ALL NULL NULL NULL NULL 0 0 100.00 100.00 +drop table t1; diff --git a/mysql-test/t/analyze_stmt.test b/mysql-test/t/analyze_stmt.test index 8bd4ce37dd3..214d80d840d 100644 --- a/mysql-test/t/analyze_stmt.test +++ b/mysql-test/t/analyze_stmt.test @@ -198,3 +198,11 @@ create table t1 (i int); insert into t1 values (1); analyze select * from t1 into @var; drop table t1; + +--echo # +--echo # MDEV-6394: ANALYZE DELETE .. RETURNING fails with ERROR 2027 Malformed packet +--echo # +create table t1 (i int); +analyze delete from t1 returning *; +drop table t1; + |