← 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/r/transaction_alloc_block_size_basic.result

  • 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/r/transaction_alloc_block_size_basic.result
70
70
Warning 1292    Truncated incorrect transaction_alloc_block_size value: '135217728'
71
71
SELECT @@global.transaction_alloc_block_size;
72
72
@@global.transaction_alloc_block_size
73
 
134217728
 
73
131072
74
74
SET @@global.transaction_alloc_block_size = ON;
75
75
ERROR 42000: Incorrect argument type to variable 'transaction_alloc_block_size'
76
76
SET @@global.transaction_alloc_block_size = OFF;
102
102
Warning 1292    Truncated incorrect transaction_alloc_block_size value: '135217728'
103
103
SELECT @@session.transaction_alloc_block_size;
104
104
@@session.transaction_alloc_block_size
105
 
134217728
 
105
131072
106
106
SET @@session.transaction_alloc_block_size = ON;
107
107
ERROR 42000: Incorrect argument type to variable 'transaction_alloc_block_size'
108
108
SET @@session.transaction_alloc_block_size = OFF;
124
124
SET @@session.transaction_alloc_block_size = 'test';
125
125
ERROR 42000: Incorrect argument type to variable 'transaction_alloc_block_size'
126
126
'#------------------FN_DYNVARS_005_06-----------------------#'
127
 
SELECT @@global.transaction_alloc_block_size = VARIABLE_VALUE 
128
 
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 
 
127
SELECT @@global.transaction_alloc_block_size = VARIABLE_VALUE
 
128
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
129
129
WHERE VARIABLE_NAME='transaction_alloc_block_size';
130
130
@@global.transaction_alloc_block_size = VARIABLE_VALUE
131
131
1
132
132
'#------------------FN_DYNVARS_005_07-----------------------#'
133
 
SELECT @@session.transaction_alloc_block_size = VARIABLE_VALUE 
134
 
FROM INFORMATION_SCHEMA.SESSION_VARIABLES 
 
133
SELECT @@session.transaction_alloc_block_size = VARIABLE_VALUE
 
134
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
135
135
WHERE VARIABLE_NAME='transaction_alloc_block_size';
136
136
@@session.transaction_alloc_block_size = VARIABLE_VALUE
137
137
1
138
138
'#---------------------FN_DYNVARS_001_08----------------------#'
139
139
SET @@transaction_alloc_block_size = 1024;
140
140
SET @@global.transaction_alloc_block_size = 134217728;
 
141
Warnings:
 
142
Warning 1292    Truncated incorrect transaction_alloc_block_size value: '134217728'
141
143
SELECT @@transaction_alloc_block_size = @@global.transaction_alloc_block_size;
142
144
@@transaction_alloc_block_size = @@global.transaction_alloc_block_size
143
145
0