diff options
author | Ashish Agarwal <ashish.y.agarwal@oracle.com> | 2012-02-02 14:19:38 +0530 |
---|---|---|
committer | Ashish Agarwal <ashish.y.agarwal@oracle.com> | 2012-02-02 14:19:38 +0530 |
commit | 4e096d2a456a93c61ad3da3163a2386b9c1d8317 (patch) | |
tree | 2c4c9dc2b53de47f1d2fdee10732f4d1cac2791f /mysql-test/r/myisam.result | |
parent | 63769afc52adaba998771a8780388781cf7defd4 (diff) | |
parent | 52357198d0296e4c98551932ccf52ecb29adb85c (diff) | |
download | mariadb-git-4e096d2a456a93c61ad3da3163a2386b9c1d8317.tar.gz |
BUG#11756869 - 48848: MYISAMCHK DOING SORT RECOVER IN CERTAIN
CASES RESETS DATA POINTER TO SMAL
ISSUE: Myisamchk doing sort recover
on a table reduces data_file_length.
Maximum size of data file decreases,
lesser number of rows are stored.
SOLUTION: Size of data_file_length is
fixed to the original length.
Diffstat (limited to 'mysql-test/r/myisam.result')
-rw-r--r-- | mysql-test/r/myisam.result | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/r/myisam.result b/mysql-test/r/myisam.result index 620c1f8b4b6..3f88ff25ab5 100644 --- a/mysql-test/r/myisam.result +++ b/mysql-test/r/myisam.result @@ -2436,4 +2436,17 @@ Table Op Msg_type Msg_text test.t1 check status OK DROP TABLE t1; SET GLOBAL myisam_use_mmap=default; +# +# BUG 11756869 - 48848: MYISAMCHK DOING SORT RECOVER IN CERTAIN +# CASES RESETS DATA POINTER TO SMAL +# +CREATE TABLE t1(a INT, KEY(a)); +ALTER TABLE t1 DISABLE KEYS; +SET @before:= (SELECT MAX_DATA_LENGTH FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME='t1' AND TABLE_SCHEMA='test'); +FLUSH TABLES; +SET @after:= (SELECT MAX_DATA_LENGTH FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME='t1' AND TABLE_SCHEMA='test'); +SELECT @before=@after; +@before=@after +1 +DROP TABLE t1; End of 5.1 tests |