diff options
| author | unknown <brian@brian-akers-computer.local> | 2005-07-10 18:19:37 -0700 |
|---|---|---|
| committer | unknown <brian@brian-akers-computer.local> | 2005-07-10 18:19:37 -0700 |
| commit | 7dad26b5427cf24983dd47a6483af8a9358784c2 (patch) | |
| tree | 7aaed25cbbd0a48f122e4c6ecff34a434870de2c /mysql-test/t/archive.test | |
| parent | 22a3bb89c6700c6b3a35cd39ae0f323e1d1c7db9 (diff) | |
| download | mariadb-git-7dad26b5427cf24983dd47a6483af8a9358784c2.tar.gz | |
Refactoring of write_row() into two parts to allow future additions. Also rewrote the OPTIMIZE TABLE code, to add new extended optimize. This form of optimize rebuilds not only the file, but each individual row.
mysql-test/r/archive.result:
Update results file for new OPTIMIZE TABLE <foo> EXTENDED command.
mysql-test/t/archive.test:
Added new test for extended optimize
sql/examples/ha_archive.cc:
Refactored write_row code into two parts. This will allow me to abstract it out once I add in new row format. This also allowed code sharing for the new optimize command (which will be used for new repair code).
sql/examples/ha_archive.h:
Added new real_write_row() method for writing out rows.
Diffstat (limited to 'mysql-test/t/archive.test')
| -rw-r--r-- | mysql-test/t/archive.test | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/t/archive.test b/mysql-test/t/archive.test index 51334fa62bc..a42a42b2a4e 100644 --- a/mysql-test/t/archive.test +++ b/mysql-test/t/archive.test @@ -1313,6 +1313,11 @@ INSERT INTO t2 VALUES (4,011403,37,'intercepted','audiology','tinily',''); SELECT * FROM t2; OPTIMIZE TABLE t2; SELECT * FROM t2; +INSERT INTO t2 VALUES (2,011401,37,'breaking','dreaded','Steinberg','W'); +INSERT INTO t2 VALUES (3,011402,37,'Romans','scholastics','jarring',''); +INSERT INTO t2 VALUES (4,011403,37,'intercepted','audiology','tinily',''); +OPTIMIZE TABLE t2 EXTENDED; +SELECT * FROM t2; REPAIR TABLE t2; SELECT * FROM t2; |