From d0d8bbed5e901e59044be6bcaa6d4020238a1eb4 Mon Sep 17 00:00:00 2001
From: unknown <Li-Bing.Song@sun.com>
Date: Wed, 18 Aug 2010 17:35:41 +0800
Subject: WL#5370 Keep forward-compatibility when changing         'CREATE
 TABLE IF NOT EXISTS ... SELECT' behaviour BUG#47132, BUG#47442, BUG49494,
 BUG#23992 and BUG#48814 will disappear automatically after the this patch.
 BUG#55617 is fixed by this patch too.

This is the 5.5 part.
It implements:
- 'CREATE TABLE IF NOT EXISTS ... SELECT' statement will not insert
  anything and binlog anything if the table already exists.
  It only generate a warning that table already exists.
- A couple of test cases for the behavior changing.
---
 sql/sql_view.cc | 2 --
 1 file changed, 2 deletions(-)

(limited to 'sql/sql_view.cc')

diff --git a/sql/sql_view.cc b/sql/sql_view.cc
index be13349b5a1..64386d755eb 100644
--- a/sql/sql_view.cc
+++ b/sql/sql_view.cc
@@ -433,8 +433,6 @@ bool mysql_create_view(THD *thd, TABLE_LIST *views,
     goto err;
 
   lex->link_first_table_back(view, link_to_local);
-  view->open_strategy= TABLE_LIST::OPEN_STUB;
-  view->lock_strategy= TABLE_LIST::OTLS_NONE;
   view->open_type= OT_BASE_ONLY;
 
   if (open_and_lock_tables(thd, lex->query_tables, TRUE, 0))
-- 
cgit v1.2.1