From: Date: April 8 2008 2:51pm Subject: bk commit into 6.0 tree (hhunger:1.2627) List-Archive: http://lists.mysql.com/commits/45055 Message-Id: <20080408125152.2AA2935449@hh-nb.hungers> Below is the list of changes that have just been committed into a local 6.0 repository of hhunger. When hhunger does a push these changes will be propagated to the main repository and, within 24 hours after the push, to the public repository. For information on how to access the public repository see http://dev.mysql.com/doc/mysql/en/installing-source-tree.html ChangeSet@stripped, 2008-04-08 14:51:44+02:00, hhunger@stripped +14 -0 post merge for WL4388. BitKeeper/deleted/.del-log_bin_trust_routine_creators_basic.result@stripped, 2008-04-08 13:49:54+02:00, hhunger@stripped +0 -0 Delete: mysql-test/r/log_bin_trust_routine_creators_basic.result BitKeeper/deleted/.del-log_bin_trust_routine_creators_basic.test@stripped, 2008-04-08 13:49:32+02:00, hhunger@stripped +0 -0 Delete: mysql-test/t/log_bin_trust_routine_creators_basic.test BitKeeper/etc/ignore@stripped, 2008-04-08 14:51:42+02:00, hhunger@stripped +2 -0 Added libmysqld/si_objects.cc mysql-test/regps.log to the ignore list mysql-test/r/character_set_client_basic.result@stripped, 2008-04-08 14:51:40+02:00, hhunger@stripped +1 -1 post merge for WL4388. mysql-test/r/character_set_connection_basic.result@stripped, 2008-04-08 14:51:41+02:00, hhunger@stripped +1 -1 post merge for WL4388. mysql-test/r/character_set_database_basic.result@stripped, 2008-04-08 14:51:41+02:00, hhunger@stripped +1 -1 post merge for WL4388. mysql-test/r/character_set_filesystem_basic.result@stripped, 2008-04-08 14:51:41+02:00, hhunger@stripped +1 -1 post merge for WL4388. mysql-test/r/character_set_results_basic.result@stripped, 2008-04-08 14:51:41+02:00, hhunger@stripped +2 -2 post merge for WL4388. mysql-test/r/character_set_server_basic.result@stripped, 2008-04-08 14:51:41+02:00, hhunger@stripped +1 -1 post merge for WL4388. mysql-test/r/ft_boolean_syntax_func.result@stripped, 2008-04-08 14:51:41+02:00, hhunger@stripped +2 -2 post merge for WL4388. mysql-test/r/myisam_stats_method_func.result@stripped, 2008-04-08 14:51:41+02:00, hhunger@stripped +18 -18 post merge for WL4388. mysql-test/r/read_rnd_buffer_size_basic.result@stripped, 2008-04-08 14:51:41+02:00, hhunger@stripped +16 -38 post merge for WL4388. mysql-test/r/slave_allow_batching_basic.result@stripped, 2008-04-08 14:51:41+02:00, hhunger@stripped +87 -1 post merge for WL4388. mysql-test/t/slave_allow_batching_basic.test@stripped, 2008-04-08 14:51:41+02:00, hhunger@stripped +60 -61 post merge for WL4388. diff -Nrup a/BitKeeper/etc/ignore b/BitKeeper/etc/ignore --- a/BitKeeper/etc/ignore 2008-04-07 17:45:56 +02:00 +++ b/BitKeeper/etc/ignore 2008-04-08 14:51:42 +02:00 @@ -3040,3 +3040,5 @@ win/vs8cache.txt ylwrap zlib/*.ds? zlib/*.vcproj +libmysqld/si_objects.cc +mysql-test/regps.log diff -Nrup a/mysql-test/r/character_set_client_basic.result b/mysql-test/r/character_set_client_basic.result --- a/mysql-test/r/character_set_client_basic.result 2008-04-07 15:14:04 +02:00 +++ b/mysql-test/r/character_set_client_basic.result 2008-04-08 14:51:40 +02:00 @@ -425,7 +425,7 @@ ERROR 42000: Unknown character set: '100 SET @total_charset = (SELECT count(*) FROM INFORMATION_SCHEMA.CHARACTER_SETS); SELECT @total_charset; @total_charset -36 +39 'Bug # 34843: character sets are mapped in such a way that 100 and following'; 'numbers gives error, and before 100 the 36 mapped wraps arround'; 'several times.'; diff -Nrup a/mysql-test/r/character_set_connection_basic.result b/mysql-test/r/character_set_connection_basic.result --- a/mysql-test/r/character_set_connection_basic.result 2008-04-07 15:14:04 +02:00 +++ b/mysql-test/r/character_set_connection_basic.result 2008-04-08 14:51:41 +02:00 @@ -424,7 +424,7 @@ ERROR 42000: Unknown character set: '100 SET @total_charset = (SELECT count(*) FROM INFORMATION_SCHEMA.CHARACTER_SETS); SELECT @total_charset; @total_charset -36 +39 'Bug # 34843: character sets are mapped in such a way that 100 and following '; 'numbers gives error, and before 100 the 36 mapped wraps arround'; 'several times.'; diff -Nrup a/mysql-test/r/character_set_database_basic.result b/mysql-test/r/character_set_database_basic.result --- a/mysql-test/r/character_set_database_basic.result 2008-04-07 15:14:05 +02:00 +++ b/mysql-test/r/character_set_database_basic.result 2008-04-08 14:51:41 +02:00 @@ -424,7 +424,7 @@ ERROR 42000: Unknown character set: '100 SET @total_charset = (SELECT count(*) FROM INFORMATION_SCHEMA.CHARACTER_SETS); SELECT @total_charset; @total_charset -36 +39 'Bug # 34843: character sets are mapped in such a way that 100 and following'; 'numbers gives error, and before 100 the 36 mapped wraps arround several times.'; '#--------------------FN_DYNVARS_012_10-------------------------#' diff -Nrup a/mysql-test/r/character_set_filesystem_basic.result b/mysql-test/r/character_set_filesystem_basic.result --- a/mysql-test/r/character_set_filesystem_basic.result 2008-04-07 15:14:05 +02:00 +++ b/mysql-test/r/character_set_filesystem_basic.result 2008-04-08 14:51:41 +02:00 @@ -402,7 +402,7 @@ ERROR 42000: Unknown character set: '100 SET @total_charset = (SELECT count(*) FROM INFORMATION_SCHEMA.CHARACTER_SETS); SELECT @total_charset; @total_charset -36 +39 'Bug # 34843: character sets are mapped in such a way that 100 and following ' 'numbers give error, and before 100 the 36 mapped wraps arround several times.' '#--------------------FN_DYNVARS_008_10-------------------------#' diff -Nrup a/mysql-test/r/character_set_results_basic.result b/mysql-test/r/character_set_results_basic.result --- a/mysql-test/r/character_set_results_basic.result 2008-04-07 15:14:05 +02:00 +++ b/mysql-test/r/character_set_results_basic.result 2008-04-08 14:51:41 +02:00 @@ -156,7 +156,7 @@ SELECT @@session.character_set_results; latin5 SET @@session.character_set_results = armscii8; SELECT @@session.character_set_results; -@@session©character_set_results +@@session.character_set_results armscii8 SET @@session.character_set_results = utf8; SELECT @@session.character_set_results; @@ -424,7 +424,7 @@ ERROR 42000: Unknown character set: '100 SET @total_charset = (SELECT count(*) FROM INFORMATION_SCHEMA.CHARACTER_SETS); SELECT @total_charset; @total_charset -36 +39 'Bug # 34843: character sets are mapped in such a way that 100 and following'; 'numbers gives error, and before 100 the 36 mapped wraps arround several times.'; '#--------------------FN_DYNVARS_013_10-------------------------#' diff -Nrup a/mysql-test/r/character_set_server_basic.result b/mysql-test/r/character_set_server_basic.result --- a/mysql-test/r/character_set_server_basic.result 2008-04-07 15:14:05 +02:00 +++ b/mysql-test/r/character_set_server_basic.result 2008-04-08 14:51:41 +02:00 @@ -420,7 +420,7 @@ ERROR 42000: Unknown character set: '100 SET @total_charset = (SELECT count(*) FROM INFORMATION_SCHEMA.CHARACTER_SETS); SELECT @total_charset; @total_charset -36 +39 'Bug # 34843: character sets are mapped in such a way that 100 and following '; 'numbers gives error, and before 100 the 36 mapped wraps arround '; 'several times.'; diff -Nrup a/mysql-test/r/ft_boolean_syntax_func.result b/mysql-test/r/ft_boolean_syntax_func.result --- a/mysql-test/r/ft_boolean_syntax_func.result 2008-04-07 15:14:09 +02:00 +++ b/mysql-test/r/ft_boolean_syntax_func.result 2008-04-08 14:51:41 +02:00 @@ -70,7 +70,7 @@ FROM articles WHERE MATCH (title,body) AGAINST ('+security configuring' IN BOOLEAN MODE); id title body relevance 8 MySQL Security When configured properly, MySQL ... 1 -9 Database Security Configuring MySQL for ... 1.3333333730698 +9 Database Security Configuring MySQL for ... 1.3333333730697632 SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('"faster than"' IN BOOLEAN MODE); id title body @@ -91,7 +91,7 @@ AGAINST ('+MySQL +(>show <()~*:""&|'--' SET @@global.ft_boolean_syntax='~ /!@#$%^&*()-'; SELECT * FROM articles WHERE MATCH (title,body) diff -Nrup a/mysql-test/r/log_bin_trust_routine_creators_basic.result b/mysql-test/r/log_bin_trust_routine_creators_basic.result --- a/mysql-test/r/log_bin_trust_routine_creators_basic.result 2008-04-07 15:14:16 +02:00 +++ /dev/null Wed Dec 31 16:00:00 196900 @@ -1,121 +0,0 @@ -SET @start_global_value = @@global.log_bin_trust_routine_creators; -SELECT @start_global_value; -@start_global_value -1 -'#--------------------FN_DYNVARS_064_01-------------------------#' -SET @@global.log_bin_trust_routine_creators = TRUE; -Warnings: -Warning 1287 The syntax 'log_bin_trust_routine_creators' is deprecated and will be removed in MySQL 5.2. Please use 'log_bin_trust_function_creators' instead -SET @@global.log_bin_trust_routine_creators = DEFAULT; -Warnings: -Warning 1287 The syntax 'log_bin_trust_routine_creators' is deprecated and will be removed in MySQL 5.2. Please use 'log_bin_trust_function_creators' instead -SELECT @@global.log_bin_trust_routine_creators; -@@global.log_bin_trust_routine_creators -0 -'#--------------------FN_DYNVARS_064_02-------------------------#' -SET @@global.log_bin_trust_routine_creators = DEFAULT; -Warnings: -Warning 1287 The syntax 'log_bin_trust_routine_creators' is deprecated and will be removed in MySQL 5.2. Please use 'log_bin_trust_function_creators' instead -SELECT @@global.log_bin_trust_routine_creators = 'FALSE'; -@@global.log_bin_trust_routine_creators = 'FALSE' -1 -Warnings: -Warning 1292 Truncated incorrect DOUBLE value: 'FALSE' -'#--------------------FN_DYNVARS_064_03-------------------------#' -SET @@global.log_bin_trust_routine_creators = ON; -Warnings: -Warning 1287 The syntax 'log_bin_trust_routine_creators' is deprecated and will be removed in MySQL 5.2. Please use 'log_bin_trust_function_creators' instead -SELECT @@global.log_bin_trust_routine_creators; -@@global.log_bin_trust_routine_creators -1 -SET @@global.log_bin_trust_routine_creators = OFF; -Warnings: -Warning 1287 The syntax 'log_bin_trust_routine_creators' is deprecated and will be removed in MySQL 5.2. Please use 'log_bin_trust_function_creators' instead -SELECT @@global.log_bin_trust_routine_creators; -@@global.log_bin_trust_routine_creators -0 -SET @@global.log_bin_trust_routine_creators = 0; -Warnings: -Warning 1287 The syntax 'log_bin_trust_routine_creators' is deprecated and will be removed in MySQL 5.2. Please use 'log_bin_trust_function_creators' instead -SELECT @@global.log_bin_trust_routine_creators; -@@global.log_bin_trust_routine_creators -0 -SET @@global.log_bin_trust_routine_creators = 1; -Warnings: -Warning 1287 The syntax 'log_bin_trust_routine_creators' is deprecated and will be removed in MySQL 5.2. Please use 'log_bin_trust_function_creators' instead -SELECT @@global.log_bin_trust_routine_creators; -@@global.log_bin_trust_routine_creators -1 -SET @@global.log_bin_trust_routine_creators = TRUE; -Warnings: -Warning 1287 The syntax 'log_bin_trust_routine_creators' is deprecated and will be removed in MySQL 5.2. Please use 'log_bin_trust_function_creators' instead -SELECT @@global.log_bin_trust_routine_creators; -@@global.log_bin_trust_routine_creators -1 -SET @@global.log_bin_trust_routine_creators = FALSE; -Warnings: -Warning 1287 The syntax 'log_bin_trust_routine_creators' is deprecated and will be removed in MySQL 5.2. Please use 'log_bin_trust_function_creators' instead -SELECT @@global.log_bin_trust_routine_creators; -@@global.log_bin_trust_routine_creators -0 -'#-------------------FN_DYNVARS_064_04----------------------------#' -SET @@session.log_bin_trust_routine_creators = 0; -ERROR HY000: Variable 'log_bin_trust_routine_creators' is a GLOBAL variable and should be set with SET GLOBAL -SELECT @@session.log_bin_trust_routine_creators; -ERROR HY000: Variable 'log_bin_trust_routine_creators' is a GLOBAL variable -'#------------------FN_DYNVARS_064_05-----------------------#' -SET @@global.log_bin_trust_routine_creators = 'ONN'; -ERROR 42000: Variable 'log_bin_trust_routine_creators' can't be set to the value of 'ONN' -SET @@global.log_bin_trust_routine_creators = "OFFF"; -ERROR 42000: Variable 'log_bin_trust_routine_creators' can't be set to the value of 'OFFF' -SET @@global.log_bin_trust_routine_creators = OF; -Warnings: -Warning 1287 The syntax 'log_bin_trust_routine_creators' is deprecated and will be removed in MySQL 5.2. Please use 'log_bin_trust_function_creators' instead -SELECT @@global.log_bin_trust_routine_creators; -@@global.log_bin_trust_routine_creators -0 -'Bug# 34828: OF is also working as OFF and no error is coming'; -SET @@global.log_bin_trust_routine_creators = TTRUE; -ERROR 42000: Variable 'log_bin_trust_routine_creators' can't be set to the value of 'TTRUE' -SET @@global.log_bin_trust_routine_creators = FELSE; -ERROR 42000: Variable 'log_bin_trust_routine_creators' can't be set to the value of 'FELSE' -SET @@global.log_bin_trust_routine_creators = -1024; -ERROR 42000: Variable 'log_bin_trust_routine_creators' can't be set to the value of '-1024' -SET @@global.log_bin_trust_routine_creators = 65536; -ERROR 42000: Variable 'log_bin_trust_routine_creators' can't be set to the value of '65536' -SET @@global.log_bin_trust_routine_creators = 65530.34; -ERROR 42000: Variable 'log_bin_trust_routine_creators' can't be set to the value of '65530' -SET @@global.log_bin_trust_routine_creators = test; -ERROR 42000: Variable 'log_bin_trust_routine_creators' can't be set to the value of 'test' -'#------------------FN_DYNVARS_064_06-----------------------#' -SELECT @@global.log_bin_trust_routine_creators = VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='log_bin_trust_routine_creators'; -@@global.log_bin_trust_routine_creators = VARIABLE_VALUE -1 -SELECT @@session.log_bin_trust_routine_creators = VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES WHERE VARIABLE_NAME='log_bin_trust_routine_creators'; -ERROR HY000: Variable 'log_bin_trust_routine_creators' is a GLOBAL variable -'#---------------------FN_DYNVARS_064_07----------------------#' -SET @@global.log_bin_trust_routine_creators = TRUE; -Warnings: -Warning 1287 The syntax 'log_bin_trust_routine_creators' is deprecated and will be removed in MySQL 5.2. Please use 'log_bin_trust_function_creators' instead -SELECT @@log_bin_trust_routine_creators = @@global.log_bin_trust_routine_creators; -@@log_bin_trust_routine_creators = @@global.log_bin_trust_routine_creators -1 -'#---------------------FN_DYNVARS_064_08----------------------#' -SET @@global.log_bin_trust_routine_creators = TRUE; -Warnings: -Warning 1287 The syntax 'log_bin_trust_routine_creators' is deprecated and will be removed in MySQL 5.2. Please use 'log_bin_trust_function_creators' instead -SELECT @@log_bin_trust_routine_creators; -@@log_bin_trust_routine_creators -1 -SELECT local.log_bin_trust_routine_creators; -ERROR 42S02: Unknown table 'local' in field list -SELECT session.log_bin_trust_routine_creators; -ERROR 42S02: Unknown table 'session' in field list -SELECT log_bin_trust_routine_creators = @@session.log_bin_trust_routine_creators; -ERROR 42S22: Unknown column 'log_bin_trust_routine_creators' in 'field list' -SET @@global.log_bin_trust_routine_creators = @start_global_value; -Warnings: -Warning 1287 The syntax 'log_bin_trust_routine_creators' is deprecated and will be removed in MySQL 5.2. Please use 'log_bin_trust_function_creators' instead -SELECT @@global.log_bin_trust_routine_creators; -@@global.log_bin_trust_routine_creators -1 diff -Nrup a/mysql-test/r/myisam_stats_method_func.result b/mysql-test/r/myisam_stats_method_func.result --- a/mysql-test/r/myisam_stats_method_func.result 2008-04-07 15:14:19 +02:00 +++ b/mysql-test/r/myisam_stats_method_func.result 2008-04-08 14:51:41 +02:00 @@ -20,16 +20,16 @@ ANALYZE TABLE t1; Table Op Msg_type Msg_text test.t1 analyze status OK SHOW INDEX FROM t1; -Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment -t1 1 a 1 a A 10 NULL NULL YES BTREE +Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment +t1 1 a 1 a A 10 NULL NULL YES BTREE INSERT INTO t1 VALUES (11); DELETE FROM t1 WHERE a=11; CHECK TABLE t1; Table Op Msg_type Msg_text test.t1 check status OK SHOW INDEX FROM t1; -Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment -t1 1 a 1 a A 10 NULL NULL YES BTREE +Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment +t1 1 a 1 a A 10 NULL NULL YES BTREE 'Set nulls to be equal' SET myisam_stats_method=nulls_equal; INSERT INTO t1 VALUES (11); @@ -38,16 +38,16 @@ ANALYZE TABLE t1; Table Op Msg_type Msg_text test.t1 analyze status OK SHOW INDEX FROM t1; -Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment -t1 1 a 1 a A 5 NULL NULL YES BTREE +Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment +t1 1 a 1 a A 5 NULL NULL YES BTREE INSERT INTO t1 VALUES (11); DELETE FROM t1 WHERE a=11; CHECK TABLE t1; Table Op Msg_type Msg_text test.t1 check status OK SHOW INDEX FROM t1; -Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment -t1 1 a 1 a A 5 NULL NULL YES BTREE +Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment +t1 1 a 1 a A 5 NULL NULL YES BTREE 'Set nulls to be ignored' SET myisam_stats_method=nulls_ignored; SHOW variables LIKE 'myisam_stats_method'; @@ -66,20 +66,20 @@ ANALYZE TABLE t1; Table Op Msg_type Msg_text test.t1 analyze status OK SHOW INDEX FROM t1; -Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment -t1 1 a 1 a A 2 NULL NULL YES BTREE -t1 1 a 2 b A 4 NULL NULL YES BTREE -t1 1 a 3 c A 4 NULL NULL YES BTREE -t1 1 a 4 d A 4 NULL NULL YES BTREE +Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment +t1 1 a 1 a A 2 NULL NULL YES BTREE +t1 1 a 2 b A 4 NULL NULL YES BTREE +t1 1 a 3 c A 4 NULL NULL YES BTREE +t1 1 a 4 d A 4 NULL NULL YES BTREE DELETE FROM t1; ANALYZE TABLE t1; Table Op Msg_type Msg_text test.t1 analyze status OK SHOW INDEX FROM t1; -Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment -t1 1 a 1 a A 0 NULL NULL YES BTREE -t1 1 a 2 b A 0 NULL NULL YES BTREE -t1 1 a 3 c A 0 NULL NULL YES BTREE -t1 1 a 4 d A 0 NULL NULL YES BTREE +Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment +t1 1 a 1 a A 0 NULL NULL YES BTREE +t1 1 a 2 b A 0 NULL NULL YES BTREE +t1 1 a 3 c A 0 NULL NULL YES BTREE +t1 1 a 4 d A 0 NULL NULL YES BTREE SET myisam_stats_method=DEFAULT; DROP TABLE t1; diff -Nrup a/mysql-test/r/read_rnd_buffer_size_basic.result b/mysql-test/r/read_rnd_buffer_size_basic.result --- a/mysql-test/r/read_rnd_buffer_size_basic.result 2008-04-07 15:14:22 +02:00 +++ b/mysql-test/r/read_rnd_buffer_size_basic.result 2008-04-08 14:51:41 +02:00 @@ -8,15 +8,11 @@ SELECT @start_session_value; 262144 '#--------------------FN_DYNVARS_140_01-------------------------#' SET @@global.read_rnd_buffer_size = 1000; -Warnings: -Warning 1292 Truncated incorrect read_rnd_buffer_size value: '1000' SET @@global.read_rnd_buffer_size = DEFAULT; SELECT @@global.read_rnd_buffer_size; @@global.read_rnd_buffer_size 262144 SET @@session.read_rnd_buffer_size = 2000; -Warnings: -Warning 1292 Truncated incorrect read_rnd_buffer_size value: '2000' SET @@session.read_rnd_buffer_size = DEFAULT; SELECT @@session.read_rnd_buffer_size; @@session.read_rnd_buffer_size @@ -33,14 +29,10 @@ SELECT @@session.read_rnd_buffer_size = 'Bug# 34876: This variable has invalid default value as compared to documentation'; '#--------------------FN_DYNVARS_140_03-------------------------#' SET @@global.read_rnd_buffer_size = 8201; -Warnings: -Warning 1292 Truncated incorrect read_rnd_buffer_size value: '8201' SELECT @@global.read_rnd_buffer_size= 8200 OR @@global.read_rnd_buffer_size= 8228; @@global.read_rnd_buffer_size= 8200 OR @@global.read_rnd_buffer_size= 8228 -1 +0 SET @@global.read_rnd_buffer_size = 8200; -Warnings: -Warning 1292 Truncated incorrect read_rnd_buffer_size value: '8200' SELECT @@global.read_rnd_buffer_size= 8200 OR @@global.read_rnd_buffer_size= 8228; @@global.read_rnd_buffer_size= 8200 OR @@global.read_rnd_buffer_size= 8228 1 @@ -51,21 +43,17 @@ SELECT @@global.read_rnd_buffer_size; SET @@global.read_rnd_buffer_size = 2147479551; SELECT @@global.read_rnd_buffer_size; @@global.read_rnd_buffer_size -2147475456 +2147479551 'Bug# 34877: Invalid Values are coming in variable on assigning valid values'; '#--------------------FN_DYNVARS_140_04-------------------------#' SET @@session.read_rnd_buffer_size = 8200; -Warnings: -Warning 1292 Truncated incorrect read_rnd_buffer_size value: '8200' SELECT @@session.read_rnd_buffer_size= 8200 OR @@session.read_rnd_buffer_size= 8228; @@session.read_rnd_buffer_size= 8200 OR @@session.read_rnd_buffer_size= 8228 1 SET @@session.read_rnd_buffer_size = 8201; -Warnings: -Warning 1292 Truncated incorrect read_rnd_buffer_size value: '8201' SELECT @@session.read_rnd_buffer_size= 8200 OR @@session.read_rnd_buffer_size= 8228; @@session.read_rnd_buffer_size= 8200 OR @@session.read_rnd_buffer_size= 8228 -1 +0 SET @@session.read_rnd_buffer_size = 2147479552; SELECT @@session.read_rnd_buffer_size; @@session.read_rnd_buffer_size @@ -73,58 +61,54 @@ SELECT @@session.read_rnd_buffer_size; SET @@session.read_rnd_buffer_size = 2147479551; SELECT @@session.read_rnd_buffer_size; @@session.read_rnd_buffer_size -2147475456 +2147479551 '#------------------FN_DYNVARS_140_05-----------------------#' SET @@global.read_rnd_buffer_size = 8199; -Warnings: -Warning 1292 Truncated incorrect read_rnd_buffer_size value: '8199' SELECT @@global.read_rnd_buffer_size= 8200 OR @@global.read_rnd_buffer_size= 8228; @@global.read_rnd_buffer_size= 8200 OR @@global.read_rnd_buffer_size= 8228 -1 +0 SET @@global.read_rnd_buffer_size = -1024; Warnings: Warning 1292 Truncated incorrect read_rnd_buffer_size value: '0' SELECT @@global.read_rnd_buffer_size= 8200 OR @@global.read_rnd_buffer_size= 8228; @@global.read_rnd_buffer_size= 8200 OR @@global.read_rnd_buffer_size= 8228 -1 +0 SET @@global.read_rnd_buffer_size = 2147479553; SELECT @@global.read_rnd_buffer_size; @@global.read_rnd_buffer_size -2147479552 +2147479553 SET @@global.read_rnd_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.read_rnd_buffer_size; @@global.read_rnd_buffer_size -2147479552 +2147479553 SET @@global.read_rnd_buffer_size = test; ERROR 42000: Incorrect argument type to variable 'read_rnd_buffer_size' SELECT @@global.read_rnd_buffer_size; @@global.read_rnd_buffer_size -2147479552 +2147479553 SET @@session.read_rnd_buffer_size = 8199; -Warnings: -Warning 1292 Truncated incorrect read_rnd_buffer_size value: '8199' SELECT @@session.read_rnd_buffer_size= 8200 OR @@session.read_rnd_buffer_size= 8228; @@session.read_rnd_buffer_size= 8200 OR @@session.read_rnd_buffer_size= 8228 -1 +0 SET @@session.read_rnd_buffer_size = -2; Warnings: Warning 1292 Truncated incorrect read_rnd_buffer_size value: '0' SELECT @@session.read_rnd_buffer_size= 8200 OR @@session.read_rnd_buffer_size= 8228; @@session.read_rnd_buffer_size= 8200 OR @@session.read_rnd_buffer_size= 8228 -1 +0 SET @@session.read_rnd_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 SET @@session.read_rnd_buffer_size = 2147479553; SELECT @@session.read_rnd_buffer_size; @@session.read_rnd_buffer_size -2147479552 +2147479553 'Bug # 34837: Errors are not coming on assigning invalid values to variable'; SET @@session.read_rnd_buffer_size = test; ERROR 42000: Incorrect argument type to variable 'read_rnd_buffer_size' SELECT @@session.read_rnd_buffer_size; @@session.read_rnd_buffer_size -2147479552 +2147479553 '#------------------FN_DYNVARS_140_06-----------------------#' SELECT @@global.read_rnd_buffer_size = VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='read_rnd_buffer_size'; @@global.read_rnd_buffer_size = VARIABLE_VALUE @@ -141,24 +125,20 @@ Warnings: Warning 1292 Truncated incorrect read_rnd_buffer_size value: '1' SELECT @@global.read_rnd_buffer_size= 8200 OR @@global.read_rnd_buffer_size= 8228; @@global.read_rnd_buffer_size= 8200 OR @@global.read_rnd_buffer_size= 8228 -1 +0 SET @@global.read_rnd_buffer_size = FALSE; Warnings: Warning 1292 Truncated incorrect read_rnd_buffer_size value: '0' SELECT @@global.read_rnd_buffer_size= 8200 OR @@global.read_rnd_buffer_size= 8228; @@global.read_rnd_buffer_size= 8200 OR @@global.read_rnd_buffer_size= 8228 -1 +0 '#---------------------FN_DYNVARS_140_09----------------------#' SET @@global.read_rnd_buffer_size = 9000; -Warnings: -Warning 1292 Truncated incorrect read_rnd_buffer_size value: '9000' SELECT @@read_rnd_buffer_size = @@global.read_rnd_buffer_size; @@read_rnd_buffer_size = @@global.read_rnd_buffer_size 0 '#---------------------FN_DYNVARS_140_10----------------------#' SET @@read_rnd_buffer_size = 9000; -Warnings: -Warning 1292 Truncated incorrect read_rnd_buffer_size value: '9000' SELECT @@read_rnd_buffer_size = @@local.read_rnd_buffer_size; @@read_rnd_buffer_size = @@local.read_rnd_buffer_size 1 @@ -167,11 +147,9 @@ SELECT @@local.read_rnd_buffer_size = @@ 1 '#---------------------FN_DYNVARS_140_11----------------------#' SET read_rnd_buffer_size = 9100; -Warnings: -Warning 1292 Truncated incorrect read_rnd_buffer_size value: '9100' SELECT @@read_rnd_buffer_size= 8200 OR @@read_rnd_buffer_size= 8228; @@read_rnd_buffer_size= 8200 OR @@read_rnd_buffer_size= 8228 -1 +0 SELECT local.read_rnd_buffer_size; ERROR 42S02: Unknown table 'local' in field list SELECT session.read_rnd_buffer_size; diff -Nrup a/mysql-test/r/slave_allow_batching_basic.result b/mysql-test/r/slave_allow_batching_basic.result --- a/mysql-test/r/slave_allow_batching_basic.result 2008-04-07 15:14:22 +02:00 +++ b/mysql-test/r/slave_allow_batching_basic.result 2008-04-08 14:51:41 +02:00 @@ -1,12 +1,98 @@ SET @global_start_value = @@global.slave_allow_batching; -ERROR HY000: Unknown system variable 'slave_allow_batching' 'Bug: This variable is not supported in mysql version 5.1.22' '#--------------------FN_DYNVARS_145_01------------------------#' +SET @@global.slave_allow_batching = 1; +SET @@global.slave_allow_batching = DEFAULT; +SELECT @@global.slave_allow_batching; +@@global.slave_allow_batching +0 '#---------------------FN_DYNVARS_145_02-------------------------#' +SET slave_allow_batching = 1; +ERROR HY000: Variable 'slave_allow_batching' is a GLOBAL variable and should be set with SET GLOBAL +SELECT @@slave_allow_batching; +@@slave_allow_batching +0 +SELECT global.slave_allow_batching; +ERROR 42S02: Unknown table 'global' in field list +SET global slave_allow_batching = 1; +SELECT @@global.slave_allow_batching; +@@global.slave_allow_batching +1 '#--------------------FN_DYNVARS_145_03------------------------#' +SET @@global.slave_allow_batching = 0; +SELECT @@global.slave_allow_batching; +@@global.slave_allow_batching +0 +SET @@global.slave_allow_batching = 1; +SELECT @@global.slave_allow_batching; +@@global.slave_allow_batching +1 '#--------------------FN_DYNVARS_145_04-------------------------#' +SET @@global.slave_allow_batching = -1; +ERROR 42000: Variable 'slave_allow_batching' can't be set to the value of '-1' +SET @@global.slave_allow_batching = 2; +ERROR 42000: Variable 'slave_allow_batching' can't be set to the value of '2' +SET @@global.slave_allow_batching = "T"; +ERROR 42000: Variable 'slave_allow_batching' can't be set to the value of 'T' +SET @@global.slave_allow_batching = "Y"; +ERROR 42000: Variable 'slave_allow_batching' can't be set to the value of 'Y' +SET @@global.slave_allow_batching = YES; +ERROR 42000: Variable 'slave_allow_batching' can't be set to the value of 'YES' +SET @@global.slave_allow_batching = ONN; +ERROR 42000: Variable 'slave_allow_batching' can't be set to the value of 'ONN' +SET @@global.slave_allow_batching = OOF; +ERROR 42000: Variable 'slave_allow_batching' can't be set to the value of 'OOF' +SET @@global.slave_allow_batching = 0FF; +ERROR 42000: Variable 'slave_allow_batching' can't be set to the value of '0FF' +SET @@global.slave_allow_batching = ' 1'; +ERROR 42000: Variable 'slave_allow_batching' can't be set to the value of ' 1' +SET @@global.slave_allow_batching = NO; +ERROR 42000: Variable 'slave_allow_batching' can't be set to the value of 'NO' '#-------------------FN_DYNVARS_145_05----------------------------#' +SET @@session.slave_allow_batching = 0; +ERROR HY000: Variable 'slave_allow_batching' is a GLOBAL variable and should be set with SET GLOBAL +SET @@slave_allow_batching = 0; +ERROR HY000: Variable 'slave_allow_batching' is a GLOBAL variable and should be set with SET GLOBAL +SET @@local.slave_allow_batching = 0; +ERROR HY000: Variable 'slave_allow_batching' is a GLOBAL variable and should be set with SET GLOBAL +SELECT @@session.slave_allow_batching; +ERROR HY000: Variable 'slave_allow_batching' is a GLOBAL variable +SELECT @@local.slave_allow_batching; +ERROR HY000: Variable 'slave_allow_batching' is a GLOBAL variable '#----------------------FN_DYNVARS_145_06------------------------#' +SELECT count(VARIABLE_VALUE) FROM INFORMATION_SCHEMA.SESSION_VARIABLES WHERE VARIABLE_NAME='slave_allow_batching'; +count(VARIABLE_VALUE) +1 '#----------------------FN_DYNVARS_145_07------------------------#' +SELECT @@global.slave_allow_batching = VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='slave_allow_batching'; +@@global.slave_allow_batching = VARIABLE_VALUE +0 +SELECT @@global.slave_allow_batching; +@@global.slave_allow_batching +1 +SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='slave_allow_batching'; +VARIABLE_VALUE +ON +'Bug: value in information schema does not match' '#---------------------FN_DYNVARS_145_08-------------------------#' +SET @@global.slave_allow_batching = OFF; +SELECT @@global.slave_allow_batching; +@@global.slave_allow_batching +0 +SET @@global.slave_allow_batching = ON; +SELECT @@global.slave_allow_batching; +@@global.slave_allow_batching +1 '#---------------------FN_DYNVARS_145_09----------------------#' +SET @@global.slave_allow_batching = TRUE; +SELECT @@global.slave_allow_batching; +@@global.slave_allow_batching +1 +SET @@global.slave_allow_batching = FALSE; +SELECT @@global.slave_allow_batching; +@@global.slave_allow_batching +0 +SET @@global.slave_allow_batching = @global_start_value; +SELECT @@global.slave_allow_batching; +@@global.slave_allow_batching +0 diff -Nrup a/mysql-test/t/log_bin_trust_routine_creators_basic.test b/mysql-test/t/log_bin_trust_routine_creators_basic.test --- a/mysql-test/t/log_bin_trust_routine_creators_basic.test 2008-04-07 15:13:51 +02:00 +++ /dev/null Wed Dec 31 16:00:00 196900 @@ -1,164 +0,0 @@ -############## mysql-test\t\log_bin_trust_routine_creators_basic.test ######### -# # -# Variable Name: log_bin_trust_routine_creators # -# Scope: GLOBAL # -# Access Type: Dynamic # -# Data Type: boolean # -# Default Value: False # -# Range: # -# # -# # -# Creation Date: 2008-02-12 # -# Author: Salman # -# # -# Description: Test Cases of Dynamic System Variable # -# log_bin_trust_routine_creators that checks the # -# behavior of this variable in the following ways # -# * Default Value # -# * Valid & Invalid values # -# * Scope & Access method # -# * Data Integrity # -# # -# Reference: (Not given on website) # -# # -############################################################################### - ---source include/load_sysvars.inc -#################################################################### -# START OF log_bin_trust_routine_creators TESTS # -#################################################################### - - -############################################################# -# Save initial value # -############################################################# - -SET @start_global_value = @@global.log_bin_trust_routine_creators; -SELECT @start_global_value; - - ---echo '#--------------------FN_DYNVARS_064_01-------------------------#' -######################################################################## -# Display the DEFAULT value of log_bin_trust_routine_creators # -######################################################################## - -SET @@global.log_bin_trust_routine_creators = TRUE; -SET @@global.log_bin_trust_routine_creators = DEFAULT; -SELECT @@global.log_bin_trust_routine_creators; - - ---echo '#--------------------FN_DYNVARS_064_02-------------------------#' -############################################################################## -# Check the DEFAULT value of log_bin_trust_routine_creators # -############################################################################## - -SET @@global.log_bin_trust_routine_creators = DEFAULT; -SELECT @@global.log_bin_trust_routine_creators = 'FALSE'; - - ---echo '#--------------------FN_DYNVARS_064_03-------------------------#' -################################################################## -# Change the value of variable to a valid value for GLOBAL Scope # -################################################################## - -SET @@global.log_bin_trust_routine_creators = ON; -SELECT @@global.log_bin_trust_routine_creators; -SET @@global.log_bin_trust_routine_creators = OFF; -SELECT @@global.log_bin_trust_routine_creators; -SET @@global.log_bin_trust_routine_creators = 0; -SELECT @@global.log_bin_trust_routine_creators; -SET @@global.log_bin_trust_routine_creators = 1; -SELECT @@global.log_bin_trust_routine_creators; -SET @@global.log_bin_trust_routine_creators = TRUE; -SELECT @@global.log_bin_trust_routine_creators; -SET @@global.log_bin_trust_routine_creators = FALSE; -SELECT @@global.log_bin_trust_routine_creators; - - ---echo '#-------------------FN_DYNVARS_064_04----------------------------#' -########################################################################### -# Test if accessing session log_bin_trust_routine_creators gives error # -########################################################################### - ---Error ER_GLOBAL_VARIABLE -SET @@session.log_bin_trust_routine_creators = 0; ---Error ER_INCORRECT_GLOBAL_LOCAL_VAR -SELECT @@session.log_bin_trust_routine_creators; - - ---echo '#------------------FN_DYNVARS_064_05-----------------------#' -########################################################################## -# Change the value of log_bin_trust_routine_creators to an invalid value # -########################################################################## - ---Error ER_WRONG_VALUE_FOR_VAR -SET @@global.log_bin_trust_routine_creators = 'ONN'; ---Error ER_WRONG_VALUE_FOR_VAR -SET @@global.log_bin_trust_routine_creators = "OFFF"; -SET @@global.log_bin_trust_routine_creators = OF; -SELECT @@global.log_bin_trust_routine_creators; ---echo 'Bug# 34828: OF is also working as OFF and no error is coming'; - ---Error ER_WRONG_VALUE_FOR_VAR -SET @@global.log_bin_trust_routine_creators = TTRUE; ---Error ER_WRONG_VALUE_FOR_VAR -SET @@global.log_bin_trust_routine_creators = FELSE; ---Error ER_WRONG_VALUE_FOR_VAR -SET @@global.log_bin_trust_routine_creators = -1024; ---Error ER_WRONG_VALUE_FOR_VAR -SET @@global.log_bin_trust_routine_creators = 65536; ---Error ER_WRONG_VALUE_FOR_VAR -SET @@global.log_bin_trust_routine_creators = 65530.34; ---Error ER_WRONG_VALUE_FOR_VAR -SET @@global.log_bin_trust_routine_creators = test; - - ---echo '#------------------FN_DYNVARS_064_06-----------------------#' -############################################################################### -# Check if the value in GLOBAL & SESSION Tables matches value in variable # -############################################################################### - - -SELECT @@global.log_bin_trust_routine_creators = VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='log_bin_trust_routine_creators'; - ---Error ER_INCORRECT_GLOBAL_LOCAL_VAR -SELECT @@session.log_bin_trust_routine_creators = VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES WHERE VARIABLE_NAME='log_bin_trust_routine_creators'; - - ---echo '#---------------------FN_DYNVARS_064_07----------------------#' -################################################################################# -# Check if accessing variable with and without GLOBAL point to same variable # -################################################################################# - - -SET @@global.log_bin_trust_routine_creators = TRUE; -SELECT @@log_bin_trust_routine_creators = @@global.log_bin_trust_routine_creators; - - ---echo '#---------------------FN_DYNVARS_064_08----------------------#' -################################################################### -# Check if variable can be accessed with and without @@ sign # -################################################################### - -SET @@global.log_bin_trust_routine_creators = TRUE; -SELECT @@log_bin_trust_routine_creators; ---Error ER_UNKNOWN_TABLE -SELECT local.log_bin_trust_routine_creators; ---Error ER_UNKNOWN_TABLE -SELECT session.log_bin_trust_routine_creators; ---Error ER_BAD_FIELD_ERROR -SELECT log_bin_trust_routine_creators = @@session.log_bin_trust_routine_creators; - - -#################################### -# Restore initial value # -#################################### - -SET @@global.log_bin_trust_routine_creators = @start_global_value; -SELECT @@global.log_bin_trust_routine_creators; - - -################################################################### -# END OF log_bin_trust_routine_creators TESTS # -################################################################### - diff -Nrup a/mysql-test/t/slave_allow_batching_basic.test b/mysql-test/t/slave_allow_batching_basic.test --- a/mysql-test/t/slave_allow_batching_basic.test 2008-04-07 15:13:56 +02:00 +++ b/mysql-test/t/slave_allow_batching_basic.test 2008-04-08 14:51:41 +02:00 @@ -34,7 +34,6 @@ # Saving initial value of slave_allow_batching in a temporary variable # ################################################################################ ---Error ER_UNKNOWN_SYSTEM_VARIABLE SET @global_start_value = @@global.slave_allow_batching; --echo 'Bug: This variable is not supported in mysql version 5.1.22' @@ -44,23 +43,23 @@ SET @global_start_value = @@global.slave # Display the DEFAULT value of slave_allow_batching # ######################################################################## -#SET @@global.slave_allow_batching = 1; -#SET @@global.slave_allow_batching = DEFAULT; -#SELECT @@global.slave_allow_batching; +SET @@global.slave_allow_batching = 1; +SET @@global.slave_allow_batching = DEFAULT; +SELECT @@global.slave_allow_batching; --echo '#---------------------FN_DYNVARS_145_02-------------------------#' ############################################################################# # Check if slave_allow_batching can be accessed with and without @@ sign # ############################################################################# -#--Error ER_GLOBAL_VARIABLE -#SET slave_allow_batching = 1; -#SELECT @@slave_allow_batching; -#--Error ER_UNKNOWN_TABLE -#SELECT global.slave_allow_batching; -# -#SET global slave_allow_batching = 1; -#SELECT @@global.slave_allow_batching; +--Error ER_GLOBAL_VARIABLE +SET slave_allow_batching = 1; +SELECT @@slave_allow_batching; +--Error ER_UNKNOWN_TABLE +SELECT global.slave_allow_batching; + +SET global slave_allow_batching = 1; +SELECT @@global.slave_allow_batching; --echo '#--------------------FN_DYNVARS_145_03------------------------#' @@ -68,10 +67,10 @@ SET @global_start_value = @@global.slave # Change the value of slave_allow_batching to a valid value # ######################################################################## -#SET @@global.slave_allow_batching = 0; -#SELECT @@global.slave_allow_batching; -#SET @@global.slave_allow_batching = 1; -#SELECT @@global.slave_allow_batching; +SET @@global.slave_allow_batching = 0; +SELECT @@global.slave_allow_batching; +SET @@global.slave_allow_batching = 1; +SELECT @@global.slave_allow_batching; --echo '#--------------------FN_DYNVARS_145_04-------------------------#' @@ -79,26 +78,26 @@ SET @global_start_value = @@global.slave # Change the value of slave_allow_batching to invalid value # ########################################################################### -#--Error ER_WRONG_VALUE_FOR_VAR -#SET @@global.slave_allow_batching = -1; -#--Error ER_WRONG_VALUE_FOR_VAR -#SET @@global.slave_allow_batching = 2; -#--Error ER_WRONG_VALUE_FOR_VAR -#SET @@global.slave_allow_batching = "T"; -#--Error ER_WRONG_VALUE_FOR_VAR -#SET @@global.slave_allow_batching = "Y"; -#--Error ER_WRONG_VALUE_FOR_VAR -#SET @@global.slave_allow_batching = YES; -#--Error ER_WRONG_VALUE_FOR_VAR -#SET @@global.slave_allow_batching = ONN; -#--Error ER_WRONG_VALUE_FOR_VAR -#SET @@global.slave_allow_batching = OOF; -#--Error ER_WRONG_VALUE_FOR_VAR -#SET @@global.slave_allow_batching = 0FF; -#--Error ER_WRONG_VALUE_FOR_VAR -#SET @@global.slave_allow_batching = ' 1'; -#--Error ER_WRONG_VALUE_FOR_VAR -#SET @@global.slave_allow_batching = NO; +--Error ER_WRONG_VALUE_FOR_VAR +SET @@global.slave_allow_batching = -1; +--Error ER_WRONG_VALUE_FOR_VAR +SET @@global.slave_allow_batching = 2; +--Error ER_WRONG_VALUE_FOR_VAR +SET @@global.slave_allow_batching = "T"; +--Error ER_WRONG_VALUE_FOR_VAR +SET @@global.slave_allow_batching = "Y"; +--Error ER_WRONG_VALUE_FOR_VAR +SET @@global.slave_allow_batching = YES; +--Error ER_WRONG_VALUE_FOR_VAR +SET @@global.slave_allow_batching = ONN; +--Error ER_WRONG_VALUE_FOR_VAR +SET @@global.slave_allow_batching = OOF; +--Error ER_WRONG_VALUE_FOR_VAR +SET @@global.slave_allow_batching = 0FF; +--Error ER_WRONG_VALUE_FOR_VAR +SET @@global.slave_allow_batching = ' 1'; +--Error ER_WRONG_VALUE_FOR_VAR +SET @@global.slave_allow_batching = NO; --echo '#-------------------FN_DYNVARS_145_05----------------------------#' @@ -106,23 +105,23 @@ SET @global_start_value = @@global.slave # Test if accessing session slave_allow_batching gives error # ########################################################################### -#--Error ER_GLOBAL_VARIABLE -#SET @@session.slave_allow_batching = 0; -#--Error ER_GLOBAL_VARIABLE -#SET @@slave_allow_batching = 0; -#--Error ER_GLOBAL_VARIABLE -#SET @@local.slave_allow_batching = 0; -#--Error ER_INCORRECT_GLOBAL_LOCAL_VAR -#SELECT @@session.slave_allow_batching; -#--Error ER_INCORRECT_GLOBAL_LOCAL_VAR -#SELECT @@local.slave_allow_batching; +--Error ER_GLOBAL_VARIABLE +SET @@session.slave_allow_batching = 0; +--Error ER_GLOBAL_VARIABLE +SET @@slave_allow_batching = 0; +--Error ER_GLOBAL_VARIABLE +SET @@local.slave_allow_batching = 0; +--Error ER_INCORRECT_GLOBAL_LOCAL_VAR +SELECT @@session.slave_allow_batching; +--Error ER_INCORRECT_GLOBAL_LOCAL_VAR +SELECT @@local.slave_allow_batching; --echo '#----------------------FN_DYNVARS_145_06------------------------#' ######################################################################### # Check if the value in SESSION Table contains variable value # ######################################################################### -#SELECT count(VARIABLE_VALUE) FROM INFORMATION_SCHEMA.SESSION_VARIABLES WHERE VARIABLE_NAME='slave_allow_batching'; +SELECT count(VARIABLE_VALUE) FROM INFORMATION_SCHEMA.SESSION_VARIABLES WHERE VARIABLE_NAME='slave_allow_batching'; --echo '#----------------------FN_DYNVARS_145_07------------------------#' @@ -130,37 +129,37 @@ SET @global_start_value = @@global.slave # Check if the value in GLOBAL Table matches value in variable # ######################################################################### -#SELECT @@global.slave_allow_batching = VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='slave_allow_batching'; -#SELECT @@global.slave_allow_batching; -#SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='slave_allow_batching'; -#--echo 'Bug: value in information schema does not match' +SELECT @@global.slave_allow_batching = VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='slave_allow_batching'; +SELECT @@global.slave_allow_batching; +SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='slave_allow_batching'; +--echo 'Bug: value in information schema does not match' --echo '#---------------------FN_DYNVARS_145_08-------------------------#' ################################################################### # Check if ON and OFF values can be used on variable # ################################################################### -#SET @@global.slave_allow_batching = OFF; -#SELECT @@global.slave_allow_batching; -#SET @@global.slave_allow_batching = ON; -#SELECT @@global.slave_allow_batching; +SET @@global.slave_allow_batching = OFF; +SELECT @@global.slave_allow_batching; +SET @@global.slave_allow_batching = ON; +SELECT @@global.slave_allow_batching; --echo '#---------------------FN_DYNVARS_145_09----------------------#' ################################################################### # Check if TRUE and FALSE values can be used on variable # ################################################################### -#SET @@global.slave_allow_batching = TRUE; -#SELECT @@global.slave_allow_batching; -#SET @@global.slave_allow_batching = FALSE; -#SELECT @@global.slave_allow_batching; +SET @@global.slave_allow_batching = TRUE; +SELECT @@global.slave_allow_batching; +SET @@global.slave_allow_batching = FALSE; +SELECT @@global.slave_allow_batching; ############################## # Restore initial value # ############################## -#SET @@global.slave_allow_batching = @global_start_value; -#SELECT @@global.slave_allow_batching; +SET @@global.slave_allow_batching = @global_start_value; +SELECT @@global.slave_allow_batching; ############################################################### # END OF slave_allow_batching TESTS #