summaryrefslogtreecommitdiff
path: root/mysql-test/t/myisampack.test
Commit message (Collapse)AuthorAgeFilesLines
* 5.5.38 mergeSergei Golubchik2014-06-061-0/+47
|\
| * MDEV-6245 Certain compressed tables with myisampack are corrupted by "CHECK ↵Michael Widenius2014-05-171-0/+47
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | TABLE" - Fixed bug that we where using wrong checksum algorithm when using VARCHAR with fixed lenth rows - Ensure in myisampack that HA_OPTION_NULL_FIELDS is set for tables with null fields. mysql-test/r/myisampack.result: Updated results mysql-test/t/myisampack.test: Added more tests storage/myisam/mi_open.c: Use correct checksum algorithm when we have VARCHAR fields with fixed length records storage/myisam/myisampack.c: Ensure HA_OPTION_NULL_FIELDS is set for tables with null fields. (This was not set by default for not compressed tables without checksums to keep MyISAM tables compatible with MySQL)
* | MDEV-5815 MySQL BUG#11751736: DROP DATABASE STATEMENT SHOULD REMOVE .OLD ↵Sergei Golubchik2014-03-261-0/+12
|/ | | | | | | | | | SUFFIX FROM DATABASE DIRECTORY Delete .OLD and .TMD files when a MyISAM table is dropped. Same for Aria. sql/sql_db.cc: dead code - *.TMD cannot be deleted from here.
* mysql-5.5.18 mergeSergei Golubchik2011-11-031-0/+44
|\
| * Merge.Sergey Vojtovich2011-09-161-0/+44
| |\
| | * BUG#11761180 - 53646: MYISAMPACK CORRUPTS TABLES WITHSergey Vojtovich2011-09-161-0/+45
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | FULLTEXT INDEXES myisamchk may create incorrect fulltext index for compressed tables. Incorrect data pointer size was used while creating fulltext index. mysql-test/r/myisampack.result: A test case for BUG#11761180. mysql-test/t/myisampack.test: A test case for BUG#11761180. storage/myisam/ft_boolean_search.c: rec_reflength on share may have adjustments required for compressed tables and must be used instead of rec_reflength on base info. storage/myisam/ft_nlq_search.c: rec_reflength on share may have adjustments required for compressed tables and must be used instead of rec_reflength on base info. storage/myisam/mi_check.c: rec_reflength on share may have adjustments required for compressed tables and must be used instead of rec_reflength on base info. storage/myisam/mi_write.c: rec_reflength on share may have adjustments required for compressed tables and must be used instead of rec_reflength on base info.
* | | merge.Sergei Golubchik2010-11-251-0/+2
|\ \ \ | |/ / |/| | | | | | | | | | | checkpoint. does not compile.
| * | Speed up of test suite:Michael Widenius2009-10-281-0/+2
| |/ | | | | | | - Added --disable_query_log ; begin ; .... commit; --enable_query_log around all while loops that does insert
* | Fix for a bug when backporting/merging Bug#36573Magne Mahre2009-11-261-1/+1
| |
* | Addition to BUG#36573 - myisampack --join does not create destination table Magne Mahre2009-11-251-2/+4
| | | | | | | | | | | | | | | | | | .frm file Added FLUSH TABLES before myisampack --join operation to fix the test warnings or errors Removed unused variable in create_dest_frm() method
* | Fix for Bug#36573 myisampack --join does not create destination Magne Mahre2009-11-251-0/+112
|/ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | table .frm file Problem: ======== Myisampack --join did not create the destination table .frm file. The user had to copy one of the source table .frm file as destination .frm file for mysql server to recognize. This is just 'user-friendliness' issue. How it was solved ================= After successful join and compression we copy the frm file from the first source table. Functionality added =================== myisampack --join=/path/t3 /path/t1 /path/t2 creates /path/t3.frm (which is bascially copied from first table's frm /path/t1) Tests ===== Modified myisampack.test to test two scenario's 1. Positive myisampack --join test In this case after the join operation is done,we test if the destination table is accessible from the server 2. Positive myisampack --join test with an existing .frm file. We test the above case with an existing .frm file for the destination table. It should return success even in this case. 3. Positive myisampack --join test with no .frm file for source tables We test the join operation with no .frm files for source tables. It should complete the join operation without any warnings and error messages 4. Negative myisampack --join test We test myisampack --join with existing .MYI,.MDI,.frm files for the destination table. It should fail with exit status 2 in this case.
* merge 5.0-bugteam to 5.1-bugteamSatya B2009-04-071-0/+26
|\
| * Fix for Bug #43973 - backup_myisam.test fails on 6.0-bugteamSatya B2009-04-071-0/+25
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | The test started failing following the push for BUG#41541. Some of the algorithms access bytes beyond the input data and this can affect up to one byte less than "word size" which is BITS_SAVED / 8. Fixed by adding (BITS_SAVED / 8) -1 bytes to buffer size (i.e. Memory Segment #2) to avoid accessing un-allocated data. myisam/mi_packrec.c: Fixed _mi_read_pack_info() method to allocate (BITS_SAVED/8) - 1 bytes to the Memory Segment #2 mysql-test/r/myisampack.result: Result file for BUG#43973 mysql-test/t/myisampack.test: Testcase for BUG#43973
* | merge 5.0-bugteam to 5.1-bugteamSatya B2009-03-251-0/+20
|\ \ | |/
| * Fix for BUG#41541 - Valgrind warnings on packed MyISAM tableSatya B2009-03-251-0/+19
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | After the table is compressed by the myisampack utility, opening the table by the server produces valgrind warnings. This happens because when we try to read a record into the buffer we alway assume that the remaining buffer to read is always equal to word size(4 or 8 or 2 bytes) we read. Sometimes we have remaining buffer size less than word size and trying to read the entire word size will end up in valgrind errors. Fixed by reading byte by byte when we detect the remaining buffer size is less than the word size. myisam/mi_packrec.c: Fixed fill_buffer() to read byte by byte when the remaining buffer size is less than word size. mysql-test/r/myisampack.result: Result file for BUG#41541 mysql-test/t/myisampack.test: Testcase for BUG#41541
* | merged 5.1-main -> 5.1-bugteamGeorgi Kodinov2009-01-301-4/+6
|\ \
| * \ merge: 5.1 -> 5.1-rplLuis Soares2009-01-231-0/+26
| |\ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | conflicts: Text conflict in client/mysqltest.cc Text conflict in mysql-test/include/wait_until_connected_again.inc Text conflict in mysql-test/lib/mtr_report.pm Text conflict in mysql-test/mysql-test-run.pl Text conflict in mysql-test/r/events_bugs.result Text conflict in mysql-test/r/log_state.result Text conflict in mysql-test/r/myisam_data_pointer_size_func.result Text conflict in mysql-test/r/mysqlcheck.result Text conflict in mysql-test/r/query_cache.result Text conflict in mysql-test/r/status.result Text conflict in mysql-test/suite/binlog/r/binlog_index.result Text conflict in mysql-test/suite/binlog/r/binlog_innodb.result Text conflict in mysql-test/suite/rpl/r/rpl_packet.result Text conflict in mysql-test/suite/rpl/t/rpl_packet.test Text conflict in mysql-test/t/disabled.def Text conflict in mysql-test/t/events_bugs.test Text conflict in mysql-test/t/log_state.test Text conflict in mysql-test/t/myisam_data_pointer_size_func.test Text conflict in mysql-test/t/mysqlcheck.test Text conflict in mysql-test/t/query_cache.test Text conflict in mysql-test/t/rpl_init_slave_func.test Text conflict in mysql-test/t/status.test
| * | | Fix after mergeunknown2008-02-281-3/+4
| | |/ | |/| | | | | | | | | | | | | | | | | | | | | | | | | | | | mysql-test/extra/rpl_tests/rpl_charset.test: Fix merge error mysql-test/lib/mtr_report.pm: Move the . out of [] to avoid log file parsing errors mysql-test/mysql-test-run.pl: Correct spelling of option sql/ha_ndbcluster_binlog.cc: Fix merge error(used "Use remote")
* | | TestCase for BUG#41574 - REPAIR TABLE: crashes for compressed tablesSatya B2009-01-221-0/+3
| |/ |/| | | | | | | | | | | | | | | | | | | | | Extending the existing testcase written for BUG#40949 to verify repair table operation for compressed tables mysql-test/r/myisampack.result: Modified result file for myisampack.test mysql-test/t/myisampack.test: Modified Testcase to test repair operation for compressed tables
* | Bug#24289 Status Variable "Questions" gets wrong values with Stored ↵Sergey Glukhov2008-12-171-1/+1
| | | | | | | | | | | | | | | | | | Routines(for 5.1) mysql-test/r/myisampack.result: result fix mysql-test/t/myisampack.test: test case fix
* | Bug#40949 Debug version of MySQL server crashes when run OPTIMIZE on ↵Sergey Glukhov2008-12-091-0/+25
|/ | | | | | | | | | | | | | compressed table. reset diagnostics area state after error message is sent mysql-test/r/myisampack.result: test result mysql-test/t/myisampack.test: test case sql/sql_table.cc: reset diagnostics area state after error message is sent
* BUG#31277 - myisamchk --unpack corrupts a tableunknown2007-11-071-0/+33
With certain data sets (when compressed record length gets bigger than uncompressed) myisamchk --unpack may corrupt data file. Fixed that record length was wrongly restored from compressed table. myisam/mi_check.c: With compressed tables compressed record length may be bigger than pack_reclength, thus we may allocate insufficient memory for record buffer. Let single function allocate record buffer, performing needed record length calculations. Still, it is not doable with parallel repair, as it allocates needed record buffers at once. For parellel repair added better record length calculation. myisam/mi_open.c: When calculating record buffer size, take into account that compressed record length may be bigger than uncompressed. myisam/mi_packrec.c: With certain data set share->max_pack_length (compressed record length) may be bigger than share->base.pack_reclength (packed record length). set_if_bigger(pack_reclength, max_pack_length) in this case causes myisamchk --unpack to write extra garbage, whereas pack_reclength remains the same in new index file. As a result we get unreadable table. myisam/myisamchk.c: With compressed tables compressed record length may be bigger than pack_reclength, thus we may allocate insufficient memory for record buffer. Let single function allocate record buffer, performing needed record length calculations. mysql-test/mysql-test-run.pl: Environment variables to execute myisamchk and myisampack. mysql-test/r/myisampack.result: New BitKeeper file ``mysql-test/r/myisampack.result'' mysql-test/t/myisampack.test: New BitKeeper file ``mysql-test/t/myisampack.test''
View Lorry Controller Status