← Back to branch summary

~ubuntu-branches/ubuntu/wily/mysql-5.6/wily

« back to all changes in this revision

Viewing changes to mysql-test/suite/sys_vars/t/transaction_alloc_block_size_basic.test

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2015-07-21 07:09:29 UTC
  • mto: This revision was merged to the branch mainline in revision 14.
  • Revision ID: package-import@ubuntu.com-20150721070929-mg4dpqkgg3it1ajf
Tags: upstream-5.6.25
Import upstream version 5.6.25

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/sys_vars/t/transaction_alloc_block_size_basic.test
5
5
# Access Type: Dynamic                                                        #
6
6
# Data Type: numeric                                                          #
7
7
# Default Value: 8192                                                         #
8
 
# Range: 1024-134217728                                                       #
 
8
# Range: 1024-131072                                                          #
9
9
#                                                                             #
10
10
#                                                                             #
11
11
# Creation Date: 2008-02-14                                                   #
84
84
###################################################################
85
85
# Change the value of variable to a valid value for SESSION Scope #
86
86
###################################################################
87
 
 
 
87
 
88
88
SET @@session.transaction_alloc_block_size = 1024;
89
89
SELECT @@session.transaction_alloc_block_size;
90
90
 
159
159
####################################################################
160
160
 
161
161
 
162
 
SELECT @@global.transaction_alloc_block_size = VARIABLE_VALUE 
163
 
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 
 
162
SELECT @@global.transaction_alloc_block_size = VARIABLE_VALUE
 
163
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
164
164
WHERE VARIABLE_NAME='transaction_alloc_block_size';
165
165
 
166
166
--echo '#------------------FN_DYNVARS_005_07-----------------------#'
168
168
#  Check if the value in SESSION Table matches value in variable   #
169
169
####################################################################
170
170
 
171
 
SELECT @@session.transaction_alloc_block_size = VARIABLE_VALUE 
172
 
FROM INFORMATION_SCHEMA.SESSION_VARIABLES 
 
171
SELECT @@session.transaction_alloc_block_size = VARIABLE_VALUE
 
172
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
173
173
WHERE VARIABLE_NAME='transaction_alloc_block_size';
174
174
 
175
175
 
181
181
SET @@transaction_alloc_block_size = 1024;
182
182
SET @@global.transaction_alloc_block_size = 134217728;
183
183
SELECT @@transaction_alloc_block_size = @@global.transaction_alloc_block_size;
184
 
 
 
184
 
185
185
 
186
186
--echo '#---------------------FN_DYNVARS_001_09----------------------#'
187
187
########################################################################