List:Commits« Previous MessageNext Message »
From:Nirbhay Choubey Date:January 5 2011 7:13am
Subject:bzr commit into mysql-5.5 branch (nirbhay.choubey:3216)
View as plain text  
#At file:///home/nirbhay/Project/mysql/repo/engines/mysql-5.5/ based on revid:nirbhay.choubey@stripped

 3216 Nirbhay Choubey	2011-01-05 [merge]
      
      Updating the local repository.

    modified:
      mysql-test/suite/perfschema/include/binlog_common.inc
      mysql-test/suite/perfschema/r/binlog_mix.result
      mysql-test/suite/perfschema/r/binlog_row.result
      mysql-test/suite/perfschema/r/binlog_stmt.result
      mysql-test/suite/perfschema/t/binlog_mix.test
      mysql-test/suite/perfschema/t/binlog_row.test
      mysql-test/suite/perfschema/t/binlog_stmt.test
=== modified file 'mysql-test/suite/perfschema/include/binlog_common.inc'
--- a/mysql-test/suite/perfschema/include/binlog_common.inc	2010-11-03 15:42:33 +0000
+++ b/mysql-test/suite/perfschema/include/binlog_common.inc	2011-01-04 09:04:02 +0000
@@ -1,4 +1,4 @@
-# Copyright (C) 2009 Sun Microsystems, Inc
+# Copyright (c) 2009, 2011, Oracle and/or its affiliates. All rights reserved.
 #
 # This program is free software; you can redistribute it and/or modify
 # it under the terms of the GNU General Public License as published by
@@ -10,8 +10,8 @@
 # GNU General Public License for more details.
 #
 # You should have received a copy of the GNU General Public License
-# along with this program; if not, write to the Free Software
-# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
+# along with this program; if not, write to the Free Software Foundation,
+# 51 Franklin Street, Suite 500, Boston, MA 02110-1335 USA
 
 # Tests for PERFORMANCE_SCHEMA
 
@@ -19,8 +19,13 @@ RESET MASTER;
 
 select count(*) > 0 from performance_schema.setup_instruments;
 
+# Note:
+# Do not include records that could depend on
+# compiling options (storage engines, SSL),
+# to ensure the expected output in the binlog is predictable.
 update performance_schema.setup_instruments set enabled='NO'
-  where name like "wait/synch/rwlock/%";
+  where name like "wait/synch/rwlock/sql/%"
+  and name not in ("wait/synch/rwlock/sql/CRYPTO_dynlock_value::lock");
 
 select count(*) > 0 from performance_schema.events_waits_current;
 
@@ -37,13 +42,15 @@ insert into test.t1
 
 insert into test.t2
   select name from performance_schema.setup_instruments
-    where name like "wait/synch/rwlock/%";
+    where name like "wait/synch/rwlock/sql/%"
+    and name not in ("wait/synch/rwlock/sql/CRYPTO_dynlock_value::lock");
 
 drop table test.t1;
 drop table test.t2;
 
 update performance_schema.setup_instruments set enabled='YES'
-  where name like "wait/synch/rwlock/%";
+  where name like "wait/synch/rwlock/sql/%"
+  and name not in ("wait/synch/rwlock/sql/CRYPTO_dynlock_value::lock");
 
 --source include/show_binlog_events.inc
 

=== modified file 'mysql-test/suite/perfschema/r/binlog_mix.result'
--- a/mysql-test/suite/perfschema/r/binlog_mix.result	2010-11-03 15:42:33 +0000
+++ b/mysql-test/suite/perfschema/r/binlog_mix.result	2011-01-04 09:04:02 +0000
@@ -4,7 +4,8 @@ select count(*) > 0 from performance_sch
 count(*) > 0
 1
 update performance_schema.setup_instruments set enabled='NO'
-  where name like "wait/synch/rwlock/%";
+  where name like "wait/synch/rwlock/sql/%"
+  and name not in ("wait/synch/rwlock/sql/CRYPTO_dynlock_value::lock");
 select count(*) > 0 from performance_schema.events_waits_current;
 count(*) > 0
 1
