| Bug #54336 | main.alter_table-big fails | ||
|---|---|---|---|
| Submitted: | 8 Jun 2010 13:33 | Modified: | 8 Jun 2010 15:14 |
| Reporter: | Aleksandr Kuzminsky | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | Tests: Server | Severity: | S3 (Non-critical) |
| Version: | 5.1.47 | OS: | Linux (CentOS 5.2) |
| Assigned to: | CPU Architecture: | Any | |
[8 Jun 2010 15:14]
MySQL Verification Team
Thank you foe the bug report. I couldn't repeat on current source server, please wait next release. Thanks in advance. ============================================================================== TEST RESULT TIME (ms) ------------------------------------------------------------ worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009 main.alter_table-big [ pass ] 30680 ------------------------------------------------------------ The servers were restarted 0 times Spent 30.680 of 36 seconds executing testcases Completed: All 1 tests were successful
Description: main.alter_table-big [ fail ] Test ended at 2010-06-08 05:57:47 CURRENT_TEST: main.alter_table-big --- /mnt/data1/home/akuzminsky/tmp/mysql-5.1.47/mysql-test/r/alter_table-big.result 2010-05-06 18:58:36.000000000 +0300 +++ /mnt/data1/home/akuzminsky/tmp/mysql-5.1.47/mysql-test/r/alter_table-big.reject 2010-06-08 15:57:47.000000000 +0300 @@ -6,6 +6,8 @@ create table t2 (i int); alter table t1 disable keys; insert into t1 values (RAND()*1000, RAND()*1000, RAND()*1000); +Warnings: +Note 1592 Statement may not be safe to log in statement format. reset master; set session debug="+d,sleep_alter_enable_indexes"; alter table t1 enable keys;; mysqltest: Result content mismatch How to repeat: 1. Configure MySQL with --with-debug option. 2. Run ./mtr --big-test alter_table-big Suggested fix: If the warning is expected - to regenerate .result