bk commit into 5.0 tree (gluh:1.2493) BUG#29408

[gluh]

Below is the list of changes that have just been committed into a local
5.0 repository of gluh. When gluh does a push these changes will
be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://dev.mysql.com/doc/mysql/en/installing-source-tree.html

ChangeSet@stripped, 2007-08-21 14:00:16+05:00, gluh@stripped +4 -0
  Bug#29408 Cannot find view in columns table if the selection contains a function
  we should use view db name as thread db name when
  connection is performed without db name

  mysql-test/r/sp.result@stripped, 2007-08-21 14:00:14+05:00, gluh@stripped +22 -0
    test result

  mysql-test/t/sp.test@stripped, 2007-08-21 14:00:14+05:00, gluh@stripped +32 -0
    test case

  sql/sql_parse.cc@stripped, 2007-08-21 14:00:15+05:00, gluh@stripped +1 -1
    copy thd->db_length to table_list->db_length

  sql/sql_view.cc@stripped, 2007-08-21 14:00:15+05:00, gluh@stripped +14 -0
    we should use view db name as thread db name when
    connection is performed without db name

diff -Nrup a/mysql-test/r/sp.result b/mysql-test/r/sp.result
--- a/mysql-test/r/sp.result	2007-07-30 04:33:31 +05:00
+++ b/mysql-test/r/sp.result	2007-08-21 14:00:14 +05:00
@@ -6314,4 +6314,26 @@ CALL p1();
 NULL
 SET NAMES default;
 DROP PROCEDURE p1;
+create function f1()
+returns int(11)
+not deterministic
+contains sql
+sql security definer
+comment ''
+begin
+declare x int(11);
+set x=-1;
+return x;
+end|
+create view v1 as select 1 as one, f1() as days;
+show create view test.v1;
+View	Create View
+v1	CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW
`test`.`v1` AS select 1 AS `one`,`f1`() AS `days`
+select column_name from information_schema.columns
+where table_name='v1' and table_schema='test';
+column_name
+one
+days
+drop view v1;
+drop function f1;
 End of 5.0 tests
diff -Nrup a/mysql-test/t/sp.test b/mysql-test/t/sp.test
--- a/mysql-test/t/sp.test	2007-07-30 04:33:10 +05:00
+++ b/mysql-test/t/sp.test	2007-08-21 14:00:14 +05:00
@@ -7299,4 +7299,36 @@ CALL p1();
 SET NAMES default;
 DROP PROCEDURE p1;
 
+#
+# Bug#29408 Cannot find view in columns table if the selection contains a function
+#
+delimiter |;
+
+create function f1()
+    returns int(11)
+not deterministic
+contains sql
+sql security definer
+comment ''
+begin
+  declare x int(11);
+  set x=-1;
+   return x;
+end|
+                          
+delimiter ;|
+                  
+create view v1 as select 1 as one, f1() as days;
+                          
+connect (bug29408, localhost, root,,*NO-ONE*);                     
+connection bug29408;
+
+show create view test.v1;      
+select column_name from information_schema.columns
+where table_name='v1' and table_schema='test';
+
+connection default;
+drop view v1;
+drop function f1;
+
 --echo End of 5.0 tests
diff -Nrup a/sql/sql_parse.cc b/sql/sql_parse.cc
--- a/sql/sql_parse.cc	2007-08-02 14:51:00 +05:00
+++ b/sql/sql_parse.cc	2007-08-21 14:00:15 +05:00
@@ -1864,7 +1864,7 @@ bool dispatch_command(enum enum_server_c
     statistic_increment(thd->status_var.com_stat[SQLCOM_SHOW_FIELDS],
 			&LOCK_status);
     bzero((char*) &table_list,sizeof(table_list));
-    if (thd->copy_db_to(&table_list.db, 0))
+    if (thd->copy_db_to(&table_list.db, &table_list.db_length))
       break;
     pend= strend(packet);
     thd->convert_string(&conv_name, system_charset_info,
diff -Nrup a/sql/sql_view.cc b/sql/sql_view.cc
--- a/sql/sql_view.cc	2007-07-12 23:26:39 +05:00
+++ b/sql/sql_view.cc	2007-08-21 14:00:15 +05:00
@@ -1002,8 +1002,19 @@ bool mysql_make_view(THD *thd, File_pars
   table->view= lex= thd->lex= (LEX*) new(thd->mem_root) st_lex_local;
 
   {
+    char old_db_buf[NAME_LEN+1];
+    LEX_STRING old_db= { old_db_buf, sizeof(old_db_buf) };
+    bool dbchanged;
     Lex_input_stream lip(thd, table->query.str, table->query.length);
     thd->m_lip= &lip;
+
+    /* 
+      use view db name as thread db name when
+      connection is performed without db name
+    */
+    if ((result= sp_use_new_db(thd, table->view_db, &old_db, 1, &dbchanged)))
+      goto end;
+
     lex_start(thd);
     view_select= &lex->select_lex;
     view_select->select_number= ++thd->select_number;
@@ -1045,6 +1056,9 @@ bool mysql_make_view(THD *thd, File_pars
 
     thd->variables.character_set_client= save_cs;
     thd->variables.sql_mode= save_mode;
+
+    if (dbchanged && mysql_change_db(thd, &old_db, TRUE))
+      goto err;
   }
   if (!res && !thd->is_fatal_error)
   {