bzr commit into mysql-next-mr-innodb branch (inaam.rana:3245)

[Inaam Rana]

#At file:///home/inaam/w/page_hash/ based on revid:jimmy.yang@stripped

 3245 Inaam Rana	2010-07-26
      Add basic test case for innodb_page_hash_mutexes

    added:
      mysql-test/suite/sys_vars/r/innodb_page_hash_mutexes_basic.result
      mysql-test/suite/sys_vars/t/innodb_page_hash_mutexes_basic.test
=== added file 'mysql-test/suite/sys_vars/r/innodb_page_hash_mutexes_basic.result'
--- a/mysql-test/suite/sys_vars/r/innodb_page_hash_mutexes_basic.result	1970-01-01 00:00:00 +0000
+++ b/mysql-test/suite/sys_vars/r/innodb_page_hash_mutexes_basic.result	revid:inaam.rana@stripped
@@ -0,0 +1,21 @@
+select @@global.innodb_page_hash_mutexes;
+@@global.innodb_page_hash_mutexes
+256
+select @@session.innodb_page_hash_mutexes;
+ERROR HY000: Variable 'innodb_page_hash_mutexes' is a GLOBAL variable
+show global variables like 'innodb_page_hash_mutexes';
+Variable_name	Value
+innodb_page_hash_mutexes	256
+show session variables like 'innodb_page_hash_mutexes';
+Variable_name	Value
+innodb_page_hash_mutexes	256
+select * from information_schema.global_variables where variable_name='innodb_page_hash_mutexes';
+VARIABLE_NAME	VARIABLE_VALUE
+INNODB_PAGE_HASH_MUTEXES	256
+select * from information_schema.session_variables where variable_name='innodb_page_hash_mutexes';
+VARIABLE_NAME	VARIABLE_VALUE
+INNODB_PAGE_HASH_MUTEXES	256
+set global innodb_page_hash_mutexes=1;
+ERROR HY000: Variable 'innodb_page_hash_mutexes' is a read only variable
+set session innodb_page_hash_mutexes=1;
+ERROR HY000: Variable 'innodb_page_hash_mutexes' is a read only variable

=== added file 'mysql-test/suite/sys_vars/t/innodb_page_hash_mutexes_basic.test'
--- a/mysql-test/suite/sys_vars/t/innodb_page_hash_mutexes_basic.test	1970-01-01 00:00:00 +0000
+++ b/mysql-test/suite/sys_vars/t/innodb_page_hash_mutexes_basic.test	revid:inaam.rana@stripped
@@ -0,0 +1,20 @@
+--source include/have_innodb.inc
+
+#
+# show the global and session values;
+#
+select @@global.innodb_page_hash_mutexes;
+--error ER_INCORRECT_GLOBAL_LOCAL_VAR
+select @@session.innodb_page_hash_mutexes;
+show global variables like 'innodb_page_hash_mutexes';
+show session variables like 'innodb_page_hash_mutexes';
+select * from information_schema.global_variables where variable_name='innodb_page_hash_mutexes';
+select * from information_schema.session_variables where variable_name='innodb_page_hash_mutexes';
+
+#
+# show that it's read-only
+#
+--error ER_INCORRECT_GLOBAL_LOCAL_VAR
+set global innodb_page_hash_mutexes=1;
+--error ER_INCORRECT_GLOBAL_LOCAL_VAR
+set session innodb_page_hash_mutexes=1;


Attachment: [text/bzr-bundle] bzr/[e-mail]