Bug #47335 assert in get_table_share

Description:
The assertion happens in sql_base.cc:473
DBUG_ASSERT(thd->mdl_context.is_lock_owner(MDL_TABLE, table_list->db,
                                             table_list->table_name));

My script:
----------
CREATE TEMPORARY TABLE db_not_exists.t1  AS SELECT 1 AS f1;
CREATE TEMPORARY TABLE db_not_exists.t2  AS SELECT 1 AS f1;
ALTER VIEW db_not_exists.t1 AS SELECT f1 FROM db_not_exists.t2;

Backtrace on mysql-next-bugfixing 2009-09-15:
---------------------------------------------
Thread 1 (process 12129):
#0  0x00007f76123a5ce6 in pthread_kill () from /lib64/libpthread.so.0
#1  0x0000000000b7410c in my_write_core (sig=6) at stacktrace.c:309
#2  0x00000000006f359d in handle_segfault (sig=6) at mysqld.cc:2739
#3  <signal handler called>
#4  0x00007f76112a15c5 in raise () from /lib64/libc.so.6
#5  0x00007f76112a2bb3 in abort () from /lib64/libc.so.6
#6  0x00007f761129a1e9 in __assert_fail () from /lib64/libc.so.6
#7  0x0000000000760391 in get_table_share (thd=0x1614938, table_list=0x40ee7a10, key=0x40ee7fb0 "db_not_exists", key_length=17, db_flags=8192, error=0x40ee79c4) at sql_base.cc:473
#8  0x000000000076077e in get_table_share_with_create (thd=0x1614938, table_list=0x40ee7a10, key=0x40ee7fb0 "db_not_exists", key_length=17, db_flags=8192, error=0x40ee79c4) at sql_base.cc:572
#9  0x0000000000760fe3 in tdc_open_view (thd=0x1614938, table_list=0x40ee7a10, alias=0x16937f0 "t1", cache_key=0x40ee7fb0 "db_not_exists", cache_key_length=17, mem_root=0x1617420, flags=16384) at sql_base.cc:3455
#10 0x00000000008e3b57 in fill_defined_view_parts (thd=0x1614938, view=0x16937f8) at sql_view.cc:189
#11 0x00000000008e3e5a in mysql_create_view (thd=0x1614938, views=0x16937f8, mode=VIEW_ALTER) at sql_view.cc:412
#12 0x000000000070dc70 in mysql_execute_command (thd=0x1614938) at sql_parse.cc:4673
#13 0x000000000070e790 in mysql_parse (thd=0x1614938, inBuf=0x16936c0 "ALTER VIEW db_not_exists.t1 AS SELECT f1 FROM db_not_exists.t2", length=62, found_semicolon=0x40ee9f20) at sql_parse.cc:5957
#14 0x000000000070f3cc in dispatch_command (command=COM_QUERY, thd=0x1614938, packet=0x16ea989 "ALTER VIEW db_not_exists.t1 AS SELECT f1 FROM db_not_exists.t2", packet_length=62) at sql_parse.cc:1073
#15 0x0000000000710893 in do_command (thd=0x1614938) at sql_parse.cc:755
#16 0x00000000006fd730 in handle_one_connection (arg=0x1614938) at sql_connect.cc:1163
#17 0x00007f76123a1040 in start_thread () from /lib64/libpthread.so.0
#18 0x00007f761134208d in clone () from /lib64/libc.so.6
#19 0x0000000000000000 in ?? ()

Result on mysql-5.1-bugteam 2009-08-28
--------------------------------------
At line 3: query 'ALTER VIEW db_not_exists.t1 AS SELECT f1 FROM db_not_exists.t2' failed: 1347: 'db_not_exists.t1' is not VIEW

My environment:
---------------
- ./BUILD/compile-pentium64-debug-max
- Linux OpenSuSE 11.0 (64 Bit)
- Intel Core2Duo

How to repeat:
See above

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/84453

2838 Jon Olav Hauglid	2009-09-24
      Bug #47335 assert in get_table_share
      
      The assert would happen if ALTER VIEW was used to alter a view (existing 
      or non-existing) and a temporary table with the same name already existed.
      
      The assert is triggered if the current statement does not have a MDL lock on 
      the view to be altered. This would happen because open_table() would open 
      the temporary table instead and MDL locks are not taken for temporary 
      tables (since they are local to one connection).
      
      The patch changes open_type for CREATE/ALTER VIEW to OT_BASE_ONLY. This prevents 
      open_table() from trying to open a temporary table with the same name should
      one exist. Now the view will be altered if it exists or ER_NO_SUCH_TABLE will
      be reported if it does not.
      
      Test case added to view.test

Pushed to mysql-6.0-codebase-bugfixing (version 6.0.14-alpha)

Pushed into 6.0.14-alpha (revid:alik@sun.com-20090929093622-1mooerbh12e97zux) (version source revid:alik@sun.com-20090927203924-087s36mrs0uxepwb) (merge vers: 6.0.14-alpha) (pib:11)

Noted in 6.0.14 changelog.

The assert could be raised if ALTER VIEW was used to alter a view
(existing or nonexisting) and a temporary table with the same name
already existed.

Pushed to mysql-next-4284 (5.6.0-beta).

Pushed into 6.0.14-alpha (revid:alik@sun.com-20100216101445-2ofzkh48aq2e0e8o) (version source revid:kostja@sun.com-20091211154405-c9yhiewr9o5d20rq) (merge vers: 6.0.14-alpha) (pib:16)

Pushed into mysql-next-mr (revid:alik@sun.com-20100216101208-33qkfwdr0tep3pf2) (version source revid:jon.hauglid@sun.com-20091210121520-r8frcrrhks821r7t) (pib:16)

Setting report to Need Merge pending push of Celosia into release tree.

Pushed into 5.5.3-m3 (revid:alik@sun.com-20100306103849-hha31z2enhh7jwt3) (version source revid:vvaintroub@mysql.com-20100216221947-luyhph0txl2c5tc8) (merge vers: 5.5.99-m3) (pib:16)

Noted in 5.5.3 changelog.

Correction: Not present in any 5.5.x release. 5.5.3 changelog entry removed.