new innodb query cache behaviour (recommit because of problem with 4.1 repository pushing)

fixed bug in quqry cache dbd transaction processing


mysql-test/r/innodb_cache.result:
  new innodb query cache behaviour
sql/ha_berkeley.h:
  new innodb query cache behaviour
sql/ha_innodb.cc:
  new innodb query cache behaviour
sql/ha_innodb.h:
  new innodb query cache behaviour
sql/handler.cc:
  new innodb query cache behaviour
  fixed bug in transaction support of bdb
sql/handler.h:
  new innodb query cache behaviour
sql/sql_cache.cc:
  new innodb query cache behaviour
sql/sql_cache.h:
  new innodb query cache behaviour

1 files changed, 12 insertions, 1 deletions

diff --git a/sql/handler.cc b/sql/handler.cc
index f60c3449075..10313201bf2 100644
--- a/sql/handler.cc
+++ b/sql/handler.cc
@@ -294,7 +294,8 @@ int ha_commit_trans(THD *thd, THD_TRANS* trans)
 	error=1;
       }
       else
-	transaction_commited= 1;
+	if (!(thd->options & OPTION_BEGIN))
+	  transaction_commited= 1;
       trans->bdb_tid=0;
     }
 #endif
@@ -838,6 +839,16 @@ int handler::delete_all_rows()
   return (my_errno=HA_ERR_WRONG_COMMAND);
 }
 
+bool handler::caching_allowed(THD* thd, char* table_key, 
+			      uint key_length, uint8 cache_type)
+{
+  if (cache_type == HA_CACHE_TBL_ASKTRANSACT)
+    return innobase_query_caching_of_table_permitted(thd, table_key,
+						     key_length);
+  else
+    return 1;
+}
+
 /****************************************************************************
 ** Some general functions that isn't in the handler class
 ****************************************************************************/