List:Commits« Previous MessageNext Message »
From:konstantin Date:July 16 2007 8:59pm
Subject:bk commit into 5.1 tree (kostja:1.2555)
View as plain text  
Below is the list of changes that have just been committed into a local
5.1 repository of kostja. When kostja 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-07-17 00:59:21+04:00, kostja@bodhi.(none) +14 -0
  Post-merge fixes (merge from the main).

  mysql-test/r/innodb_mysql.result@stripped, 2007-07-17 00:59:16+04:00, kostja@bodhi.(none) +4 -48
    Update test results (merge from the main tree).

  mysql-test/r/query_cache.result@stripped, 2007-07-17 00:59:16+04:00, kostja@bodhi.(none) +1 -0
    Update test results (merge from the main tree).

  mysql-test/r/sp.result@stripped, 2007-07-17 00:59:16+04:00, kostja@bodhi.(none) +25 -25
    Update test results (merge from the main tree).

  mysql-test/t/query_cache.test@stripped, 2007-07-17 00:59:16+04:00, kostja@bodhi.(none) +3 -3
    Use --echo End of to simplify future merges.

  sql/handler.h@stripped, 2007-07-17 00:59:16+04:00, kostja@bodhi.(none) +1 -1
    st_table_list -> TABLE_LIST

  sql/item_create.cc@stripped, 2007-07-17 00:59:16+04:00, kostja@bodhi.(none) +1 -1
    A post-merge fix (this code is in sql_yacc.yy in 5.0)

  sql/rpl_utility.h@stripped, 2007-07-17 00:59:16+04:00, kostja@bodhi.(none) +1 -1
    st_table_list -> TABLE_LIST

  sql/sp.cc@stripped, 2007-07-17 00:59:16+04:00, kostja@bodhi.(none) +1 -1
    A post-merge fix.

  sql/sp_head.cc@stripped, 2007-07-17 00:59:16+04:00, kostja@bodhi.(none) +3 -3
    In 5.1 memdup_root returns void*.

  sql/sql_show.cc@stripped, 2007-07-17 00:59:17+04:00, kostja@bodhi.(none) +2 -2
    st_table_list -> TABLE_LIST

  sql/sql_show.h@stripped, 2007-07-17 00:59:17+04:00, kostja@bodhi.(none) +1 -2
    st_table_list -> TABLE_LIST

  sql/sql_yacc.yy@stripped, 2007-07-17 00:59:17+04:00, kostja@bodhi.(none) +2 -1
    A post-merge fix.

  sql/table.cc@stripped, 2007-07-17 00:59:17+04:00, kostja@bodhi.(none) +3 -3
    st_table_list -> TABLE_LIST

  sql/table.h@stripped, 2007-07-17 00:59:17+04:00, kostja@bodhi.(none) +1 -1
    st_table_list -> TABLE_LIST

diff -Nrup a/mysql-test/r/innodb_mysql.result b/mysql-test/r/innodb_mysql.result
--- a/mysql-test/r/innodb_mysql.result	2007-07-16 23:31:32 +04:00
+++ b/mysql-test/r/innodb_mysql.result	2007-07-17 00:59:16 +04:00
@@ -166,7 +166,6 @@ t1.a4='UNcT5pIde4I6c2SheTo4gt92OV1jgJCVk
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	NULL	NULL	NULL	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
 DROP TABLE t1;
-End of 4.1 tests
 create table t1m (a int) engine = MEMORY;
 create table t1i (a int);
 create table t2m (a int) engine = MEMORY;
@@ -362,22 +361,6 @@ id	select_type	table	type	possible_keys	
 1	SIMPLE	t2	index	NULL	fkey	5	NULL	5	Using index
 1	SIMPLE	t1	eq_ref	PRIMARY	PRIMARY	4	test.t2.fkey	1	Using where
 DROP TABLE t1,t2;
