fixed error handling if creating derived table failed

single row subquery always can return NULL (no rows found) (BUG#5590)


mysql-test/r/subselect.result:
  maybe_null flag returning by subquwery for temporary table creation
mysql-test/t/subselect.test:
  maybe_null flag returning by subquwery for temporary table creation
sql/item.cc:
  storing maybe_null in type holder
sql/item_subselect.cc:
  single row subquery always can return NULL (no rows found)
sql/sql_derived.cc:
  fixed error handling if creating derived table failed

1 files changed, 3 insertions, 0 deletions

diff --git a/sql/sql_derived.cc b/sql/sql_derived.cc
index 05ad2094372..906ef646f47 100644
--- a/sql/sql_derived.cc
+++ b/sql/sql_derived.cc
@@ -224,7 +224,10 @@ static int mysql_derived(THD *thd, LEX *lex, SELECT_LEX_UNIT *unit,
     }
   }
   else
+  {
     free_tmp_table(thd, table);
+    thd->lex->unit.cleanup();
+  }
 
 exit:
   delete derived_result;