@@ -16,16 +17,17 @@ insert into test.t1
 select thread_id from performance_schema.events_waits_current;
 insert into test.t2
 select name from performance_schema.setup_instruments
-where name like "wait/synch/rwlock/%";
+where name like "wait/synch/rwlock/sql/%"
+    and name not in ("wait/synch/rwlock/sql/CRYPTO_dynlock_value::lock");
 drop table test.t1;
 drop table test.t2;
 update performance_schema.setup_instruments set enabled='YES'
-  where name like "wait/synch/rwlock/%";
+  where name like "wait/synch/rwlock/sql/%"
+  and name not in ("wait/synch/rwlock/sql/CRYPTO_dynlock_value::lock");
 show binlog events from <binlog_start>;
 Log_name	Pos	Event_type	Server_id	End_log_pos	Info
 master-bin.000001	#	Query	#	#	BEGIN
 master-bin.000001	#	Table_map	#	#	table_id: # (performance_schema.setup_instruments)
-master-bin.000001	#	Update_rows	#	#	table_id: #
 master-bin.000001	#	Update_rows	#	#	table_id: # flags: STMT_END_F
 master-bin.000001	#	Query	#	#	COMMIT
 master-bin.000001	#	Query	#	#	use `test`; DROP TABLE IF EXISTS `t1` /* generated by server */
@@ -44,6 +46,5 @@ master-bin.000001	#	Query	#	#	use `test`
 master-bin.000001	#	Query	#	#	use `test`; DROP TABLE `t2` /* generated by server */
 master-bin.000001	#	Query	#	#	BEGIN
 master-bin.000001	#	Table_map	#	#	table_id: # (performance_schema.setup_instruments)
-master-bin.000001	#	Update_rows	#	#	table_id: #
 master-bin.000001	#	Update_rows	#	#	table_id: # flags: STMT_END_F
 master-bin.000001	#	Query	#	#	COMMIT

=== modified file 'mysql-test/suite/perfschema/r/binlog_row.result'
--- a/mysql-test/suite/perfschema/r/binlog_row.result	2010-11-03 15:42:33 +0000
+++ b/mysql-test/suite/perfschema/r/binlog_row.result	2011-01-04 09:04:02 +0000
@@ -4,7 +4,8 @@ select count(*) > 0 from performance_sch
 count(*) > 0
 1
 update performance_schema.setup_instruments set enabled='NO'
-  where name like "wait/synch/rwlock/%";
+  where name like "wait/synch/rwlock/sql/%"
+  and name not in ("wait/synch/rwlock/sql/CRYPTO_dynlock_value::lock");
 select count(*) > 0 from performance_schema.events_waits_current;
 count(*) > 0
 1
@@ -16,16 +17,17 @@ insert into test.t1
 select thread_id from performance_schema.events_waits_current;
 insert into test.t2
 select name from performance_schema.setup_instruments
-where name like "wait/synch/rwlock/%";
+where name like "wait/synch/rwlock/sql/%"
+    and name not in ("wait/synch/rwlock/sql/CRYPTO_dynlock_value::lock");
 drop table test.t1;
 drop table test.t2;
 update performance_schema.setup_instruments set enabled='YES'
-  where name like "wait/synch/rwlock/%";
+  where name like "wait/synch/rwlock/sql/%"
+  and name not in ("wait/synch/rwlock/sql/CRYPTO_dynlock_value::lock");
 show binlog events from <binlog_start>;
 Log_name	Pos	Event_type	Server_id	End_log_pos	Info
 master-bin.000001	#	Query	#	#	BEGIN
 master-bin.000001	#	Table_map	#	#	table_id: # (performance_schema.setup_instruments)
-master-bin.000001	#	Update_rows	#	#	table_id: #
 master-bin.000001	#	Update_rows	#	#	table_id: # flags: STMT_END_F
 master-bin.000001	#	Query	#	#	COMMIT
 master-bin.000001	#	Query	#	#	use `test`; DROP TABLE IF EXISTS `t1` /* generated by server */
