fixed bug in used_tables() report of left expression of IN subquery

fixed number of rows of external field reported to optimizer
added check of choosen key (checked left expression tag)
(SCRUM fix for simple IN optimisation)


mysql-test/r/subselect.result:
  new EXPLAIN results ufter fixing used_tables() of Item_cache
sql/item_cmpfunc.cc:
  fixed used_tables asignment
sql/item_subselect.cc:
  added left expression referenca tag
sql/item_subselect.h:
  fixed layout
sql/mysql_priv.h:
  left expression reference tag
sql/mysqld.cc:
  left expression reference tag
sql/sql_select.cc:
  checked left expression reference tag
  fixed number of rows in outer reference (it should be constant)

1 files changed, 2 insertions, 2 deletions

diff --git a/sql/item_subselect.h b/sql/item_subselect.h
index e2738102ebd..dc26ec3fbca 100644
--- a/sql/item_subselect.h
+++ b/sql/item_subselect.h
@@ -192,7 +192,7 @@ public:
 class Item_in_subselect :public Item_exists_subselect
 {
 protected:
-  Item * left_expr;
+  Item *left_expr;
   /*
     expr & optimizer used in subselect rewriting to store Item for
     all JOIN in UNION
@@ -204,7 +204,7 @@ protected:
 public:
   Item_in_subselect(THD *thd, Item * left_expr, st_select_lex *select_lex);
   Item_in_subselect(Item_in_subselect *item);
-  Item_in_subselect(): Item_exists_subselect(),  abort_on_null(0)  {}
+  Item_in_subselect(): Item_exists_subselect(), abort_on_null(0) {}
 
   subs_type substype() { return IN_SUBS; }
   void reset()