diff options
| author | svoj@mysql.com/june.mysql.com <> | 2007-07-27 14:30:25 +0500 |
|---|---|---|
| committer | svoj@mysql.com/june.mysql.com <> | 2007-07-27 14:30:25 +0500 |
| commit | 9d1bfec265f66cb55cfcbb99595ba7b44bf1e00c (patch) | |
| tree | d97ff101dc6144e3fbdda72b953234618878d4b0 /mysql-test/r/alter_table.result | |
| parent | 574079a17bcc4dd8c40e876c3537b58b0478810f (diff) | |
| download | mariadb-git-9d1bfec265f66cb55cfcbb99595ba7b44bf1e00c.tar.gz | |
BUG#29957 - alter_table.test fails
INSERT/DELETE/UPDATE followed by ALTER TABLE within LOCK TABLES
may cause table corruption on Windows.
That happens because ALTER TABLE writes outdated shared state
info into index file.
Fixed by removing obsolete workaround.
Affects MyISAM tables on Windows only.
Diffstat (limited to 'mysql-test/r/alter_table.result')
| -rw-r--r-- | mysql-test/r/alter_table.result | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/r/alter_table.result b/mysql-test/r/alter_table.result index 4eace9ac628..f24a1788404 100644 --- a/mysql-test/r/alter_table.result +++ b/mysql-test/r/alter_table.result @@ -903,3 +903,15 @@ f1 f2 f21 f4 f41 1 2000-01-01 00:00:00 2000-01-01 2002-02-02 00:00:00 2002-02-02 drop table t1; set sql_mode= @orig_sql_mode; +create table t1 (c char(10) default "Two"); +lock table t1 write; +insert into t1 values (); +alter table t1 modify c char(10) default "Three"; +unlock tables; +select * from t1; +c +Two +check table t1; +Table Op Msg_type Msg_text +test.t1 check status OK +drop table t1; |