MySQL Lists are EOL. Please join:

List:Commits« Previous MessageNext Message »
From:Igor Babaev Date:July 23 2008 5:34am
Subject:bzr commit into mysql-6.0-bka-preview branch (igor:2642)
View as plain text  
#At file:///home/igor/dev-bzr/mysql-6.0-bka-preview-merge-64/

 2642 Igor Babaev	2008-07-22
      Adjust test results after merge.
modified:
  mysql-test/r/join_buffer_size_basic_64.result

per-file messages:
  mysql-test/r/join_buffer_size_basic_64.result
    Adjust test results after merge.
=== modified file 'mysql-test/r/join_buffer_size_basic_64.result'
--- a/mysql-test/r/join_buffer_size_basic_64.result	2008-05-08 18:13:39 +0000
+++ b/mysql-test/r/join_buffer_size_basic_64.result	2008-07-23 05:33:59 +0000
@@ -7,16 +7,16 @@ SELECT @start_session_value;
 @start_session_value
 131072
 '#--------------------FN_DYNVARS_053_01-------------------------#'
-SET @@global.join_buffer_size = 8200;
+SET @@global.join_buffer_size = 136;
 Warnings:
-Warning	1292	Truncated incorrect join_buffer_size value: '8200'
+Warning	1292	Truncated incorrect join_buffer_size value: '136'
 SET @@global.join_buffer_size = DEFAULT;
 SELECT @@global.join_buffer_size;
 @@global.join_buffer_size
 131072
-SET @@session.join_buffer_size = 8200;
+SET @@session.join_buffer_size = 136;
 Warnings:
-Warning	1292	Truncated incorrect join_buffer_size value: '8200'
+Warning	1292	Truncated incorrect join_buffer_size value: '136'
 SET @@session.join_buffer_size = DEFAULT;
 SELECT @@session.join_buffer_size;
 @@session.join_buffer_size
@@ -31,11 +31,11 @@ SELECT @@session.join_buffer_size = 1310
 @@session.join_buffer_size = 131072
 1
 '#--------------------FN_DYNVARS_053_03-------------------------#'
-SET @@global.join_buffer_size = 8200;
+SET @@global.join_buffer_size = 136;
 Warnings:
-Warning	1292	Truncated incorrect join_buffer_size value: '8200'
-SELECT @@global.join_buffer_size=8200 OR @@global.join_buffer_size= 8228;
-@@global.join_buffer_size=8200 OR @@global.join_buffer_size= 8228
+Warning	1292	Truncated incorrect join_buffer_size value: '136'
+SELECT @@global.join_buffer_size=136 OR @@global.join_buffer_size= 164;
+@@global.join_buffer_size=136 OR @@global.join_buffer_size= 164
 1
 SET @@global.join_buffer_size = 65536;
 SELECT @@global.join_buffer_size;
@@ -44,14 +44,14 @@ SELECT @@global.join_buffer_size;
 SET @@global.join_buffer_size = 4294967295;
 SELECT @@global.join_buffer_size;
 @@global.join_buffer_size
-4294963200
+4294967168
 'Bug # 34837: Errors are not coming on assigning invalid values to variable'
 '#--------------------FN_DYNVARS_053_04-------------------------#'
-SET @@session.join_buffer_size = 8200;
+SET @@session.join_buffer_size = 136;
 Warnings:
-Warning	1292	Truncated incorrect join_buffer_size value: '8200'
-SELECT @@session.join_buffer_size=8200 OR @@session.join_buffer_size= 8228;
-@@session.join_buffer_size=8200 OR @@session.join_buffer_size= 8228
+Warning	1292	Truncated incorrect join_buffer_size value: '136'
+SELECT @@session.join_buffer_size=136 OR @@session.join_buffer_size= 164;
+@@session.join_buffer_size=136 OR @@session.join_buffer_size= 164
 1
 SET @@session.join_buffer_size = 65536;
 SELECT @@session.join_buffer_size;
@@ -60,74 +60,74 @@ SELECT @@session.join_buffer_size;
 SET @@session.join_buffer_size = 4294967295;
 SELECT @@session.join_buffer_size;
 @@session.join_buffer_size
-4294963200
+4294967168
 'Bug # 34837: Errors are not coming on assigning invalid values to variable'
 '#------------------FN_DYNVARS_053_05-----------------------#'
 SET @@global.join_buffer_size = 0;
 Warnings:
 Warning	1292	Truncated incorrect join_buffer_size value: '0'
-SELECT @@global.join_buffer_size=8200 OR @@global.join_buffer_size= 8228;
-@@global.join_buffer_size=8200 OR @@global.join_buffer_size= 8228
+SELECT @@global.join_buffer_size=136 OR @@global.join_buffer_size= 164;
+@@global.join_buffer_size=136 OR @@global.join_buffer_size= 164
 1
 SET @@global.join_buffer_size = -1024;
 Warnings:
 Warning	1292	Truncated incorrect join_buffer_size value: '0'
-SELECT @@global.join_buffer_size=8200 OR @@global.join_buffer_size= 8228;
-@@global.join_buffer_size=8200 OR @@global.join_buffer_size= 8228
+SELECT @@global.join_buffer_size=136 OR @@global.join_buffer_size= 164;
+@@global.join_buffer_size=136 OR @@global.join_buffer_size= 164
 1
-SET @@global.join_buffer_size = 8199;
+SET @@global.join_buffer_size = 135;
 Warnings:
