From 5988ae5ca590dcecaee0158ed8e9699f274e30d9 Mon Sep 17 00:00:00 2001
From: "Sinisa@sinisa.nasamreza.org" <>
Date: Tue, 24 Dec 2002 13:58:07 +0200
Subject: Many fixes.

I still have to make a test case for :

UPDATE from sub-select with derived table
---
 sql/sql_cache.cc | 2 ++
 1 file changed, 2 insertions(+)

(limited to 'sql/sql_cache.cc')

diff --git a/sql/sql_cache.cc b/sql/sql_cache.cc
index aa0f5824b4e..1cfbbf74da6 100644
--- a/sql/sql_cache.cc
+++ b/sql/sql_cache.cc
@@ -1062,6 +1062,8 @@ void Query_cache::invalidate(THD *thd, TABLE_LIST *tables_used,
       for (; tables_used; tables_used=tables_used->next)
       {
 	DBUG_ASSERT(!using_transactions || tables_used->table!=0);
+	if (tables_used->derived)
+	  continue;
 	if (using_transactions && 
 	   tables_used->table->file->has_transactions())
 	  /* 
-- 
cgit v1.2.1