-CREATE TABLE t1 (a INT PRIMARY KEY, b INT, c FLOAT, KEY b(b)) ENGINE = INNODB;
-INSERT INTO t1 VALUES (    1 , 1              , 1);
-INSERT INTO t1 SELECT  a + 1 , MOD(a + 1 , 20), 1 FROM t1;
-INSERT INTO t1 SELECT  a + 2 , MOD(a + 2 , 20), 1 FROM t1;
-INSERT INTO t1 SELECT  a + 4 , MOD(a + 4 , 20), 1 FROM t1;
-INSERT INTO t1 SELECT  a + 8 , MOD(a + 8 , 20), 1 FROM t1;
-INSERT INTO t1 SELECT  a + 16, MOD(a + 16, 20), 1 FROM t1;
-INSERT INTO t1 SELECT  a + 32, MOD(a + 32, 20), 1 FROM t1;
-INSERT INTO t1 SELECT  a + 64, MOD(a + 64, 20), 1 FROM t1;
-EXPLAIN SELECT b, SUM(c) FROM t1 GROUP BY b;
-id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
-1	SIMPLE	t1	index	NULL	b	5	NULL	128	
-EXPLAIN SELECT SQL_BIG_RESULT b, SUM(c) FROM t1 GROUP BY b;
-id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
-1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	128	Using filesort
-DROP TABLE t1;
 CREATE TABLE t1 (
 id int NOT NULL,
 name varchar(20) NOT NULL,
@@ -503,37 +486,6 @@ a
 2
 5
 drop table t1;
-set @save_qcache_size=@@global.query_cache_size;
-set @save_qcache_type=@@global.query_cache_type;
-set global query_cache_size=10*1024*1024;
-set global query_cache_type=1;
-drop table if exists `test`;
-Warnings:
-Note	1051	Unknown table 'test'
-CREATE TABLE `test` (`test1` varchar(3) NOT NULL,
-`test2` varchar(4) NOT NULL,PRIMARY KEY  (`test1`))
-ENGINE=InnoDB DEFAULT CHARSET=latin1;
-INSERT INTO `test` (`test1`, `test2`) VALUES ('tes', '5678');
-select * from test;
-test1	test2
-tes	5678
-INSERT INTO `test` (`test1`, `test2`) VALUES ('tes', '1234')
-ON DUPLICATE KEY UPDATE `test2` = '1234';
-select * from test;
-test1	test2
-tes	1234
-flush tables;
-select * from test;
-test1	test2
-tes	1234
-drop table test;
-set global query_cache_type=@save_qcache_type;
-set global query_cache_size=@save_qcache_size;
-drop table if exists t1;
-create table t1 (a int) engine=innodb;
-alter table t1 alter a set default 1;
-drop table t1;
-End of 5.0 tests
 create table t1(
 id int auto_increment,
 c char(1) not null,
@@ -857,6 +809,10 @@ a
 1
 2
 5
+drop table t1;
+drop table if exists t1;
+create table t1 (a int) engine=innodb;
+alter table t1 alter a set default 1;
 drop table t1;
 End of 5.0 tests
 CREATE TABLE `t2` (
diff -Nrup a/mysql-test/r/query_cache.result b/mysql-test/r/query_cache.result
--- a/mysql-test/r/query_cache.result	2007-07-16 23:31:32 +04:00
+++ b/mysql-test/r/query_cache.result	2007-07-17 00:59:16 +04:00
@@ -1301,6 +1301,7 @@ drop procedure f3;
 drop procedure f4;
 drop table t1;
 set GLOBAL query_cache_size=0;
+End of 4.1 tests
 SET GLOBAL query_cache_size=102400;
 create table t1(a int);
 insert into t1 values(0), (1), (4), (5);
diff -Nrup a/mysql-test/r/sp.result b/mysql-test/r/sp.result
--- a/mysql-test/r/sp.result	2007-07-16 23:31:33 +04:00
+++ b/mysql-test/r/sp.result	2007-07-17 00:59:16 +04:00
@@ -5659,31 +5659,6 @@ t3_id_1	t3_id_2	t4_id
 DROP PROCEDURE p1|
 DROP VIEW v1, v2|
 DROP TABLE t3, t4|
-drop database if exists mysqltest_db1;
-create database mysqltest_db1;
-create procedure mysqltest_db1.sp_bug28551() begin end;
-call mysqltest_db1.sp_bug28551();
-show warnings;
-Level	Code	Message
-drop database mysqltest_db1;
-drop database if exists mysqltest_db1;
-drop table if exists test.t1;
-create database mysqltest_db1;
-use mysqltest_db1;
-drop database mysqltest_db1;
-create table test.t1 (id int);
-insert into test.t1 (id) values (1);
-create procedure test.sp_bug29050() begin select * from t1; end//
-show warnings;
-Level	Code	Message
-call test.sp_bug29050();
-id
-1
-show warnings;
-Level	Code	Message
-use test;
-drop procedure sp_bug29050;
-drop table t1;
 End of 5.0 tests
 Begin of 5.1 tests
 drop function if exists pi;
@@ -6306,6 +6281,31 @@ v1	CREATE ALGORITHM=UNDEFINED DEFINER=`r
 DROP VIEW v1;
 DROP FUNCTION metered;
 DROP TABLE t1;
+drop database if exists mysqltest_db1;
+create database mysqltest_db1;
+create procedure mysqltest_db1.sp_bug28551() begin end;
+call mysqltest_db1.sp_bug28551();
+show warnings;
+Level	Code	Message
+drop database mysqltest_db1;
+drop database if exists mysqltest_db1;
+drop table if exists test.t1;
+create database mysqltest_db1;
+use mysqltest_db1;
+drop database mysqltest_db1;
+create table test.t1 (id int);
+insert into test.t1 (id) values (1);
+create procedure test.sp_bug29050() begin select * from t1; end//
+show warnings;
+Level	Code	Message
+call test.sp_bug29050();
+id
+1
+show warnings;
+Level	Code	Message
+use test;
+drop procedure sp_bug29050;
+drop table t1;
 drop procedure if exists proc_25411_a;
 drop procedure if exists proc_25411_b;
 drop procedure if exists proc_25411_c;
diff -Nrup a/mysql-test/t/query_cache.test b/mysql-test/t/query_cache.test
--- a/mysql-test/t/query_cache.test	2007-07-16 23:02:44 +04:00
+++ b/mysql-test/t/query_cache.test	2007-07-17 00:59:16 +04:00
@@ -878,7 +878,7 @@ drop procedure f4;
 drop table t1;
 set GLOBAL query_cache_size=0;
 
-# End of 4.1 tests
+--echo End of 4.1 tests
 
 #
 # Bug #10303: problem with last_query_cost
@@ -1129,7 +1129,7 @@ set GLOBAL query_cache_type=default;
 set GLOBAL query_cache_limit=default;
 set GLOBAL query_cache_min_res_unit=default;
 set GLOBAL query_cache_size=default;
-# End of 5.0 tests
+--echo End of 5.0 tests
 
 
 #
@@ -1174,4 +1174,4 @@ show status like 'Qcache_queries_in_cach
 drop database db2;
 drop database db3;
 
-# End of 5.1 tests
+--echo End of 5.1 tests
diff -Nrup a/sql/handler.h b/sql/handler.h
--- a/sql/handler.h	2007-07-16 23:31:33 +04:00
+++ b/sql/handler.h	2007-07-17 00:59:16 +04:00
@@ -663,7 +663,7 @@ struct handlerton
    uint (*alter_table_flags)(uint flags);
    int (*alter_tablespace)(handlerton *hton, THD *thd, st_alter_tablespace *ts_info);
    int (*fill_files_table)(handlerton *hton, THD *thd,
-                           struct st_table_list *tables,
+                           TABLE_LIST *tables,
                            class Item *cond);
    uint32 flags;                                /* global handler flags */
    /*
diff -Nrup a/sql/item_create.cc b/sql/item_create.cc
--- a/sql/item_create.cc	2007-07-08 07:02:55 +04:00
+++ b/sql/item_create.cc	2007-07-17 00:59:16 +04:00
@@ -2326,7 +2326,7 @@ Item*
 Create_qfunc::create(THD *thd, LEX_STRING name, List<Item> *item_list)
 {
   LEX_STRING db;
-  if (thd->copy_db_to(&db.str, &db.length))
+  if (thd->lex->copy_db_to(&db.str, &db.length))
     return NULL;
 
   return create(thd, db, name, false, item_list);
diff -Nrup a/sql/rpl_utility.h b/sql/rpl_utility.h
--- a/sql/rpl_utility.h	2007-05-24 02:39:21 +04:00
+++ b/sql/rpl_utility.h	2007-07-17 00:59:16 +04:00
@@ -128,7 +128,7 @@ private:
    slave thread, but nowhere else.
  */
 struct RPL_TABLE_LIST
-  : public st_table_list
+  : public TABLE_LIST
 {
   bool m_tabledef_valid;
   table_def m_tabledef;
diff -Nrup a/sql/sp.cc b/sql/sp.cc
--- a/sql/sp.cc	2007-07-16 23:31:33 +04:00
+++ b/sql/sp.cc	2007-07-17 00:59:16 +04:00
@@ -1954,7 +1954,7 @@ sp_cache_routines_and_add_tables_for_tri
   }
   ret= sp_cache_routines_and_add_tables_aux(thd, lex,
                                             *last_cached_routine_ptr,
-                                            FALSE, NULL);
+                                            FALSE);
   return ret;
 }
 
diff -Nrup a/sql/sp_head.cc b/sql/sp_head.cc
--- a/sql/sp_head.cc	2007-07-16 23:31:33 +04:00
+++ b/sql/sp_head.cc	2007-07-17 00:59:16 +04:00
@@ -567,9 +567,9 @@ sp_head::init_sp_name(THD *thd, sp_name 
     spname->init_qname(thd);
 
   m_sroutines_key.length= spname->m_sroutines_key.length;
-  m_sroutines_key.str= memdup_root(thd->mem_root,
-                                   spname->m_sroutines_key.str,
-                                   spname->m_sroutines_key.length + 1);
+  m_sroutines_key.str= (char*) memdup_root(thd->mem_root,
+                                           spname->m_sroutines_key.str,
+                                           spname->m_sroutines_key.length + 1);
   m_sroutines_key.str[0]= static_cast<char>(m_type);
 
   m_qname.length= m_sroutines_key.length - 1;
diff -Nrup a/sql/sql_show.cc b/sql/sql_show.cc
--- a/sql/sql_show.cc	2007-07-16 23:02:46 +04:00
+++ b/sql/sql_show.cc	2007-07-17 00:59:17 +04:00
@@ -4094,7 +4094,7 @@ static void store_schema_partitions_reco
 }
 
 
-static int get_schema_partitions_record(THD *thd, struct st_table_list *tables,
+static int get_schema_partitions_record(THD *thd, TABLE_LIST *tables,
                                         TABLE *table, bool res,
                                         const char *base_name,
                                         const char *file_name)
@@ -4640,7 +4640,7 @@ int fill_status(THD *thd, TABLE_LIST *ta
 */
 
 static int
-get_referential_constraints_record(THD *thd, struct st_table_list *tables,
+get_referential_constraints_record(THD *thd, TABLE_LIST *tables,
                                    TABLE *table, bool res,
                                    const char *base_name, const char *file_name)
 {
diff -Nrup a/sql/sql_show.h b/sql/sql_show.h
--- a/sql/sql_show.h	2006-12-31 04:28:54 +03:00
+++ b/sql/sql_show.h	2007-07-17 00:59:17 +04:00
@@ -20,9 +20,8 @@
 class String;
 class THD;
 struct st_ha_create_information;
-struct st_table_list;
 typedef st_ha_create_information HA_CREATE_INFO;
-typedef st_table_list TABLE_LIST;
+struct TABLE_LIST;
 
 enum find_files_result {
   FIND_FILES_OK,
diff -Nrup a/sql/sql_yacc.yy b/sql/sql_yacc.yy
--- a/sql/sql_yacc.yy	2007-07-16 23:31:33 +04:00
+++ b/sql/sql_yacc.yy	2007-07-17 00:59:17 +04:00
@@ -1940,7 +1940,8 @@ sp_name:
 	  }
 	| ident
 	  {
-            LEX *lex= Lex;
+            THD *thd= YYTHD;
+            LEX *lex= thd->lex;
             LEX_STRING db;
 	    if (check_routine_name(&$1))
             {
diff -Nrup a/sql/table.cc b/sql/table.cc
--- a/sql/table.cc	2007-07-16 23:02:47 +04:00
+++ b/sql/table.cc	2007-07-17 00:59:17 +04:00
@@ -98,7 +98,7 @@ View_creation_ctx *View_creation_ctx::cr
 /*************************************************************************/
 
 View_creation_ctx * View_creation_ctx::create(THD *thd,
-                                              st_table_list *view)
+                                              TABLE_LIST *view)
 {
   View_creation_ctx *ctx= new (thd->mem_root) View_creation_ctx(thd);
 
@@ -4588,7 +4588,7 @@ Item_subselect *TABLE_LIST::containing_s
 
   DESCRIPTION
     The parser collects the index hints for each table in a "tagged list" 
-    (st_table_list::index_hints). Using the information in this tagged list
+    (TABLE_LIST::index_hints). Using the information in this tagged list
     this function sets the members st_table::keys_in_use_for_query, 
     st_table::keys_in_use_for_group_by, st_table::keys_in_use_for_order_by,
     st_table::force_index and st_table::covering_keys.
@@ -4630,7 +4630,7 @@ Item_subselect *TABLE_LIST::containing_s
     FALSE                no errors found
     TRUE                 found and reported an error.
 */
-bool st_table_list::process_index_hints(TABLE *table)
+bool TABLE_LIST::process_index_hints(TABLE *table)
 {
   /* initialize the result variables */
   table->keys_in_use_for_query= table->keys_in_use_for_group_by= 
diff -Nrup a/sql/table.h b/sql/table.h
--- a/sql/table.h	2007-07-16 23:31:33 +04:00
+++ b/sql/table.h	2007-07-17 00:59:17 +04:00
@@ -38,7 +38,7 @@ public:
   static View_creation_ctx *create(THD *thd);
 
   static View_creation_ctx *create(THD *thd,
-                                   struct st_table_list *view);
+                                   TABLE_LIST *view);
 
 private:
   View_creation_ctx(THD *thd)
Thread
bk commit into 5.1 tree (kostja:1.2555)konstantin16 Jul