diff options
| author | unknown <Sinisa@sinisa.nasamreza.org> | 2002-12-24 13:58:07 +0200 |
|---|---|---|
| committer | unknown <Sinisa@sinisa.nasamreza.org> | 2002-12-24 13:58:07 +0200 |
| commit | 7a74837e00be97bfaaf2940f06c636da7eed73a8 (patch) | |
| tree | 47e3ffaa6aba38ec5904fb7bcd002fa92b377664 /sql/sql_cache.cc | |
| parent | 9528812119fbaaa87ef6de0e2d03910e09ff1ea7 (diff) | |
| download | mariadb-git-7a74837e00be97bfaaf2940f06c636da7eed73a8.tar.gz | |
Many fixes.
I still have to make a test case for :
UPDATE from sub-select with derived table
mysql-test/r/multi_update.result:
Test for found rows in multi-table update
mysql-test/r/subselect.result:
Fix for new syntax for UNION's
mysql-test/t/multi_update.test:
Test for found rows in multi-table update
mysql-test/t/subselect.test:
Fix for new syntax for UNION's
sql/sql_cache.cc:
Fix for a bug that involved derived table in sub-select in UPDATE or
DELETE statement
sql/sql_derived.cc:
Fix for a bug that involved derived table in sub-select in UPDATE or
DELETE statement
sql/sql_parse.cc:
Fix for a bug that involved derived table in sub-select in UPDATE or
DELETE statement
sql/sql_show.cc:
Fix for th eshow of replication status
sql/sql_yacc.yy:
Three fixes.
One for not allowing mixing of braces and non-braces in UNION's
Second one for table aliases in multi-table deletes / updates
Third one for using derived tables within sub-selects for
UPDATE / DELETE commands
Diffstat (limited to 'sql/sql_cache.cc')
| -rw-r--r-- | sql/sql_cache.cc | 2 |
1 files changed, 2 insertions, 0 deletions
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()) /* |