← Back to branch summary

~jlukas79/+junk/mysql-server

« back to all changes in this revision

Viewing changes to mysql-test/t/innodb_table_locks_func.test

manual merge 6.0-main --> 6.0-bka-review

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/t/innodb_table_locks_func.test
 
1
################# mysql-test\t\innodb_table_locks_func.test  ##################
 
2
#                                                                             #
 
3
# Variable Name: innodb_table_locks                                           #
 
4
# Scope: GLOBAL | SESSION                                                     #
 
5
# Access Type: Dynamic                                                        #
 
6
# Data Type: boolean                                                          #
 
7
# Default Value: 1                                                            #
 
8
# Range: 0,1                                                                  #
 
9
#                                                                             #
 
10
#                                                                             #
 
11
# Creation Date: 2008-03-08                                                   #
 
12
# Author:  Rizwan                                                             #
 
13
#                                                                             #
 
14
# Description: Test Cases of Dynamic System Variable innodb_table_locks       #
 
15
#              that checks the behavior of this variable                      #
 
16
#                                                                             #
 
17
# Reference: http://dev.mysql.com/doc/refman/5.1/en/                          #
 
18
#  server-system-variables.html                                               #
 
19
#                                                                             #
 
20
###############################################################################
 
21
 
 
22
--source include/not_embedded.inc
 
23
--source include/have_innodb.inc
 
24
 
 
25
--echo '#--------------------FN_DYNVARS_048_01-------------------------#'
 
26
####################################################################
 
27
# Check if setting innodb_table_locks is changed in new connection # 
 
28
####################################################################
 
29
 
 
30
SET @@global.innodb_table_locks = OFF;
 
31
--echo 'connect (con1,localhost,root,,,,)'
 
32
connect (con1,localhost,root,,,,);
 
33
--echo 'connection con1'
 
34
connection con1;
 
35
SELECT @@global.innodb_table_locks;
 
36
SELECT @@session.innodb_table_locks;
 
37
disconnect con1;
 
38
 
 
39
 
 
40
--echo '#--------------------FN_DYNVARS_048_02-------------------------#'
 
41
###########################################################
 
42
# Begin the functionality Testing of innodb_table_locks   #
 
43
###########################################################
 
44
 
 
45
#==============================================================================
 
46
--echo '----check when innodb_table_locks = ON and autocommit = OFF---'
 
47
#==============================================================================
 
48
--echo 'connect (con2,localhost,root,,,,)'
 
49
connect (con2,localhost,root,,,,);
 
50
 
 
51
--echo 'connection default'
 
52
connection default;
 
53
 
 
54
--disable_warnings
 
55
DROP TABLE IF EXISTS t1;
 
56
--enable_warnings
 
57
CREATE TABLE t1 (a INT) ENGINE=INNODB;
 
58
 
 
59
SET @@autocommit = OFF;
 
60
SET @@innodb_table_locks = ON;
 
61
 
 
62
BEGIN;
 
63
INSERT INTO t1 VALUES(1);
 
64
SELECT * FROM t1 FOR UPDATE;
 
65
 
 
66
--echo 'CONNECTION con2'
 
67
CONNECTION con2;
 
68
SET @@innodb_table_locks = ON;
 
69
SET @@autocommit = OFF;
 
70
send LOCK TABLES t1 WRITE;
 
71
 
 
72
--echo 'CONNECTION default'
 
73
CONNECTION default;
 
74
COMMIT;
 
75
 
 
76
--echo 'CONNECTION con2'
 
77
CONNECTION con2;
 
78
UNLOCK tables;
 
79
 
 
80
DROP TABLE t1;
 
81
disconnect con2;
 
82
 
 
83
 
 
84
##########################################################
 
85
# End of functionality Testing for innodb_table_locks    #
 
86
##########################################################
 
87
 
 
88