diff options
Diffstat (limited to 'mysql-test/t/innodb_table_locks_func.test')
| -rw-r--r-- | mysql-test/t/innodb_table_locks_func.test | 12 |
1 files changed, 9 insertions, 3 deletions
diff --git a/mysql-test/t/innodb_table_locks_func.test b/mysql-test/t/innodb_table_locks_func.test index d233a2a5240..6638a20c926 100644 --- a/mysql-test/t/innodb_table_locks_func.test +++ b/mysql-test/t/innodb_table_locks_func.test @@ -14,8 +14,8 @@ # Description: Test Cases of Dynamic System Variable innodb_table_locks # # that checks the behavior of this variable # # # -# Reference: http://dev.mysql.com/doc/refman/5.1/en/ # -# server-system-variables.html # +# Reference: # +# http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html # # # ############################################################################### @@ -24,9 +24,12 @@ --echo '#--------------------FN_DYNVARS_048_01-------------------------#' #################################################################### -# Check if setting innodb_table_locks is changed in new connection # +# Check if setting innodb_table_locks is changed in new connection # #################################################################### +SET @start_value= @@global.innodb_table_locks; +SELECT @start_value; + SET @@global.innodb_table_locks = OFF; --echo 'connect (con1,localhost,root,,,,)' connect (con1,localhost,root,,,,); @@ -80,6 +83,9 @@ UNLOCK tables; DROP TABLE t1; disconnect con2; +connection default; +SET @@global.innodb_table_locks= @start_value; +SELECT @@global.innodb_table_locks; ########################################################## # End of functionality Testing for innodb_table_locks # |