3166 Horst Hunger 2009-04-03 [merge]
due to merge.
removed:
mysql-test/std_data/bug32880.ARN
mysql-test/std_data/bug32880.ARZ
mysql-test/std_data/bug32880.frm
mysql-test/suite/backup/r/backup_view_on_view.result
mysql-test/suite/backup/t/backup_view_on_view.test
mysql-test/suite/backup_engines/r/backup_procedures.result
mysql-test/suite/backup_engines/r/backup_ptr_commit_mixed.result
mysql-test/suite/backup_engines/r/backup_ptr_commit_stmt.result
mysql-test/suite/backup_engines/r/backup_ptr_mixed.result
mysql-test/suite/backup_engines/r/backup_ptr_objects_mixed.result
mysql-test/suite/backup_engines/r/backup_ptr_objects_row.result
mysql-test/suite/backup_engines/r/backup_ptr_objects_stmt.result
mysql-test/suite/backup_engines/r/backup_ptr_row.result
mysql-test/suite/backup_engines/r/backup_ptr_stmt.result
mysql-test/suite/backup_engines/t/backup_procedures.test
mysql-test/suite/backup_engines/t/backup_ptr_commit_mixed.test
mysql-test/suite/backup_engines/t/backup_ptr_commit_row.test
mysql-test/suite/backup_engines/t/backup_ptr_commit_stmt.test
mysql-test/suite/backup_engines/t/backup_ptr_mixed.test
mysql-test/suite/backup_engines/t/backup_ptr_objects_mixed.test
mysql-test/suite/backup_engines/t/backup_ptr_objects_row.test
mysql-test/suite/backup_engines/t/backup_ptr_objects_stmt.test
mysql-test/suite/backup_engines/t/backup_ptr_row.test
mysql-test/suite/backup_engines/t/backup_ptr_stmt.test
mysql-test/suite/backup_engines/t/disabled.def
added:
client/backup_stream.c
client/backup_stream.h
client/mysqlbackup.cc
mysql-test/extra/binlog_tests/drop_table.test
mysql-test/include/bug38347.inc
mysql-test/r/myisamlog_coverage.result
mysql-test/suite/backup/README
mysql-test/suite/backup/include/
mysql-test/suite/backup/include/backup_client_regex_output.inc
mysql-test/suite/backup/include/backup_client_regex_usage.inc
mysql-test/suite/backup/include/bml_test.inc
mysql-test/suite/backup/include/objects_dependency_use.inc
mysql-test/suite/backup/r/backup_accented.result
mysql-test/suite/backup/r/backup_client.result
mysql-test/suite/backup/r/backup_client_binlog.result
mysql-test/suite/backup/r/backup_client_coverage.result
mysql-test/suite/backup/r/backup_compression_non_win.result
mysql-test/suite/backup/r/backup_db_grants_extra.result
mysql-test/suite/backup/r/backup_dbname_lctn0.result
mysql-test/suite/backup/r/backup_dbname_lctn1.result
mysql-test/suite/backup/r/backup_dbname_lctn2.result
mysql-test/suite/backup/r/backup_errors_compression.result
mysql-test/suite/backup/r/backup_image_name_notwin.result
mysql-test/suite/backup/r/backup_image_name_win.result
mysql-test/suite/backup/r/backup_mysql_upgrade.result
mysql-test/suite/backup/r/backup_object_count.result
mysql-test/suite/backup/r/backup_objects_dependency.result
mysql-test/suite/backup/r/backup_pipe.result
mysql-test/suite/backup/r/backup_special_characters.result
mysql-test/suite/backup/r/backup_stream_pipe.result
mysql-test/suite/backup/r/backup_table_grants.result
mysql-test/suite/backup/t/backup_accented.test
mysql-test/suite/backup/t/backup_client.test
mysql-test/suite/backup/t/backup_client_binlog.test
mysql-test/suite/backup/t/backup_client_coverage.test
mysql-test/suite/backup/t/backup_compression_non_win.test
mysql-test/suite/backup/t/backup_db_grants_extra.test
mysql-test/suite/backup/t/backup_dbname_lctn0-master.opt
mysql-test/suite/backup/t/backup_dbname_lctn0.test
mysql-test/suite/backup/t/backup_dbname_lctn1-master.opt
mysql-test/suite/backup/t/backup_dbname_lctn1.test
mysql-test/suite/backup/t/backup_dbname_lctn2-master.opt
mysql-test/suite/backup/t/backup_dbname_lctn2.test
mysql-test/suite/backup/t/backup_errors_compression.test
mysql-test/suite/backup/t/backup_image_name_notwin.test
mysql-test/suite/backup/t/backup_image_name_win.test
mysql-test/suite/backup/t/backup_mysql_upgrade.test
mysql-test/suite/backup/t/backup_object_count.test
mysql-test/suite/backup/t/backup_objects_dependency.test
mysql-test/suite/backup/t/backup_pipe.test
mysql-test/suite/backup/t/backup_special_characters.test
mysql-test/suite/backup/t/backup_stream_pipe.test
mysql-test/suite/backup/t/backup_table_grants.test
mysql-test/suite/backup_engines/README
mysql-test/suite/backup_engines/include/not_archive.inc
mysql-test/suite/backup_engines/include/not_csv.inc
mysql-test/suite/backup_ptr/
mysql-test/suite/backup_ptr/README
mysql-test/suite/backup_ptr/combinations
mysql-test/suite/backup_ptr/include/
mysql-test/suite/backup_ptr/r/
mysql-test/suite/backup_ptr/r/backup_ptr.result
mysql-test/suite/backup_ptr/r/backup_ptr_objects.result
mysql-test/suite/backup_ptr/t/
mysql-test/suite/binlog/r/binlog_row_drop_tbl.result
mysql-test/suite/binlog/r/binlog_stm_drop_tbl.result
mysql-test/suite/binlog/t/binlog_row_drop_tbl.test
mysql-test/suite/binlog/t/binlog_stm_drop_tbl.test
mysql-test/suite/rpl/r/rpl_empty_master_host.result
mysql-test/suite/rpl/r/rpl_heartbeat_2slaves.result
mysql-test/suite/rpl/r/rpl_heartbeat_basic.result
mysql-test/suite/rpl/r/rpl_heartbeat_ssl.result
mysql-test/suite/rpl/r/rpl_row_wide_table.result
mysql-test/suite/rpl/r/rpl_slow_query_log.result
mysql-test/suite/rpl/r/rpl_sync.result
mysql-test/suite/rpl/t/rpl_empty_master_host.test
mysql-test/suite/rpl/t/rpl_heartbeat_2slaves.cnf
mysql-test/suite/rpl/t/rpl_heartbeat_2slaves.test
mysql-test/suite/rpl/t/rpl_heartbeat_basic.cnf
mysql-test/suite/rpl/t/rpl_heartbeat_basic.test
mysql-test/suite/rpl/t/rpl_heartbeat_ssl.test
mysql-test/suite/rpl/t/rpl_row_wide_table.test
mysql-test/suite/rpl/t/rpl_slow_query_log-slave.opt
mysql-test/suite/rpl/t/rpl_slow_query_log.test
mysql-test/suite/rpl/t/rpl_sync-slave.opt
mysql-test/suite/rpl/t/rpl_sync.test
mysql-test/t/myisamlog_coverage-master.opt
mysql-test/t/myisamlog_coverage.test
renamed:
mysql-test/suite/backup/r/backup_ddl_blocker.result => mysql-test/suite/backup/r/backup_bml.result
mysql-test/suite/backup/r/backup_securefilepriv.result => mysql-test/suite/backup/r/backup_securebackup.result
mysql-test/suite/backup/t/backup_ddl_blocker.test => mysql-test/suite/backup/t/backup_bml.test
mysql-test/suite/backup/t/backup_securefilepriv-master.opt => mysql-test/suite/backup/t/backup_securebackup-master.opt
mysql-test/suite/backup/t/backup_securefilepriv.test => mysql-test/suite/backup/t/backup_securebackup.test
mysql-test/suite/backup_engines/include/backup_ptr.inc => mysql-test/suite/backup_ptr/t/backup_ptr.test
mysql-test/suite/backup_engines/include/backup_ptr_commit.inc => mysql-test/suite/backup_ptr/t/backup_ptr_commits.test
mysql-test/suite/backup_engines/include/backup_ptr_objects.inc => mysql-test/suite/backup_ptr/t/backup_ptr_objects.test
mysql-test/suite/backup_engines/include/not_have_falcon.inc => mysql-test/suite/backup_engines/include/not_falcon.inc
mysql-test/suite/backup_engines/include/not_have_innodb.inc => mysql-test/suite/backup_engines/include/not_innodb.inc
mysql-test/suite/backup_engines/include/not_have_memory.inc => mysql-test/suite/backup_engines/include/not_memory.inc
mysql-test/suite/backup_engines/include/not_have_myisam.inc => mysql-test/suite/backup_engines/include/not_myisam.inc
mysql-test/suite/backup_engines/r/backup_functions.result => mysql-test/suite/backup/r/backup_functions.result
mysql-test/suite/backup_engines/r/backup_online_testing.result => mysql-test/suite/backup/r/backup_online_testing.result
mysql-test/suite/backup_engines/r/backup_ptr_commit_row.result => mysql-test/suite/backup_ptr/r/backup_ptr_commits.result
mysql-test/suite/backup_engines/r/backup_tmp_tables.result => mysql-test/suite/backup/r/backup_tmp_tables.result
mysql-test/suite/backup_engines/t/backup_functions.test => mysql-test/suite/backup/t/backup_functions.test
mysql-test/suite/backup_engines/t/backup_online_testing.test => mysql-test/suite/backup/t/backup_online_testing.test
mysql-test/suite/backup_engines/t/backup_tmp_tables.test => mysql-test/suite/backup/t/backup_tmp_tables.test
sql/ddl_blocker.cc => sql/bml.cc
sql/ddl_blocker.h => sql/bml.h
modified:
.bzrignore
client/CMakeLists.txt
client/Makefile.am
client/mysqldump.c
cmd-line-utils/libedit/readline/readline.h
cmd-line-utils/libedit/term.c
cmd-line-utils/libedit/vi.c
config/ac-macros/libevent_configure.m4
dbug/dbug.c
include/my_global.h
include/my_pthread.h
include/my_sys.h
libmysql/Makefile.shared
libmysqld/CMakeLists.txt
libmysqld/Makefile.am
mysql-test/Makefile.am
mysql-test/extra/binlog_tests/mix_innodb_myisam_binlog.test
mysql-test/include/locktrans.inc
mysql-test/include/mix1.inc
mysql-test/include/mix2.inc
mysql-test/include/test_fieldsize.inc
mysql-test/include/wait_for_status_var.inc
mysql-test/lib/My/SafeProcess/Makefile.am
mysql-test/mysql-test-run.pl
mysql-test/r/archive.result
mysql-test/r/ddl_i18n_koi8r.result
mysql-test/r/ddl_i18n_utf8.result
mysql-test/r/debug_sync.result
mysql-test/r/events_1.result
mysql-test/r/events_2.result
mysql-test/r/flush_block_commit.result
mysql-test/r/flush_block_commit_notembedded.result
mysql-test/r/grant.result
mysql-test/r/innodb.result
mysql-test/r/innodb_mysql.result
mysql-test/r/lock.result
mysql-test/r/locktrans_innodb.result
mysql-test/r/locktrans_myisam.result
mysql-test/r/mix2_myisam.result
mysql-test/r/myisam_keycache_coverage.result
mysql-test/r/myisamlog.result
mysql-test/r/mysqlbinlog_row_big.result
mysql-test/r/mysqldump.result
mysql-test/r/not_embedded_server.result
mysql-test/r/partition.result
mysql-test/r/partition_innodb_semi_consistent.result
mysql-test/r/ps.result
mysql-test/r/ps_1general.result
mysql-test/r/read_only_innodb.result
mysql-test/r/show_check.result
mysql-test/r/union.result
mysql-test/r/variables_debug.result
mysql-test/r/xml.result
mysql-test/suite/backup/r/backup.result
mysql-test/suite/backup/r/backup_backupdir.result
mysql-test/suite/backup/r/backup_compression.result
mysql-test/suite/backup/r/backup_db_grants.result
mysql-test/suite/backup/r/backup_errors.result
mysql-test/suite/backup/r/backup_lock_myisam.result
mysql-test/suite/backup/r/backup_logs.result
mysql-test/suite/backup/r/backup_logs_output.result
mysql-test/suite/backup/r/backup_procedures.result
mysql-test/suite/backup/r/backup_tablespace.result
mysql-test/suite/backup/r/backup_timeout.result
mysql-test/suite/backup/r/backup_views.result
mysql-test/suite/backup/t/backup.test
mysql-test/suite/backup/t/backup_backupdir.test
mysql-test/suite/backup/t/backup_charsets.test
mysql-test/suite/backup/t/backup_compression.test
mysql-test/suite/backup/t/backup_concurrent.test
mysql-test/suite/backup/t/backup_datatypes.test
mysql-test/suite/backup/t/backup_db_grants.test
mysql-test/suite/backup/t/backup_default.test
mysql-test/suite/backup/t/backup_errors.test
mysql-test/suite/backup/t/backup_fkey.test
mysql-test/suite/backup/t/backup_lock_myisam.test
mysql-test/suite/backup/t/backup_logs.test
mysql-test/suite/backup/t/backup_logs_output-master.opt
mysql-test/suite/backup/t/backup_logs_output.test
mysql-test/suite/backup/t/backup_logs_purge.test
mysql-test/suite/backup/t/backup_many_dbs.test
mysql-test/suite/backup/t/backup_maria.test
mysql-test/suite/backup/t/backup_multi_blocks.test
mysql-test/suite/backup/t/backup_myisam.test
mysql-test/suite/backup/t/backup_myisam_coverage.test
mysql-test/suite/backup/t/backup_myisam_extlocking.test
mysql-test/suite/backup/t/backup_myisam_sync.test
mysql-test/suite/backup/t/backup_no_be.test
mysql-test/suite/backup/t/backup_no_data.test
mysql-test/suite/backup/t/backup_no_engine.test
mysql-test/suite/backup/t/backup_nodata_driver.test
mysql-test/suite/backup/t/backup_objects.test
mysql-test/suite/backup/t/backup_procedures.test
mysql-test/suite/backup/t/backup_security.test
mysql-test/suite/backup/t/backup_snapshot.test
mysql-test/suite/backup/t/backup_tablespace.test
mysql-test/suite/backup/t/backup_timeout.test
mysql-test/suite/backup/t/backup_triggers_and_events.test
mysql-test/suite/backup/t/backup_views.test
mysql-test/suite/backup/t/disabled.def
mysql-test/suite/backup_engines/combinations
mysql-test/suite/backup_engines/r/backup_partition.result
mysql-test/suite/backup_engines/r/backup_partitioning.result
mysql-test/suite/backup_engines/t/backup_partition.test
mysql-test/suite/backup_engines/t/backup_partitioning.test
mysql-test/suite/backup_engines/t/backup_triggers.test
mysql-test/suite/binlog/r/binlog_row_mix_innodb_myisam.result
mysql-test/suite/binlog/r/binlog_stm_mix_innodb_myisam.result
mysql-test/suite/falcon/r/falcon_bugs2.result
mysql-test/suite/falcon/t/disabled.def
mysql-test/suite/falcon/t/falcon_bugs2.test
mysql-test/suite/funcs_1/r/is_columns_mysql.result
mysql-test/suite/funcs_1/r/is_columns_mysql_embedded.result
mysql-test/suite/funcs_1/r/processlist_priv_ps.result
mysql-test/suite/funcs_1/r/processlist_val_ps.result
mysql-test/suite/ndb/r/ndb_index_ordered.result
mysql-test/suite/ndb/t/disabled.def
mysql-test/suite/ndb/t/ndb_index_ordered.test
mysql-test/suite/parts/r/partition_special_innodb.result
mysql-test/suite/parts/t/partition_special_innodb.test
mysql-test/suite/rpl/r/rpl_backup.result
mysql-test/suite/rpl/r/rpl_flushlog_loop.result
mysql-test/suite/rpl/r/rpl_loadfile.result
mysql-test/suite/rpl/r/rpl_locktrans_falcon.result
mysql-test/suite/rpl/r/rpl_locktrans_innodb.result
mysql-test/suite/rpl/r/rpl_locktrans_myisam.result
mysql-test/suite/rpl/r/rpl_log_pos.result
mysql-test/suite/rpl/r/rpl_temporary.result
mysql-test/suite/rpl/t/disabled.def
mysql-test/suite/rpl/t/rpl_backup.test
mysql-test/suite/rpl/t/rpl_loadfile.test
mysql-test/suite/rpl/t/rpl_temporary.test
mysql-test/suite/sys_vars/t/autocommit_func.test
mysql-test/t/archive.test
mysql-test/t/debug_sync.test
mysql-test/t/disabled.def
mysql-test/t/flush_block_commit.test
mysql-test/t/flush_block_commit_notembedded.test
mysql-test/t/grant.test
mysql-test/t/innodb.test
mysql-test/t/lock.test
mysql-test/t/myisam_keycache_coverage.test
mysql-test/t/myisamlog.test
mysql-test/t/mysqlbinlog_row_big.test
mysql-test/t/not_embedded_server.test
mysql-test/t/partition.test
mysql-test/t/partition_innodb_semi_consistent.test
mysql-test/t/ps.test
mysql-test/t/ps_1general.test
mysql-test/t/read_only_innodb.test
mysql-test/t/sp.test
mysql-test/t/union.test
mysql-test/t/user_limits.test
mysql-test/t/variables_debug.test
mysql-test/t/xa.test
mysql-test/t/xml.test
mysql-test/valgrind.supp
mysys/my_lock.c
mysys/my_malloc.c
mysys/my_static.c
mysys/my_thr_init.c
mysys/safemalloc.c
mysys/thr_mutex.c
scripts/mysql_install_db.sh
scripts/mysql_system_tables.sql
scripts/mysqld_multi.sh
sql/CMakeLists.txt
sql/Makefile.am
sql/backup/backup_aux.h
sql/backup/backup_engine.h
sql/backup/backup_info.cc
sql/backup/backup_kernel.h
sql/backup/backup_test.cc
sql/backup/be_default.cc
sql/backup/be_nodata.cc
sql/backup/be_nodata.h
sql/backup/be_snapshot.cc
sql/backup/be_thread.cc
sql/backup/data_backup.cc
sql/backup/image_info.cc
sql/backup/image_info.h
sql/backup/kernel.cc
sql/backup/logger.cc
sql/backup/logger.h
sql/backup/stream.cc
sql/backup/stream.h
sql/backup/stream_v1.c
sql/backup/stream_v1.h
sql/backup/stream_v1_services.h
sql/backup/stream_v1_transport.c
sql/debug_sync.cc
sql/debug_sync.h
sql/event_data_objects.cc
sql/handler.cc
sql/item_xmlfunc.cc
sql/lex.h
sql/log.cc
sql/log_event.cc
sql/mdl.cc
sql/mysql_priv.h
sql/mysqld.cc
sql/rpl_handler.cc
sql/rpl_injector.cc
sql/rpl_mi.cc
sql/rpl_mi.h
sql/rpl_rli.cc
sql/rpl_rli.h
sql/scheduler.cc
sql/set_var.cc
sql/share/errmsg.txt
sql/si_objects.cc
sql/si_objects.h
sql/slave.cc
sql/slave.h
sql/sql_acl.cc
sql/sql_acl.h
sql/sql_base.cc
sql/sql_binlog.cc
sql/sql_class.cc
sql/sql_class.h
sql/sql_lex.cc
sql/sql_parse.cc
sql/sql_partition.cc
sql/sql_prepare.cc
sql/sql_repl.cc
sql/sql_servers.cc
sql/sql_table.cc
sql/sql_view.cc
sql/sql_yacc.yy
sql/table.h
sql/transaction.cc
storage/archive/CMakeLists.txt
storage/falcon/Interlock.h
storage/falcon/plug.in
storage/myisam/CMakeLists.txt
storage/myisam/mi_close.c
storage/myisam/mi_examine_log.c
storage/myisam/mi_locking.c
storage/myisam/mi_log.c
storage/myisam/myisamlog.c
storage/myisammrg/ha_myisammrg.cc
support-files/my-huge.cnf.sh
support-files/my-innodb-heavy-4G.cnf.sh
support-files/my-large.cnf.sh
support-files/my-medium.cnf.sh
support-files/my-small.cnf.sh
support-files/mysql.spec.sh
mysql-test/suite/backup/r/backup_bml.result
mysql-test/suite/backup/r/backup_securebackup.result
mysql-test/suite/backup/t/backup_bml.test
mysql-test/suite/backup/t/backup_securebackup-master.opt
mysql-test/suite/backup/t/backup_securebackup.test
mysql-test/suite/backup_ptr/t/backup_ptr.test
mysql-test/suite/backup_ptr/t/backup_ptr_commits.test
mysql-test/suite/backup_ptr/t/backup_ptr_objects.test
mysql-test/suite/backup_engines/include/not_falcon.inc
mysql-test/suite/backup_engines/include/not_innodb.inc
mysql-test/suite/backup_engines/include/not_memory.inc
mysql-test/suite/backup_engines/include/not_myisam.inc
mysql-test/suite/backup/r/backup_functions.result
mysql-test/suite/backup_ptr/r/backup_ptr_commits.result
mysql-test/suite/backup/t/backup_functions.test
mysql-test/suite/backup/t/backup_online_testing.test
sql/bml.cc
sql/bml.h
=== modified file 'mysql-test/suite/sys_vars/r/binlog_cache_size_basic_64.result'
--- a/mysql-test/suite/sys_vars/r/binlog_cache_size_basic_64.result 2008-08-27 12:49:58 +0000
+++ b/mysql-test/suite/sys_vars/r/binlog_cache_size_basic_64.result 2009-04-01 09:56:08 +0000
@@ -44,7 +44,7 @@ SET @@global.binlog_cache_size = 10000.0
ERROR 42000: Incorrect argument type to variable 'binlog_cache_size'
SET @@global.binlog_cache_size = -1024;
Warnings:
-Warning 1292 Truncated incorrect binlog_cache_size value: '0'
+Warning 1292 Truncated incorrect binlog_cache_size value: '-1024'
SELECT @@global.binlog_cache_size;
@@global.binlog_cache_size
4096
=== modified file 'mysql-test/suite/sys_vars/r/bulk_insert_buffer_size_basic_64.result'
--- a/mysql-test/suite/sys_vars/r/bulk_insert_buffer_size_basic_64.result 2008-08-27 12:49:58 +0000
+++ b/mysql-test/suite/sys_vars/r/bulk_insert_buffer_size_basic_64.result 2009-04-01 09:56:08 +0000
@@ -66,6 +66,8 @@ SELECT @@global.bulk_insert_buffer_size;
@@global.bulk_insert_buffer_size
42949672950
SET @@global.bulk_insert_buffer_size = -1024;
+Warnings:
+Warning 1292 Truncated incorrect bulk_insert_buffer_size value: '-1024'
SELECT @@global.bulk_insert_buffer_size;
@@global.bulk_insert_buffer_size
0
@@ -80,6 +82,8 @@ SELECT @@session.bulk_insert_buffer_size
@@session.bulk_insert_buffer_size
42949672950
SET @@session.bulk_insert_buffer_size = -2;
+Warnings:
+Warning 1292 Truncated incorrect bulk_insert_buffer_size value: '-2'
SELECT @@session.bulk_insert_buffer_size;
@@session.bulk_insert_buffer_size
0
=== modified file 'mysql-test/suite/sys_vars/r/delayed_insert_limit_basic_64.result'
--- a/mysql-test/suite/sys_vars/r/delayed_insert_limit_basic_64.result 2008-08-27 12:49:58 +0000
+++ b/mysql-test/suite/sys_vars/r/delayed_insert_limit_basic_64.result 2009-04-01 09:56:08 +0000
@@ -35,7 +35,7 @@ SELECT @@global.delayed_insert_limit;
1
SET @@global.delayed_insert_limit = -1024;
Warnings:
-Warning 1292 Truncated incorrect delayed_insert_limit value: '0'
+Warning 1292 Truncated incorrect delayed_insert_limit value: '-1024'
SELECT @@global.delayed_insert_limit;
@@global.delayed_insert_limit
1
=== modified file 'mysql-test/suite/sys_vars/r/delayed_queue_size_basic_64.result'
--- a/mysql-test/suite/sys_vars/r/delayed_queue_size_basic_64.result 2008-08-27 12:49:58 +0000
+++ b/mysql-test/suite/sys_vars/r/delayed_queue_size_basic_64.result 2009-04-01 09:56:08 +0000
@@ -35,7 +35,7 @@ SELECT @@global.delayed_queue_size;
1
SET @@global.delayed_queue_size = -1024;
Warnings:
-Warning 1292 Truncated incorrect delayed_queue_size value: '0'
+Warning 1292 Truncated incorrect delayed_queue_size value: '-1024'
SELECT @@global.delayed_queue_size;
@@global.delayed_queue_size
1
=== modified file 'mysql-test/suite/sys_vars/r/join_buffer_size_basic_64.result'
--- a/mysql-test/suite/sys_vars/r/join_buffer_size_basic_64.result 2009-01-30 10:46:17 +0000
+++ b/mysql-test/suite/sys_vars/r/join_buffer_size_basic_64.result 2009-04-01 09:56:08 +0000
@@ -66,7 +66,7 @@ SELECT @@global.join_buffer_size=164 OR
1
SET @@global.join_buffer_size = -1024;
Warnings:
-Warning 1292 Truncated incorrect join_buffer_size value: '0'
+Warning 1292 Truncated incorrect join_buffer_size value: '-1024'
SELECT @@global.join_buffer_size;
@@global.join_buffer_size
164
@@ -99,7 +99,7 @@ SELECT @@session.join_buffer_size=164 O
1
SET @@session.join_buffer_size = -2;
Warnings:
-Warning 1292 Truncated incorrect join_buffer_size value: '0'
+Warning 1292 Truncated incorrect join_buffer_size value: '-2'
SELECT @@session.join_buffer_size=164 OR @@session.join_buffer_size= 8228;
@@session.join_buffer_size=164 OR @@session.join_buffer_size= 8228
1
=== modified file 'mysql-test/suite/sys_vars/r/key_buffer_size_basic_64.result'
--- a/mysql-test/suite/sys_vars/r/key_buffer_size_basic_64.result 2009-01-30 14:13:39 +0000
+++ b/mysql-test/suite/sys_vars/r/key_buffer_size_basic_64.result 2009-04-01 09:56:08 +0000
@@ -17,8 +17,6 @@ SELECT @@global.key_buffer_size BETWEEN
@@global.key_buffer_size BETWEEN 8 AND 36
1
SET @@global.key_buffer_size = 1800;
-Warnings:
-Warning 1292 Truncated incorrect key_buffer_size value: '1800'
SELECT @@global.key_buffer_size BETWEEN 8 AND 36;
@@global.key_buffer_size BETWEEN 8 AND 36
1
=== modified file 'mysql-test/suite/sys_vars/r/log_warnings_basic_64.result'
--- a/mysql-test/suite/sys_vars/r/log_warnings_basic_64.result 2008-08-27 12:49:58 +0000
+++ b/mysql-test/suite/sys_vars/r/log_warnings_basic_64.result 2009-04-01 09:56:08 +0000
@@ -74,6 +74,8 @@ SELECT @@global.log_warnings;
@@global.log_warnings
100000000000
SET @@global.log_warnings = -1024;
+Warnings:
+Warning 1292 Truncated incorrect log_warnings value: '-1024'
SELECT @@global.log_warnings;
@@global.log_warnings
0
@@ -92,6 +94,8 @@ SELECT @@session.log_warnings;
@@session.log_warnings
100000000000
SET @@session.log_warnings = -2;
+Warnings:
+Warning 1292 Truncated incorrect log_warnings value: '-2'
SELECT @@session.log_warnings;
@@session.log_warnings
0
=== modified file 'mysql-test/suite/sys_vars/r/max_binlog_cache_size_basic_64.result'
--- a/mysql-test/suite/sys_vars/r/max_binlog_cache_size_basic_64.result 2009-01-30 10:46:17 +0000
+++ b/mysql-test/suite/sys_vars/r/max_binlog_cache_size_basic_64.result 2009-04-01 09:56:08 +0000
@@ -39,7 +39,7 @@ SELECT @@global.max_binlog_cache_size;
'#--------------------FN_DYNVARS_072_04-------------------------#'
SET @@global.max_binlog_cache_size = -1;
Warnings:
-Warning 1292 Truncated incorrect max_binlog_cache_size value: '0'
+Warning 1292 Truncated incorrect max_binlog_cache_size value: '-1'
SELECT @@global.max_binlog_cache_size;
@@global.max_binlog_cache_size
4096
@@ -54,7 +54,7 @@ SELECT @@global.max_binlog_cache_size;
99999997952
SET @@global.max_binlog_cache_size = -1024;
Warnings:
-Warning 1292 Truncated incorrect max_binlog_cache_size value: '0'
+Warning 1292 Truncated incorrect max_binlog_cache_size value: '-1024'
SELECT @@global.max_binlog_cache_size;
@@global.max_binlog_cache_size
4096
=== modified file 'mysql-test/suite/sys_vars/r/max_connect_errors_basic_64.result'
--- a/mysql-test/suite/sys_vars/r/max_connect_errors_basic_64.result 2008-08-27 12:49:58 +0000
+++ b/mysql-test/suite/sys_vars/r/max_connect_errors_basic_64.result 2009-04-01 09:56:08 +0000
@@ -39,7 +39,7 @@ SELECT @@global.max_connect_errors;
'#--------------------FN_DYNVARS_073_04-------------------------#'
SET @@global.max_connect_errors = -1;
Warnings:
-Warning 1292 Truncated incorrect max_connect_errors value: '0'
+Warning 1292 Truncated incorrect max_connect_errors value: '-1'
SELECT @@global.max_connect_errors;
@@global.max_connect_errors
1
@@ -54,7 +54,7 @@ SELECT @@global.max_connect_errors;
100000000000
SET @@global.max_connect_errors = -1024;
Warnings:
-Warning 1292 Truncated incorrect max_connect_errors value: '0'
+Warning 1292 Truncated incorrect max_connect_errors value: '-1024'
SELECT @@global.max_connect_errors;
@@global.max_connect_errors
1
=== modified file 'mysql-test/suite/sys_vars/r/max_heap_table_size_basic_64.result'
--- a/mysql-test/suite/sys_vars/r/max_heap_table_size_basic_64.result 2008-08-27 12:49:58 +0000
+++ b/mysql-test/suite/sys_vars/r/max_heap_table_size_basic_64.result 2009-04-01 09:56:08 +0000
@@ -73,13 +73,13 @@ SELECT @@session.max_heap_table_size;
'#------------------FN_DYNVARS_077_05-----------------------#'
SET @@global.max_heap_table_size = -1;
Warnings:
-Warning 1292 Truncated incorrect max_heap_table_size value: '0'
+Warning 1292 Truncated incorrect max_heap_table_size value: '-1'
SELECT @@global.max_heap_table_size;
@@global.max_heap_table_size
16384
SET @@global.max_heap_table_size = -1024;
Warnings:
-Warning 1292 Truncated incorrect max_heap_table_size value: '0'
+Warning 1292 Truncated incorrect max_heap_table_size value: '-1024'
SELECT @@global.max_heap_table_size;
@@global.max_heap_table_size
16384
@@ -111,7 +111,7 @@ SELECT @@global.max_heap_table_size;
4294967296
SET @@session.max_heap_table_size = -1;
Warnings:
-Warning 1292 Truncated incorrect max_heap_table_size value: '0'
+Warning 1292 Truncated incorrect max_heap_table_size value: '-1'
SELECT @@session.max_heap_table_size;
@@session.max_heap_table_size
16384
=== modified file 'mysql-test/suite/sys_vars/r/max_seeks_for_key_basic_64.result'
--- a/mysql-test/suite/sys_vars/r/max_seeks_for_key_basic_64.result 2008-08-27 12:49:58 +0000
+++ b/mysql-test/suite/sys_vars/r/max_seeks_for_key_basic_64.result 2009-04-01 09:56:08 +0000
@@ -77,7 +77,7 @@ SELECT @@global.max_seeks_for_key;
1
SET @@global.max_seeks_for_key = -1024;
Warnings:
-Warning 1292 Truncated incorrect max_seeks_for_key value: '0'
+Warning 1292 Truncated incorrect max_seeks_for_key value: '-1024'
SELECT @@global.max_seeks_for_key;
@@global.max_seeks_for_key
1
@@ -103,7 +103,7 @@ SELECT @@session.max_seeks_for_key;
1
SET @@session.max_seeks_for_key = -2;
Warnings:
-Warning 1292 Truncated incorrect max_seeks_for_key value: '0'
+Warning 1292 Truncated incorrect max_seeks_for_key value: '-2'
SELECT @@session.max_seeks_for_key;
@@session.max_seeks_for_key
1
=== modified file 'mysql-test/suite/sys_vars/r/max_tmp_tables_basic_64.result'
--- a/mysql-test/suite/sys_vars/r/max_tmp_tables_basic_64.result 2008-08-27 12:49:58 +0000
+++ b/mysql-test/suite/sys_vars/r/max_tmp_tables_basic_64.result 2009-04-01 09:56:08 +0000
@@ -71,7 +71,7 @@ SELECT @@session.max_tmp_tables;
'#------------------FN_DYNVARS_086_05-----------------------#'
SET @@global.max_tmp_tables = -1024;
Warnings:
-Warning 1292 Truncated incorrect max_tmp_tables value: '0'
+Warning 1292 Truncated incorrect max_tmp_tables value: '-1024'
SELECT @@global.max_tmp_tables;
@@global.max_tmp_tables
1
@@ -81,7 +81,7 @@ SELECT @@global.max_tmp_tables;
4294967296
SET @@global.max_tmp_tables = -1;
Warnings:
-Warning 1292 Truncated incorrect max_tmp_tables value: '0'
+Warning 1292 Truncated incorrect max_tmp_tables value: '-1'
SELECT @@global.max_tmp_tables;
@@global.max_tmp_tables
1
@@ -105,7 +105,7 @@ SELECT @@session.max_tmp_tables;
4294967296
SET @@session.max_tmp_tables = -1;
Warnings:
-Warning 1292 Truncated incorrect max_tmp_tables value: '0'
+Warning 1292 Truncated incorrect max_tmp_tables value: '-1'
SELECT @@session.max_tmp_tables;
@@session.max_tmp_tables
1
@@ -115,7 +115,7 @@ SELECT @@session.max_tmp_tables;
429496729500
SET @@session.max_tmp_tables = -001;
Warnings:
-Warning 1292 Truncated incorrect max_tmp_tables value: '0'
+Warning 1292 Truncated incorrect max_tmp_tables value: '-1'
SELECT @@session.max_tmp_tables;
@@session.max_tmp_tables
1
=== modified file 'mysql-test/suite/sys_vars/r/max_write_lock_count_basic_64.result'
--- a/mysql-test/suite/sys_vars/r/max_write_lock_count_basic_64.result 2008-08-27 12:49:58 +0000
+++ b/mysql-test/suite/sys_vars/r/max_write_lock_count_basic_64.result 2009-04-01 09:56:08 +0000
@@ -37,7 +37,7 @@ SELECT @@global.max_write_lock_count;
'#------------------FN_DYNVARS_088_04-----------------------#'
SET @@global.max_write_lock_count = -1024;
Warnings:
-Warning 1292 Truncated incorrect max_write_lock_count value: '0'
+Warning 1292 Truncated incorrect max_write_lock_count value: '-1024'
SELECT @@global.max_write_lock_count;
@@global.max_write_lock_count
1
@@ -47,7 +47,7 @@ SELECT @@global.max_write_lock_count;
4294967296
SET @@global.max_write_lock_count = -1;
Warnings:
-Warning 1292 Truncated incorrect max_write_lock_count value: '0'
+Warning 1292 Truncated incorrect max_write_lock_count value: '-1'
SELECT @@global.max_write_lock_count;
@@global.max_write_lock_count
1
=== modified file 'mysql-test/suite/sys_vars/r/min_examined_row_limit_basic_64.result'
--- a/mysql-test/suite/sys_vars/r/min_examined_row_limit_basic_64.result 2008-08-27 12:49:58 +0000
+++ b/mysql-test/suite/sys_vars/r/min_examined_row_limit_basic_64.result 2009-04-01 09:56:08 +0000
@@ -82,6 +82,8 @@ SELECT @@global.min_examined_row_limit;
@@global.min_examined_row_limit
429496726
SET @@global.min_examined_row_limit = -1024;
+Warnings:
+Warning 1292 Truncated incorrect min_examined_row_limit value: '-1024'
SELECT @@global.min_examined_row_limit;
@@global.min_examined_row_limit
0
@@ -104,6 +106,8 @@ SELECT @@session.min_examined_row_limit;
@@session.min_examined_row_limit
4294967296
SET @@session.min_examined_row_limit = -1;
+Warnings:
+Warning 1292 Truncated incorrect min_examined_row_limit value: '-1'
SELECT @@session.min_examined_row_limit;
@@session.min_examined_row_limit
0
=== modified file 'mysql-test/suite/sys_vars/r/myisam_max_sort_file_size_basic_64.result'
--- a/mysql-test/suite/sys_vars/r/myisam_max_sort_file_size_basic_64.result 2009-01-30 10:46:17 +0000
+++ b/mysql-test/suite/sys_vars/r/myisam_max_sort_file_size_basic_64.result 2009-04-01 09:56:08 +0000
@@ -48,14 +48,20 @@ SET @@local.myisam_max_sort_file_size =
ERROR HY000: Variable 'myisam_max_sort_file_size' is a GLOBAL variable and should be set with SET GLOBAL
'#------------------FN_DYNVARS_094_05-----------------------#'
SET @@global.myisam_max_sort_file_size = -1;
+Warnings:
+Warning 1292 Truncated incorrect myisam_max_sort_file_size value: '-1'
SELECT @@global.myisam_max_sort_file_size;
@@global.myisam_max_sort_file_size
0
SET @@global.myisam_max_sort_file_size = -2147483648;
+Warnings:
+Warning 1292 Truncated incorrect myisam_max_sort_file_size value: '-2147483648'
SELECT @@global.myisam_max_sort_file_size;
@@global.myisam_max_sort_file_size
0
SET @@global.myisam_max_sort_file_size = -2147483649;
+Warnings:
+Warning 1292 Truncated incorrect myisam_max_sort_file_size value: '-2147483649'
SELECT @@global.myisam_max_sort_file_size;
@@global.myisam_max_sort_file_size
0
=== modified file 'mysql-test/suite/sys_vars/r/myisam_repair_threads_basic_64.result'
--- a/mysql-test/suite/sys_vars/r/myisam_repair_threads_basic_64.result 2008-08-27 12:49:58 +0000
+++ b/mysql-test/suite/sys_vars/r/myisam_repair_threads_basic_64.result 2009-04-01 09:56:08 +0000
@@ -61,7 +61,7 @@ SELECT @@global.myisam_repair_threads ;
1
SET @@global.myisam_repair_threads = -1024;
Warnings:
-Warning 1292 Truncated incorrect myisam_repair_threads value: '0'
+Warning 1292 Truncated incorrect myisam_repair_threads value: '-1024'
SELECT @@global.myisam_repair_threads ;
@@global.myisam_repair_threads
1
@@ -102,7 +102,7 @@ SELECT @@session.myisam_repair_threads ;
1
SET @@session.myisam_repair_threads = -2;
Warnings:
-Warning 1292 Truncated incorrect myisam_repair_threads value: '0'
+Warning 1292 Truncated incorrect myisam_repair_threads value: '-2'
SELECT @@session.myisam_repair_threads ;
@@session.myisam_repair_threads
1
=== modified file 'mysql-test/suite/sys_vars/r/myisam_sort_buffer_size_basic_64.result'
--- a/mysql-test/suite/sys_vars/r/myisam_sort_buffer_size_basic_64.result 2008-08-27 12:49:58 +0000
+++ b/mysql-test/suite/sys_vars/r/myisam_sort_buffer_size_basic_64.result 2009-04-01 09:56:08 +0000
@@ -61,7 +61,7 @@ SELECT @@global.myisam_sort_buffer_size
4
SET @@global.myisam_sort_buffer_size = -1024;
Warnings:
-Warning 1292 Truncated incorrect myisam_sort_buffer_size value: '0'
+Warning 1292 Truncated incorrect myisam_sort_buffer_size value: '-1024'
SELECT @@global.myisam_sort_buffer_size ;
@@global.myisam_sort_buffer_size
4
@@ -102,7 +102,7 @@ SELECT @@session.myisam_sort_buffer_size
4
SET @@session.myisam_sort_buffer_size = -2;
Warnings:
-Warning 1292 Truncated incorrect myisam_sort_buffer_size value: '0'
+Warning 1292 Truncated incorrect myisam_sort_buffer_size value: '-2'
SELECT @@session.myisam_sort_buffer_size ;
@@session.myisam_sort_buffer_size
4
=== modified file 'mysql-test/suite/sys_vars/r/net_retry_count_basic_64.result'
--- a/mysql-test/suite/sys_vars/r/net_retry_count_basic_64.result 2008-08-27 12:49:58 +0000
+++ b/mysql-test/suite/sys_vars/r/net_retry_count_basic_64.result 2009-04-01 09:56:08 +0000
@@ -77,7 +77,7 @@ SELECT @@global.net_retry_count;
1
SET @@global.net_retry_count = -1024;
Warnings:
-Warning 1292 Truncated incorrect net_retry_count value: '0'
+Warning 1292 Truncated incorrect net_retry_count value: '-1024'
SELECT @@global.net_retry_count;
@@global.net_retry_count
1
@@ -107,7 +107,7 @@ SELECT @@session.net_retry_count;
1
SET @@session.net_retry_count = -2;
Warnings:
-Warning 1292 Truncated incorrect net_retry_count value: '0'
+Warning 1292 Truncated incorrect net_retry_count value: '-2'
SELECT @@session.net_retry_count;
@@session.net_retry_count
1
=== modified file 'mysql-test/suite/sys_vars/r/query_alloc_block_size_basic_64.result'
--- a/mysql-test/suite/sys_vars/r/query_alloc_block_size_basic_64.result 2008-08-27 12:49:58 +0000
+++ b/mysql-test/suite/sys_vars/r/query_alloc_block_size_basic_64.result 2009-04-01 09:56:08 +0000
@@ -57,14 +57,6 @@ SET @@session.query_alloc_block_size = 1
SELECT @@session.query_alloc_block_size;
@@session.query_alloc_block_size
1024
-SET @@session.query_alloc_block_size = 4294967295;
-SELECT @@session.query_alloc_block_size;
-@@session.query_alloc_block_size
-4294966272
-SET @@session.query_alloc_block_size = 4294967294;
-SELECT @@session.query_alloc_block_size;
-@@session.query_alloc_block_size
-4294966272
SET @@session.query_alloc_block_size = 655536;
SELECT @@session.query_alloc_block_size;
@@session.query_alloc_block_size
@@ -78,7 +70,7 @@ SELECT @@global.query_alloc_block_size;
1024
SET @@global.query_alloc_block_size = -1;
Warnings:
-Warning 1292 Truncated incorrect query_alloc_block_size value: '0'
+Warning 1292 Truncated incorrect query_alloc_block_size value: '-1'
SELECT @@global.query_alloc_block_size;
@@global.query_alloc_block_size
1024
@@ -110,7 +102,7 @@ SELECT @@session.query_alloc_block_size;
1024
SET @@session.query_alloc_block_size = -2;
Warnings:
-Warning 1292 Truncated incorrect query_alloc_block_size value: '0'
+Warning 1292 Truncated incorrect query_alloc_block_size value: '-2'
SELECT @@session.query_alloc_block_size;
@@session.query_alloc_block_size
1024
@@ -122,16 +114,12 @@ Warning 1292 Truncated incorrect query_a
SELECT @@session.query_alloc_block_size;
@@session.query_alloc_block_size
1024
-SET @@session.query_alloc_block_size = 4294967296;
-SELECT @@session.query_alloc_block_size;
-@@session.query_alloc_block_size
-4294967296
'Bug # 34837: Errors are not coming on assigning invalid values to variable';
SET @@session.query_alloc_block_size = test;
ERROR 42000: Incorrect argument type to variable 'query_alloc_block_size'
SELECT @@session.query_alloc_block_size;
@@session.query_alloc_block_size
-4294967296
+1024
'#------------------FN_DYNVARS_130_06-----------------------#'
'Bug# 34877: OutOFMemeory errors are coming if we dont assign these values to variable before comparision statement';
SET @@global.query_alloc_block_size = 1;
=== modified file 'mysql-test/suite/sys_vars/r/query_cache_limit_basic_64.result'
--- a/mysql-test/suite/sys_vars/r/query_cache_limit_basic_64.result 2008-08-27 12:49:58 +0000
+++ b/mysql-test/suite/sys_vars/r/query_cache_limit_basic_64.result 2009-04-01 09:56:08 +0000
@@ -32,6 +32,8 @@ SELECT @@global.query_cache_limit;
1048575
'#--------------------FN_DYNVARS_131_04-------------------------#'
SET @@global.query_cache_limit = -1;
+Warnings:
+Warning 1292 Truncated incorrect query_cache_limit value: '-1'
SELECT @@global.query_cache_limit;
@@global.query_cache_limit
0
@@ -49,6 +51,8 @@ SELECT @@global.query_cache_limit;
@@global.query_cache_limit
10240022115
SET @@global.query_cache_limit = -1024;
+Warnings:
+Warning 1292 Truncated incorrect query_cache_limit value: '-1024'
SELECT @@global.query_cache_limit;
@@global.query_cache_limit
0
=== modified file 'mysql-test/suite/sys_vars/r/query_cache_min_res_unit_basic_64.result'
--- a/mysql-test/suite/sys_vars/r/query_cache_min_res_unit_basic_64.result 2008-08-27 12:49:58 +0000
+++ b/mysql-test/suite/sys_vars/r/query_cache_min_res_unit_basic_64.result 2009-04-01 09:56:08 +0000
@@ -42,6 +42,8 @@ SELECT @@global.query_cache_min_res_unit
1048576
'#--------------------FN_DYNVARS_132_04-------------------------#'
SET @@global.query_cache_min_res_unit = -1;
+Warnings:
+Warning 1292 Truncated incorrect query_cache_min_res_unit value: '-1'
SELECT @@global.query_cache_min_res_unit;
@@global.query_cache_min_res_unit
512
@@ -59,6 +61,8 @@ SELECT @@global.query_cache_min_res_unit
@@global.query_cache_min_res_unit
512
SET @@global.query_cache_min_res_unit = -1024;
+Warnings:
+Warning 1292 Truncated incorrect query_cache_min_res_unit value: '-1024'
SELECT @@global.query_cache_min_res_unit;
@@global.query_cache_min_res_unit
512
=== modified file 'mysql-test/suite/sys_vars/r/query_prealloc_size_basic_64.result'
--- a/mysql-test/suite/sys_vars/r/query_prealloc_size_basic_64.result 2008-08-27 12:49:58 +0000
+++ b/mysql-test/suite/sys_vars/r/query_prealloc_size_basic_64.result 2009-04-01 09:56:08 +0000
@@ -35,10 +35,6 @@ SET @@global.query_prealloc_size = 819
SELECT @@global.query_prealloc_size ;
@@global.query_prealloc_size
8192
-SET @@global.query_prealloc_size = 4294967295;
-SELECT @@global.query_prealloc_size ;
-@@global.query_prealloc_size
-4294966272
SET @@global.query_prealloc_size = 655354;
SELECT @@global.query_prealloc_size ;
@@global.query_prealloc_size
@@ -48,10 +44,6 @@ SET @@session.query_prealloc_size = 81
SELECT @@session.query_prealloc_size ;
@@session.query_prealloc_size
8192
-SET @@session.query_prealloc_size = 4294967295;
-SELECT @@session.query_prealloc_size ;
-@@session.query_prealloc_size
-4294966272
SET @@session.query_prealloc_size = 655345;
SELECT @@session.query_prealloc_size ;
@@session.query_prealloc_size
@@ -63,48 +55,32 @@ Warning 1292 Truncated incorrect query_p
SELECT @@global.query_prealloc_size ;
@@global.query_prealloc_size
8192
-SET @@global.query_prealloc_size = -1024;
-Warnings:
-Warning 1292 Truncated incorrect query_prealloc_size value: '0'
-SELECT @@global.query_prealloc_size ;
-@@global.query_prealloc_size
-8192
-SET @@global.query_prealloc_size = 429496729533;
-SELECT @@global.query_prealloc_size ;
-@@global.query_prealloc_size
-429496728576
SET @@global.query_prealloc_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.query_prealloc_size ;
@@global.query_prealloc_size
-429496728576
+8192
SET @@global.query_prealloc_size = test;
ERROR 42000: Incorrect argument type to variable 'query_prealloc_size'
SELECT @@global.query_prealloc_size ;
@@global.query_prealloc_size
-429496728576
+8192
SET @@global.query_prealloc_size = "test";
ERROR 42000: Incorrect argument type to variable 'query_prealloc_size'
SELECT @@global.query_prealloc_size ;
@@global.query_prealloc_size
-429496728576
+8192
SET @@global.query_prealloc_size = 'test';
ERROR 42000: Incorrect argument type to variable 'query_prealloc_size'
SELECT @@global.query_prealloc_size ;
@@global.query_prealloc_size
-429496728576
+8192
SET @@global.query_prealloc_size = ON;
ERROR 42000: Incorrect argument type to variable 'query_prealloc_size'
SELECT @@global.query_prealloc_size ;
@@global.query_prealloc_size
-429496728576
-SET @@session.query_prealloc_size = 0;
-Warnings:
-Warning 1292 Truncated incorrect query_prealloc_size value: '0'
-SELECT @@session.query_prealloc_size ;
-@@session.query_prealloc_size
8192
-SET @@session.query_prealloc_size = -2;
+SET @@session.query_prealloc_size = 0;
Warnings:
Warning 1292 Truncated incorrect query_prealloc_size value: '0'
SELECT @@session.query_prealloc_size ;
=== modified file 'mysql-test/suite/sys_vars/r/range_alloc_block_size_basic_64.result'
--- a/mysql-test/suite/sys_vars/r/range_alloc_block_size_basic_64.result 2008-08-27 12:49:58 +0000
+++ b/mysql-test/suite/sys_vars/r/range_alloc_block_size_basic_64.result 2009-04-01 09:56:08 +0000
@@ -71,7 +71,7 @@ SELECT @@global.range_alloc_block_size;
4096
SET @@global.range_alloc_block_size = -1024;
Warnings:
-Warning 1292 Truncated incorrect range_alloc_block_size value: '0'
+Warning 1292 Truncated incorrect range_alloc_block_size value: '-1024'
SELECT @@global.range_alloc_block_size;
@@global.range_alloc_block_size
4096
@@ -97,7 +97,7 @@ SELECT @@session.range_alloc_block_size;
4096
SET @@session.range_alloc_block_size = -2;
Warnings:
-Warning 1292 Truncated incorrect range_alloc_block_size value: '0'
+Warning 1292 Truncated incorrect range_alloc_block_size value: '-2'
SELECT @@session.range_alloc_block_size;
@@session.range_alloc_block_size
4096
=== modified file 'mysql-test/suite/sys_vars/r/rpl_recovery_rank_basic_64.result'
--- a/mysql-test/suite/sys_vars/r/rpl_recovery_rank_basic_64.result 2008-08-27 12:49:58 +0000
+++ b/mysql-test/suite/sys_vars/r/rpl_recovery_rank_basic_64.result 2009-04-01 09:56:08 +0000
@@ -45,14 +45,20 @@ SET @@local.rpl_recovery_rank = 4;
ERROR HY000: Variable 'rpl_recovery_rank' is a GLOBAL variable and should be set with SET GLOBAL
'#------------------FN_DYNVARS_142_04-----------------------#'
SET @@global.rpl_recovery_rank = -1;
+Warnings:
+Warning 1292 Truncated incorrect rpl_recovery_rank value: '-1'
SELECT @@global.rpl_recovery_rank;
@@global.rpl_recovery_rank
0
SET @@global.rpl_recovery_rank = -2147483648;
+Warnings:
+Warning 1292 Truncated incorrect rpl_recovery_rank value: '-2147483648'
SELECT @@global.rpl_recovery_rank;
@@global.rpl_recovery_rank
0
SET @@global.rpl_recovery_rank = -2147483649;
+Warnings:
+Warning 1292 Truncated incorrect rpl_recovery_rank value: '-2147483649'
SELECT @@global.rpl_recovery_rank;
@@global.rpl_recovery_rank
0
=== modified file 'mysql-test/suite/sys_vars/r/slave_transaction_retries_basic_64.result'
--- a/mysql-test/suite/sys_vars/r/slave_transaction_retries_basic_64.result 2008-08-27 12:49:58 +0000
+++ b/mysql-test/suite/sys_vars/r/slave_transaction_retries_basic_64.result 2009-04-01 09:56:08 +0000
@@ -55,6 +55,8 @@ SET @@local.slave_transaction_retries =
ERROR HY000: Variable 'slave_transaction_retries' is a GLOBAL variable and should be set with SET GLOBAL
'#------------------FN_DYNVARS_149_05-----------------------#'
SET @@global.slave_transaction_retries = -1;
+Warnings:
+Warning 1292 Truncated incorrect slave_transaction_retries value: '-1'
SELECT @@global.slave_transaction_retries;
@@global.slave_transaction_retries
0
=== modified file 'mysql-test/suite/sys_vars/r/sync_binlog_basic_64.result'
--- a/mysql-test/suite/sys_vars/r/sync_binlog_basic_64.result 2008-08-27 12:49:58 +0000
+++ b/mysql-test/suite/sys_vars/r/sync_binlog_basic_64.result 2009-04-01 09:56:08 +0000
@@ -36,47 +36,57 @@ SELECT @@global.sync_binlog;
65536
'#--------------------FN_DYNVARS_168_04-------------------------#'
SET @@global.sync_binlog = -1;
+Warnings:
+Warning 1292 Truncated incorrect sync_binlog value: '-1'
SELECT @@global.sync_binlog;
@@global.sync_binlog
0
SET @@global.sync_binlog = 4294967296;
+Warnings:
+Warning 1292 Truncated incorrect sync_binlog value: '4294967296'
SELECT @@global.sync_binlog;
@@global.sync_binlog
-4294967296
+4294967295
SET @@global.sync_binlog = 10240022115;
+Warnings:
+Warning 1292 Truncated incorrect sync_binlog value: '10240022115'
SELECT @@global.sync_binlog;
@@global.sync_binlog
-10240022115
+4294967295
SET @@global.sync_binlog = 10000.01;
ERROR 42000: Incorrect argument type to variable 'sync_binlog'
SELECT @@global.sync_binlog;
@@global.sync_binlog
-10240022115
+4294967295
SET @@global.sync_binlog = -1024;
+Warnings:
+Warning 1292 Truncated incorrect sync_binlog value: '-1024'
SELECT @@global.sync_binlog;
@@global.sync_binlog
0
SET @@global.sync_binlog = 42949672950;
+Warnings:
+Warning 1292 Truncated incorrect sync_binlog value: '42949672950'
SELECT @@global.sync_binlog;
@@global.sync_binlog
-42949672950
+4294967295
'Bug # 34837: Errors are not coming on assigning invalid values to variable';
SET @@global.sync_binlog = ON;
ERROR 42000: Incorrect argument type to variable 'sync_binlog'
SELECT @@global.sync_binlog;
@@global.sync_binlog
-42949672950
+4294967295
SET @@global.sync_binlog = 'test';
ERROR 42000: Incorrect argument type to variable 'sync_binlog'
SELECT @@global.sync_binlog;
@@global.sync_binlog
-42949672950
+4294967295
'#-------------------FN_DYNVARS_168_05----------------------------#'
SET @@session.sync_binlog = 0;
ERROR HY000: Variable 'sync_binlog' is a GLOBAL variable and should be set with SET GLOBAL
SELECT @@sync_binlog;
@@sync_binlog
-42949672950
+4294967295
'#----------------------FN_DYNVARS_168_06------------------------#'
SELECT @@global.sync_binlog = VARIABLE_VALUE
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
@@ -88,7 +98,7 @@ SET sync_binlog = 1;
ERROR HY000: Variable 'sync_binlog' is a GLOBAL variable and should be set with SET GLOBAL
SELECT @@sync_binlog;
@@sync_binlog
-42949672950
+4294967295
SET local.sync_binlog = 1;
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 'sync_binlog = 1' at line 1
SELECT local.sync_binlog;
=== modified file 'mysql-test/suite/sys_vars/r/tmp_table_size_basic.result'
--- a/mysql-test/suite/sys_vars/r/tmp_table_size_basic.result 2009-03-24 10:41:07 +0000
+++ b/mysql-test/suite/sys_vars/r/tmp_table_size_basic.result 2009-04-01 09:56:08 +0000
@@ -100,8 +100,6 @@ SELECT @@session.tmp_table_size;
SET @@session.tmp_table_size = "Test";
ERROR 42000: Incorrect argument type to variable 'tmp_table_size'
SET @@session.tmp_table_size = 12345678901;
-Warnings:
-Warning 1292 Truncated incorrect tmp_table_size value: '12345678901'
SELECT @@session.tmp_table_size IN (12345678901,4294967295);
@@session.tmp_table_size IN (12345678901,4294967295)
1
=== modified file 'mysql-test/suite/sys_vars/r/transaction_prealloc_size_basic_64.result'
--- a/mysql-test/suite/sys_vars/r/transaction_prealloc_size_basic_64.result 2008-08-27 12:49:58 +0000
+++ b/mysql-test/suite/sys_vars/r/transaction_prealloc_size_basic_64.result 2009-04-01 09:56:08 +0000
@@ -66,7 +66,7 @@ SELECT @@global.transaction_prealloc_siz
1024
SET @@global.transaction_prealloc_size = -1024;
Warnings:
-Warning 1292 Truncated incorrect transaction_prealloc_size value: '0'
+Warning 1292 Truncated incorrect transaction_prealloc_size value: '-1024'
SELECT @@global.transaction_prealloc_size;
@@global.transaction_prealloc_size
1024
=== modified file 'mysql-test/suite/sys_vars/r/wait_timeout_basic_64.result'
--- a/mysql-test/suite/sys_vars/r/wait_timeout_basic_64.result 2008-08-27 12:49:58 +0000
+++ b/mysql-test/suite/sys_vars/r/wait_timeout_basic_64.result 2009-04-01 09:56:08 +0000
@@ -44,7 +44,7 @@ Warnings:
Warning 1292 Truncated incorrect wait_timeout value: '0'
SET @@global.wait_timeout = -1024;
Warnings:
-Warning 1292 Truncated incorrect wait_timeout value: '0'
+Warning 1292 Truncated incorrect wait_timeout value: '-1024'
'Bug # 34837: Errors are not coming on assigning invalid values to variable';
SET @@global.wait_timeout = ON;
ERROR 42000: Incorrect argument type to variable 'wait_timeout'
=== modified file 'mysql-test/suite/sys_vars/t/disabled.def'
--- a/mysql-test/suite/sys_vars/t/disabled.def 2009-02-13 16:18:07 +0000
+++ b/mysql-test/suite/sys_vars/t/disabled.def 2009-04-01 09:56:08 +0000
@@ -9,12 +9,9 @@
# Do not use any TAB characters for whitespace.
#
##############################################################################
-rpl_recovery_rank_basic_64 : Bug#42838: sys_vars.rpl_recovery_rank_basic_64 is disabled
-query_alloc_block_size_basic_64 : Bug#42839: sys_vars.query_alloc_block_size_basic_64 is disabled
query_cache_size_basic_32 : Bug#36747: Allocating a large query cache is not deterministic
query_cache_size_basic_64 : Bug#36747: Allocating a large query cache is not deterministic
max_heap_table_size_basic_32 : Bug#36877: main.max_heap_table_size_basic_32 fails on some systems
-#query_cache_wlock_invalidate_func : Bug#37962: 2008-12-08 Test contains sleeps/race conditions
#thread_cache_size_func : Bug#40575: 2008-11-07 joro main.thread_cache_size_func fails in pushbuild when run with pool of threads
log_output_basic : Bug#40988: log_output_basic.test succeeded though syntactically false.
=== modified file 'mysql-test/suite/sys_vars/t/tmp_table_size_basic.test'
--- a/mysql-test/suite/sys_vars/t/tmp_table_size_basic.test 2008-12-10 09:02:11 +0000
+++ b/mysql-test/suite/sys_vars/t/tmp_table_size_basic.test 2009-04-01 09:56:08 +0000
@@ -133,7 +133,9 @@ SELECT @@session.tmp_table_size;
--Error ER_WRONG_TYPE_FOR_VAR
SET @@session.tmp_table_size = "Test";
+--disable_warnings
SET @@session.tmp_table_size = 12345678901;
+--enable_warnings
# With a 64 bit mysqld:12345678901,with a 32 bit mysqld: 4294967295
SELECT @@session.tmp_table_size IN (12345678901,4294967295);
Attachment: [text/bzr-bundle] bzr/horst@mysql.com-20090403091455-c102ze3200zjw096.bundle
| Thread |
|---|
| • bzr push into mysql-6.0-bugteam branch (horst:3166) | Horst Hunger | 3 Apr |
