close table before next iteration of table proccesing in mysql_admin_table (to allow open next table)

1 files changed, 7 insertions, 3 deletions

diff --git a/sql/sql_table.cc b/sql/sql_table.cc
index 8190e31bc0b..65690e56039 100644
--- a/sql/sql_table.cc
+++ b/sql/sql_table.cc
@@ -1268,9 +1268,13 @@ static int mysql_admin_table(THD* thd, TABLE_LIST* tables,
     if (prepare_func)
     {
       switch ((*prepare_func)(thd, table, check_opt)) {
-        case  1: continue; // error, message written to net
-        case -1: goto err; // error, message could be written to net
-        default:         ; // should be 0 otherwise
+      case  1:           // error, message written to net
+        close_thread_tables(thd);
+        continue;
+      case -1:           // error, message could be written to net
+        goto err;
+      default:           // should be 0 otherwise
+        ;
       }
     }