diff options
| author | pem@mysql.comhem.se <> | 2004-08-30 14:52:21 +0200 |
|---|---|---|
| committer | pem@mysql.comhem.se <> | 2004-08-30 14:52:21 +0200 |
| commit | 12b1c4b330ddeaae34a6cacb7c9dd761d73972c0 (patch) | |
| tree | a8a8c419af1aebd6caca202a466bbb08b18e4b4e | |
| parent | 0c39b7458ad7e8a2dbb339e6d9958e984e93c2b9 (diff) | |
| download | mariadb-git-12b1c4b330ddeaae34a6cacb7c9dd761d73972c0.tar.gz | |
Fixed BUG#5279: Stored procedure packets out of order if CHECKSUM TABLE.
| -rw-r--r-- | mysql-test/r/sp.result | 9 | ||||
| -rw-r--r-- | mysql-test/t/sp.test | 10 | ||||
| -rw-r--r-- | sql/sp_head.cc | 1 |
3 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/r/sp.result b/mysql-test/r/sp.result index 3e1114b2fd2..90a1a92dd6f 100644 --- a/mysql-test/r/sp.result +++ b/mysql-test/r/sp.result @@ -1755,6 +1755,15 @@ where db='test' and name='bug5251' and created = @c1| count(*) 1 drop procedure bug5251| +create procedure bug5251() +checksum table t1| +call bug5251()| +Table Checksum +test.t1 0 +call bug5251()| +Table Checksum +test.t1 0 +drop procedure bug5251| drop table if exists fac| create table fac (n int unsigned not null primary key, f bigint unsigned)| create procedure ifac(n int unsigned) diff --git a/mysql-test/t/sp.test b/mysql-test/t/sp.test index 577fa13b26f..8d833547ce1 100644 --- a/mysql-test/t/sp.test +++ b/mysql-test/t/sp.test @@ -1914,6 +1914,16 @@ select count(*) from mysql.proc drop procedure bug5251| +# +# BUG#5279: Stored procedure packets out of order if CHECKSUM TABLE +# +create procedure bug5251() + checksum table t1| + +call bug5251()| +call bug5251()| +drop procedure bug5251| + # # Some "real" examples diff --git a/sql/sp_head.cc b/sql/sp_head.cc index fd95767b7cd..b2d3b8202c8 100644 --- a/sql/sp_head.cc +++ b/sql/sp_head.cc @@ -56,6 +56,7 @@ sp_multi_results_command(enum enum_sql_command cmd) { switch (cmd) { case SQLCOM_ANALYZE: + case SQLCOM_CHECKSUM: case SQLCOM_HA_READ: case SQLCOM_SHOW_BINLOGS: case SQLCOM_SHOW_BINLOG_EVENTS: |