@@ -44,6 +46,5 @@ master-bin.000001	#	Query	#	#	use `test`
 master-bin.000001	#	Query	#	#	use `test`; DROP TABLE `t2` /* generated by server */
 master-bin.000001	#	Query	#	#	BEGIN
 master-bin.000001	#	Table_map	#	#	table_id: # (performance_schema.setup_instruments)
-master-bin.000001	#	Update_rows	#	#	table_id: #
 master-bin.000001	#	Update_rows	#	#	table_id: # flags: STMT_END_F
 master-bin.000001	#	Query	#	#	COMMIT

=== modified file 'mysql-test/suite/perfschema/r/binlog_stmt.result'
--- a/mysql-test/suite/perfschema/r/binlog_stmt.result	2010-11-03 15:42:33 +0000
+++ b/mysql-test/suite/perfschema/r/binlog_stmt.result	2011-01-04 09:04:02 +0000
@@ -5,7 +5,8 @@ select count(*) > 0 from performance_sch
 count(*) > 0
 1
 update performance_schema.setup_instruments set enabled='NO'
-  where name like "wait/synch/rwlock/%";
+  where name like "wait/synch/rwlock/sql/%"
+  and name not in ("wait/synch/rwlock/sql/CRYPTO_dynlock_value::lock");
 Warnings:
 Note	1592	Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on slaves.
 select count(*) > 0 from performance_schema.events_waits_current;
@@ -21,20 +22,23 @@ Warnings:
 Note	1592	Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on slaves.
 insert into test.t2
 select name from performance_schema.setup_instruments
-where name like "wait/synch/rwlock/%";
+where name like "wait/synch/rwlock/sql/%"
+    and name not in ("wait/synch/rwlock/sql/CRYPTO_dynlock_value::lock");
 Warnings:
 Note	1592	Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on slaves.
 drop table test.t1;
 drop table test.t2;
 update performance_schema.setup_instruments set enabled='YES'
-  where name like "wait/synch/rwlock/%";
+  where name like "wait/synch/rwlock/sql/%"
+  and name not in ("wait/synch/rwlock/sql/CRYPTO_dynlock_value::lock");
 Warnings:
 Note	1592	Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on slaves.
 show binlog events from <binlog_start>;
 Log_name	Pos	Event_type	Server_id	End_log_pos	Info
 master-bin.000001	#	Query	#	#	BEGIN
 master-bin.000001	#	Query	#	#	use `test`; update performance_schema.setup_instruments set enabled='NO'
-  where name like "wait/synch/rwlock/%"
+  where name like "wait/synch/rwlock/sql/%"
+  and name not in ("wait/synch/rwlock/sql/CRYPTO_dynlock_value::lock")
 master-bin.000001	#	Query	#	#	COMMIT
 master-bin.000001	#	Query	#	#	use `test`; DROP TABLE IF EXISTS `t1` /* generated by server */
 master-bin.000001	#	Query	#	#	use `test`; DROP TABLE IF EXISTS `t2` /* generated by server */
@@ -47,11 +51,13 @@ master-bin.000001	#	Query	#	#	COMMIT
 master-bin.000001	#	Query	#	#	BEGIN
 master-bin.000001	#	Query	#	#	use `test`; insert into test.t2
 select name from performance_schema.setup_instruments
-where name like "wait/synch/rwlock/%"
+where name like "wait/synch/rwlock/sql/%"
+    and name not in ("wait/synch/rwlock/sql/CRYPTO_dynlock_value::lock")
 master-bin.000001	#	Query	#	#	COMMIT
 master-bin.000001	#	Query	#	#	use `test`; DROP TABLE `t1` /* generated by server */
 master-bin.000001	#	Query	#	#	use `test`; DROP TABLE `t2` /* generated by server */
 master-bin.000001	#	Query	#	#	BEGIN
 master-bin.000001	#	Query	#	#	use `test`; update performance_schema.setup_instruments set enabled='YES'