-Warning	1292	Truncated incorrect join_buffer_size value: '8199'
-SELECT @@global.join_buffer_size=8200 OR @@global.join_buffer_size= 8228;
-@@global.join_buffer_size=8200 OR @@global.join_buffer_size= 8228
+Warning	1292	Truncated incorrect join_buffer_size value: '135'
+SELECT @@global.join_buffer_size=136 OR @@global.join_buffer_size= 164;
+@@global.join_buffer_size=136 OR @@global.join_buffer_size= 164
 1
 SET @@global.join_buffer_size = 42949672951;
 SELECT @@global.join_buffer_size;
 @@global.join_buffer_size
-42949668864
+42949672832
 SET @@global.join_buffer_size = 65530.34.;
 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.' at line 1
 SELECT @@global.join_buffer_size;
 @@global.join_buffer_size
-42949668864
+42949672832
 SET @@global.join_buffer_size = test;
 ERROR 42000: Incorrect argument type to variable 'join_buffer_size'
 SELECT @@global.join_buffer_size;
 @@global.join_buffer_size
-42949668864
+42949672832
 SET @@session.join_buffer_size = 0;
 Warnings:
 Warning	1292	Truncated incorrect join_buffer_size value: '0'
-SELECT @@session.join_buffer_size=8200 OR @@session.join_buffer_size= 8228;
-@@session.join_buffer_size=8200 OR @@session.join_buffer_size= 8228
+SELECT @@session.join_buffer_size=136 OR @@session.join_buffer_size= 164;
+@@session.join_buffer_size=136 OR @@session.join_buffer_size= 164
 1
 SET @@session.join_buffer_size = -2;
 Warnings:
 Warning	1292	Truncated incorrect join_buffer_size value: '0'
-SELECT @@session.join_buffer_size=8200 OR @@session.join_buffer_size= 8228;
-@@session.join_buffer_size=8200 OR @@session.join_buffer_size= 8228
+SELECT @@session.join_buffer_size=136 OR @@session.join_buffer_size= 164;
+@@session.join_buffer_size=136 OR @@session.join_buffer_size= 164
 1
-SET @@session.join_buffer_size = 8199;
+SET @@session.join_buffer_size = 135;
 Warnings:
-Warning	1292	Truncated incorrect join_buffer_size value: '8199'
-SELECT @@session.join_buffer_size=8200 OR @@session.join_buffer_size= 8228;
-@@session.join_buffer_size=8200 OR @@session.join_buffer_size= 8228
+Warning	1292	Truncated incorrect join_buffer_size value: '135'
+SELECT @@session.join_buffer_size=136 OR @@session.join_buffer_size= 164;
+@@session.join_buffer_size=136 OR @@session.join_buffer_size= 164
 1
 SET @@session.join_buffer_size = 42949672951;
 SELECT @@session.join_buffer_size;
 @@session.join_buffer_size
-42949668864
+42949672832
 SET @@session.join_buffer_size = 65530.34.;
 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.' at line 1
 SELECT @@session.join_buffer_size;
 @@session.join_buffer_size
-42949668864
+42949672832
 'Bug # 34837: Errors are not coming on assigning invalid values to variable'
 SET @@session.join_buffer_size = test;
 ERROR 42000: Incorrect argument type to variable 'join_buffer_size'
 SELECT @@session.join_buffer_size;
 @@session.join_buffer_size
-42949668864
+42949672832
 '#------------------FN_DYNVARS_053_06-----------------------#'
 SELECT @@global.join_buffer_size = VARIABLE_VALUE 
 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 
@@ -144,14 +144,14 @@ WHERE VARIABLE_NAME='join_buffer_size';
 SET @@global.join_buffer_size = TRUE;
 Warnings:
 Warning	1292	Truncated incorrect join_buffer_size value: '1'
-SELECT @@global.join_buffer_size=8200 OR @@global.join_buffer_size= 8228;
-@@global.join_buffer_size=8200 OR @@global.join_buffer_size= 8228
+SELECT @@global.join_buffer_size=136 OR @@global.join_buffer_size= 164;
+@@global.join_buffer_size=136 OR @@global.join_buffer_size= 164
 1
 SET @@global.join_buffer_size = FALSE;
 Warnings:
 Warning	1292	Truncated incorrect join_buffer_size value: '0'
-SELECT @@global.join_buffer_size=8200 OR @@global.join_buffer_size= 8228;
-@@global.join_buffer_size=8200 OR @@global.join_buffer_size= 8228
+SELECT @@global.join_buffer_size=136 OR @@global.join_buffer_size= 164;
+@@global.join_buffer_size=136 OR @@global.join_buffer_size= 164
 1
 'Bug: Errors are not coming on assigning TRUE/FALSE to variable';
 '#---------------------FN_DYNVARS_001_09----------------------#'
@@ -175,8 +175,8 @@ SELECT @@local.join_buffer_size = @@sess
 SET join_buffer_size = 1;
 Warnings:
 Warning	1292	Truncated incorrect join_buffer_size value: '1'
-SELECT @@join_buffer_size=8200 OR @@join_buffer_size= 8228;
-@@join_buffer_size=8200 OR @@join_buffer_size= 8228
+SELECT @@join_buffer_size=136 OR @@join_buffer_size= 164;
+@@join_buffer_size=136 OR @@join_buffer_size= 164
 1
 SELECT local.join_buffer_size;
 ERROR 42S02: Unknown table 'local' in field list

Thread
bzr commit into mysql-6.0-bka-preview branch (igor:2642) Igor Babaev23 Jul