diff options
Diffstat (limited to 'mysql-test/t/partition.test')
-rw-r--r-- | mysql-test/t/partition.test | 68 |
1 files changed, 0 insertions, 68 deletions
diff --git a/mysql-test/t/partition.test b/mysql-test/t/partition.test index 54687c94466..542a992bb0e 100644 --- a/mysql-test/t/partition.test +++ b/mysql-test/t/partition.test @@ -10,8 +10,6 @@ # --source include/have_partition.inc -SET @old_general_log= @@global.general_log; - --disable_warnings drop table if exists t1, t2; --enable_warnings @@ -1652,23 +1650,6 @@ insert into t values (1); drop table t; # -# Bug #27816: Log tables ran with partitions crashes the server when logging -# is enabled. -# - -USE mysql; -TRUNCATE TABLE general_log; -SET @old_general_log_state = @@global.general_log; -SET GLOBAL general_log = 0; -ALTER TABLE general_log ENGINE = MyISAM; ---error ER_WRONG_USAGE -ALTER TABLE general_log PARTITION BY RANGE (TO_DAYS(event_time)) - (PARTITION p0 VALUES LESS THAN (733144), PARTITION p1 VALUES LESS THAN (3000000)); -ALTER TABLE general_log ENGINE = CSV; -SET GLOBAL general_log = @old_general_log_state; -use test; - -# # Bug #27084 partitioning by list seems failing when using case # BUG #18198: Case no longer supported, test case removed # @@ -1998,53 +1979,4 @@ CREATE TABLE t1(id INT,KEY(id)) ENGINE=MYISAM DROP TABLE t1; SET SESSION SQL_MODE=DEFAULT; ---echo ---echo Bug#40281: partitioning the general log table crashes the server ---echo - ---echo --- set up partitioned log, and switch to it - -USE mysql; -SET GLOBAL general_log =0; -CREATE TABLE gl_partitioned LIKE general_log; -ALTER TABLE gl_partitioned ENGINE=myisam; -ALTER TABLE gl_partitioned PARTITION BY HASH (thread_id) PARTITIONS 10; -ALTER TABLE general_log RENAME TO gl_nonpartitioned; -ALTER TABLE gl_partitioned RENAME TO general_log; - -SELECT @@global.log_output INTO @old_glo; -SET GLOBAL log_output='table'; -SET GLOBAL general_log =1; - ---echo --- do some things to be logged to partitioned log, should fail -USE /* 1 */ test; - -CREATE TABLE t1 (i INT); - -connect (master,127.0.0.1,root,,test,$MASTER_MYPORT,); -connection master; -INSERT INTO t1 VALUES (1); -SELECT * FROM t1; -disconnect master; - -connection default; - -USE mysql; -SET GLOBAL general_log =0; -ALTER TABLE general_log RENAME TO gl_partitioned; -ALTER TABLE gl_nonpartitioned RENAME TO general_log; - ---echo --- show whether we actually logged anything (no) to general_log -SELECT COUNT(argument) FROM gl_partitioned; - -DROP TABLE gl_partitioned; - -SET GLOBAL log_output=@old_glo; -SET GLOBAL general_log =1; - -USE /* 2 */ test; -DROP TABLE t1; - --echo End of 5.1 tests - -SET @@global.general_log= @old_general_log; |