diff options
| author | Igor Babaev <igor@askmonty.org> | 2010-05-26 13:18:18 -0700 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2010-05-26 13:18:18 -0700 |
| commit | 709a0a131021135e9fb7a2095fcfcbc223dfb126 (patch) | |
| tree | 9f8143ae3fa17bac5ab74140da692228d73c283f /sql/sql_load.cc | |
| parent | cb325eb2b2f738b63d162fb0d46cf335e4ae84a4 (diff) | |
| download | mariadb-git-709a0a131021135e9fb7a2095fcfcbc223dfb126.tar.gz | |
MWL#106: Backport optimizations for derived tables and views.
The main consolidated patch.
Diffstat (limited to 'sql/sql_load.cc')
| -rw-r--r-- | sql/sql_load.cc | 7 |
1 files changed, 5 insertions, 2 deletions
diff --git a/sql/sql_load.cc b/sql/sql_load.cc index 82cc8f81b4a..39d36b67f2c 100644 --- a/sql/sql_load.cc +++ b/sql/sql_load.cc @@ -164,12 +164,15 @@ int mysql_load(THD *thd,sql_exchange *ex,TABLE_LIST *table_list, if (open_and_lock_tables(thd, table_list)) DBUG_RETURN(TRUE); + if (mysql_handle_single_derived(thd->lex, table_list, DT_MERGE_FOR_INSERT) || + mysql_handle_single_derived(thd->lex, table_list, DT_PREPARE)) + DBUG_RETURN(TRUE); if (setup_tables_and_check_access(thd, &thd->lex->select_lex.context, &thd->lex->select_lex.top_join_list, table_list, - &thd->lex->select_lex.leaf_tables, FALSE, + thd->lex->select_lex.leaf_tables, FALSE, INSERT_ACL | UPDATE_ACL, - INSERT_ACL | UPDATE_ACL)) + INSERT_ACL | UPDATE_ACL, FALSE)) DBUG_RETURN(-1); if (!table_list->table || // do not suport join view !table_list->updatable || // and derived tables |