-  where name like "wait/synch/rwlock/%"
+  where name like "wait/synch/rwlock/sql/%"
+  and name not in ("wait/synch/rwlock/sql/CRYPTO_dynlock_value::lock")
 master-bin.000001	#	Query	#	#	COMMIT

=== modified file 'mysql-test/suite/perfschema/t/binlog_mix.test'
--- a/mysql-test/suite/perfschema/t/binlog_mix.test	2010-01-12 01:47:27 +0000
+++ b/mysql-test/suite/perfschema/t/binlog_mix.test	2011-01-04 09:04:02 +0000
@@ -1,4 +1,4 @@
-# Copyright (C) 2009 Sun Microsystems, Inc
+# Copyright (c) 2009, 2011, Oracle and/or its affiliates. All rights reserved.
 #
 # This program is free software; you can redistribute it and/or modify
 # it under the terms of the GNU General Public License as published by
@@ -10,8 +10,8 @@
 # GNU General Public License for more details.
 #
 # You should have received a copy of the GNU General Public License
-# along with this program; if not, write to the Free Software
-# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
+# along with this program; if not, write to the Free Software Foundation,
+# 51 Franklin Street, Suite 500, Boston, MA 02110-1335 USA
 
 # Tests for PERFORMANCE_SCHEMA
 
@@ -19,9 +19,6 @@
 --source include/not_embedded.inc
 --source include/have_perfschema.inc
 
-# See Bug#46896 binlog: case sensitivity of table names
---source include/have_lowercase0.inc
-
 set binlog_format=mixed;
 
 --source ../include/binlog_common.inc

=== modified file 'mysql-test/suite/perfschema/t/binlog_row.test'
--- a/mysql-test/suite/perfschema/t/binlog_row.test	2010-01-12 01:47:27 +0000
+++ b/mysql-test/suite/perfschema/t/binlog_row.test	2011-01-04 09:04:02 +0000
@@ -1,4 +1,4 @@
-# Copyright (C) 2009 Sun Microsystems, Inc
+# Copyright (c) 2009, 2011, Oracle and/or its affiliates. All rights reserved.
 #
 # This program is free software; you can redistribute it and/or modify
 # it under the terms of the GNU General Public License as published by
@@ -10,8 +10,8 @@
 # GNU General Public License for more details.
 #
 # You should have received a copy of the GNU General Public License
-# along with this program; if not, write to the Free Software
-# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
+# along with this program; if not, write to the Free Software Foundation,
+# 51 Franklin Street, Suite 500, Boston, MA 02110-1335 USA
 
 # Tests for PERFORMANCE_SCHEMA
 
@@ -19,9 +19,6 @@
 --source include/not_embedded.inc
 --source include/have_perfschema.inc
 
-# See Bug#46896 binlog: case sensitivity of table names
---source include/have_lowercase0.inc
-
 set binlog_format=row;
 
 --source ../include/binlog_common.inc

=== modified file 'mysql-test/suite/perfschema/t/binlog_stmt.test'
--- a/mysql-test/suite/perfschema/t/binlog_stmt.test	2010-04-28 12:47:49 +0000
+++ b/mysql-test/suite/perfschema/t/binlog_stmt.test	2011-01-04 09:04:02 +0000
@@ -1,4 +1,4 @@
-# Copyright (C) 2009 Sun Microsystems, Inc
+# Copyright (c) 2009, 2011, Oracle and/or its affiliates. All rights reserved.
 #
 # This program is free software; you can redistribute it and/or modify
 # it under the terms of the GNU General Public License as published by
@@ -10,8 +10,8 @@
 # GNU General Public License for more details.
 #
 # You should have received a copy of the GNU General Public License
-# along with this program; if not, write to the Free Software
-# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
+# along with this program; if not, write to the Free Software Foundation,
+# 51 Franklin Street, Suite 500, Boston, MA 02110-1335 USA
 
 # Tests for PERFORMANCE_SCHEMA
 


Attachment: [text/bzr-bundle]
Thread
bzr commit into mysql-5.5 branch (nirbhay.choubey:3216)Nirbhay Choubey5 Jan