summaryrefslogtreecommitdiff
path: root/mysql-test
Commit message (Collapse)AuthorAgeFilesLines
* Merge with 5.1Michael Widenius2012-04-045-35/+35
|\
| * Fixed test cases that changed as part of fixing bugs with record count and ↵Michael Widenius2012-04-045-35/+35
| | | | | | | | partitioning
* | Merge with 5.1Michael Widenius2012-04-043-7/+35
|\ \ | |/
| * Fixed lp:970528 "Server crashes in my_strnncollsp_simple on LEFT JOIN with ↵Michael Widenius2012-04-043-7/+35
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | CSV table, TEXT field" The main problem was a bug in CSV where it provided wrong statistics (it claimed the table was empty when it wasn't) I also fixed wrong freeing of blob's in the CSV handler. (Any call to handler::read_first_row() on a CSV table with blobs would fail) mysql-test/r/csv.result: Added new test case mysql-test/r/partition_innodb.result: Updated test results after fixing bug with impossible partitions and const tables mysql-test/t/csv.test: Added new test case sql/sql_select.cc: Cleaned up code for handling of partitions. Fixed also a bug where we didn't threat a table with impossible partitions as a const table. storage/csv/ha_tina.cc: Allocate blobroot onces.
* | Automatic mergeMichael Widenius2012-03-302-0/+24
|\ \ | |/
| * Fixed bug lp:967914 "CHECK TABLE persistently reports table corruption after ↵Michael Widenius2012-03-302-0/+24
| | | | | | | | | | | | | | | | | | | | | | | | | | removing Aria logs" Fixed that repair removes the 'table is moved' mark. mysql-test/suite/maria/r/maria-autozerofill.result: Test case for lp:967914 mysql-test/suite/maria/t/maria-autozerofill.test: Test case for lp:967914 storage/maria/ha_maria.cc: Fixed that repair removes the 'table is moved' mark.
* | mergeSergei Golubchik2012-03-291-0/+3
|\ \ | |/
| * fix the test case for windows: replace_result \\ /Sergei Golubchik2012-03-291-0/+3
| |
* | Merge with 5.1Michael Widenius2012-03-282-3/+46
|\ \ | |/
| * Fixed lp:944422 "mysql_upgrade destroys Maria tables?"Michael Widenius2012-03-282-3/+46
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | The issue was that check/optimize/anaylze did not zerofill the table before they started to work on it. Added one more element to not often used function handler::auto_repair() to allow handler to decide when to auto repair. mysql-test/suite/maria/r/maria-autozerofill.result: Test case for lp:944422 mysql-test/suite/maria/t/maria-autozerofill.test: Test case for lp:944422 sql/ha_partition.cc: Added argument to auto_repair() sql/ha_partition.h: Added argument to auto_repair() sql/handler.h: Added argument to auto_repair() sql/table.cc: Let auto_repair() decide which errors to trigger auto-repair storage/archive/ha_archive.h: Added argument to auto_repair() storage/csv/ha_tina.h: Added argument to auto_repair() storage/maria/ha_maria.cc: Give better error & warning messages for auto-repaired tables. storage/maria/ha_maria.h: Added argument to auto_repair() Always auto-repair in case of moved table. storage/maria/ma_open.c: Remove special handling of HA_ERR_OLD_FILE (this is now handled in auto_repair()) storage/myisam/ha_myisam.h: Added argument to auto_repair()
* | test suite for LP bug#694450unknown2012-03-142-0/+37
| |
* | Fixed LP bug #930814.Igor Babaev2012-03-092-0/+27
| | | | | | | | | | | | | | | | | | This bug was introduced into mariadb 5.2 in the December 2010 with the patch that added a new engine property: the ability to support virtual columns. As a result of this bug the information from frm files for tables that contained virtual columns did not appear in the information schema tables.
* | Added test case for lp:905782 "Assertion `pageno < ((1ULL) << 40)' failed at ↵Michael Widenius2012-03-092-10/+20
| | | | | | | | | | | | ma_pagecache.c:3438: pagecache_read or table corruption on INSERT into a ucs2 table" The orignal bug has been fixed earlier
* | Added ucs2 test moved from maria3.test. (MDEV-167)unknown2012-03-092-0/+80
| |
* | Fixed LP bug #884175.Igor Babaev2012-03-082-0/+80
| | | | | | | | | | | | | | | | | | | | | | | | If in the where clause of the a query some comparison conditions on the field under a MIN/MAX aggregate function contained constants whose sizes exceeded the size of the field then the query could return a wrong result when the optimizer had chosen to apply the MIN/MAX optimization. With such conditions the MIN/MAX optimization still could be applied, yet it would require a more thorough analysis of the keys built to find the value of MIN/MAX aggregate functions with index look-ups. The current patch just prohibits using the MIN/MAX optimization in this situation.
* | Return original checksum value inside the test.unknown2012-03-012-47/+7
| | | | | | | | Move ucs2 test in separate file (MDEV-167).
* | Automatic mergeMichael Widenius2012-02-284-24/+66
|\ \
| * | Fixed lp:905716 "Assertion `page->size <= share->max_index_block_size'"Michael Widenius2012-02-284-24/+66
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | The issue was that Aria allowed too long keys to be created (so that the internal buffer was not big enough to hold the whole key). Key lengths is now limited to HA_MAX_KEY_LENGTH (1000), as for MyISAM. Fixed failure in "_ma_apply_redo_index: Assertion `new_page_length == 0", as found by buildbot. mysql-test/suite/maria/r/maria.result: Updated results mysql-test/suite/maria/r/maria3.result: Updated results. Added test for bug fix mysql-test/suite/maria/t/maria3.test: Updated results. Added test for bug fix mysql-test/suite/maria/t/optimize.test: Updated test for new max key length storage/maria/ha_maria.cc: Limit key to HA_MAX_KEY_LENGTH. storage/maria/ma_key_recover.c: Limit used page length to max page size (this is in line with the code that writes the entry to the log). This fixes failure in "_ma_apply_redo_index: Assertion `new_page_length == 0", as found by buildbot. storage/maria/ma_search.c: Extra DBUG storage/maria/ma_write.c: Added test to detect errors earlier.
* | | Fix of LP bug:938518 (also LP bug:791761 and LP bug:806955)unknown2012-02-252-1/+126
|/ / | | | | | | Cause of the bug is uninitialized items before evaluation HAVING clasue in case of empty result.
* | Automatic mergeMichael Widenius2012-02-242-0/+55
|\ \ | |/
| * Fix for lp:909635: MariaDB crashes on a select with long varchar and blob fieldsMichael Widenius2012-02-242-0/+55
| | | | | | | | | | | | | | | | | | | | | | | | Problem was a crash in internal temporary (Maria) files when row length exceeded 65535 mysql-test/suite/maria/r/maria3.result: Added test case mysql-test/suite/maria/t/maria3.test: Added test case storage/maria/ma_open.c: Added support for row length > 65535. This fixes crash when using tables with longer row lengths.
* | Back-ported the fix and test cases for bugs #59487 and #43368 fromIgor Babaev2012-02-226-5/+288
| | | | | | | | the mysql-5.6 code line.
* | Automatic merge with 5.1Michael Widenius2012-02-211-1/+1
|\ \ | |/
| * Fixed suppression expression.Michael Widenius2012-02-211-1/+1
| |
* | Fixed wrong test caseMichael Widenius2012-02-211-0/+1
| | | | | | | | | | mysql-test/suite/innodb_plugin/t/innodb_gis.test: Don't run test if innodb_plugin isn't used.
* | Merge with 5.1Michael Widenius2012-02-211-2/+2
|\ \ | |/
| * More general handling of memory loss in dlclose (backported from 5.2)Michael Widenius2012-02-212-125/+9
| | | | | | | | | | | | | | | | | | | | | | Fixed supression in mysql-test-run so it also works on windows. mysql-test/mysql-test-run.pl: Fixed supression so it also works on windows. mysql-test/valgrind.supp: More general handling of memory loss in dlclose (backported from 5.2) sql/signal_handler.cc: Added newlines around link to how to do bug reports
* | Merge with MariaDB 5.1 and MySQL 5.1.61Michael Widenius2012-02-2014-6/+122
|\ \ | |/
| * Merge with MYSQL 5.1.61Michael Widenius2012-02-2012-4/+112
| |\ | | | | | | | | | | | | | | | | | | | | | | | | | | | Fixed README with link to source Merged InnoDB change to XtraDB README: Added information of where to find MariaDB code storage/archive/ha_archive.cc: Removed memset() of rows, a MariaDB checksum's doesn't touch not used data.
| | * Post push fix for merge.test and mysqlcheck.test on windowsMattias Jonsson2011-12-153-3/+9
| | |
| | * merge mysql-5.1->mysql-5.1-securityGeorgi Kodinov2011-12-154-0/+38
| | |\
| | | * Bug #13117023: Innodb increments handler_read_key when it should notAnnamalai Gurusami2011-12-134-0/+38
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | The counter handler_read_key (SSV::ha_read_key_count) is incremented incorrectly. The mysql server maintains a per thread system_status_var (SSV) object. This object contains among other things the counter SSV::ha_read_key_count. The purpose of this counter is to measure the number of requests to read a row based on a key (or the number of index lookups). This counter was wrongly incremented in the ha_innobase::innobase_get_index(). The fix removes this increment statement (for both innodb and innodb_plugin). The various callers of the innobase_get_index() was checked to determine if anybody must increment this counter (if they first call innobase_get_index() and then perform an index lookup). It was found that no caller of innobase_get_index() needs to worry about the SSV::ha_read_key_count counter.
| | * | mergeMattias Jonsson2011-12-142-0/+32
| | |\ \ | | | |/ | | |/|
| | | * mergeMattias Jonsson2011-12-142-0/+32
| | | |\
| | | | * Bug#12361113: CRASH WHEN "LOAD INDEX INTO CACHE" WITH TOOMattias Jonsson2011-12-122-0/+32
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | SMALL KEY CACHE The server crashed on division by zero because the key cache was not initialized and the block length was 0 which was used in a division. The fix was to not allow CACHE INDEX if the key cache was not initiallized. Thus never try LOAD INDEX INTO CACHE for an uninitialized key cache. Also added some windows files/directories to .bzrignore.
| | * | | BUG#11751793 - 42784: ARCHIVE TABLES CAUSE 100% CPU USAGEAshish Agarwal2011-11-232-0/+33
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | AND HANG IN SHOW TABLE STATUS. ISSUE: Table corruption due to concurrent queries. Different threads running insert and check query leads to table corruption. Not properly locked, rows are inserted in between check query. SOLUTION: In check query mutex lock is acquired for a longer time to handle concurrent insert and check query. NOTE: Additionally we backported the fix for CHECKSUM issue(bug#11758979).
| | * | | Disabling main.query_cache_28249.test since this test failsJon Olav Hauglid2011-11-221-1/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | sporadically on 5.1. See Bug#12584161. Test runs successfully on 5.5/trunk, so this changeset will be null-merged.
| * | | | mtr runs only "big" tests, if --big-test is repeated twiceSergei Golubchik2012-01-252-2/+10
| | | | |
* | | | | Fixed lp:902654 "MariaDB consistently crashes in collect_tables on Aria ↵Michael Widenius2012-02-202-5/+11
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | checkpoint execution" This happend when you have more than 1024 open Aria tables during checkpoint. mysql-test/mysql-test-run.pl: Fixed that variable names are consistent between external and internal server. mysql-test/suite/maria/suite.pm: Test for aria-block-size instead of 'aria' as 'aria' is not set for embedded server. This should be ok for aria tests, as aria is never disabled for these. storage/maria/ma_checkpoint.c: Fixed bug when there are more than 1024 open Aria tables during checkpoint.
* | | | | Fixed LP bug #933117.Igor Babaev2012-02-162-0/+29
| | | | | | | | | | | | | | | | | | | | | | | | | The bug was fixed with the code back-ported from the patch for LP bug 800184 pushed into mariadb-5.3.
* | | | | Fixed DELETE issues of view over view over table.unknown2012-02-032-0/+32
| | | | |
* | | | | Added 5.2 test result delimiterunknown2012-02-032-0/+7
| | | | |
* | | | | Fix check of view updatability in case of underlying view changes its ↵unknown2012-02-032-2/+47
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | updatability. For single table update/insert added deep check of single tables (single_table_updatable()). For multi-table view insert added additional check of target table (check_view_single_update). Multi-update was correct. Test suite for all cases added.
* | | | | Fixed LP bug #919427.Igor Babaev2012-01-202-0/+95
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | The function subselect_uniquesubquery_engine::copy_ref_key has to take into account that when EXPLAIN is processed the array of store_key object created for any TABLE_REF may contain elements for constant items. These items should be ignored by thefunction.
* | | | | plugin renamed socket_peercred -> unix_socket.Sergei Golubchik2011-12-302-0/+86
| | | | | | | | | | | | | | | | | | | | test added.
* | | | | Back-ported the test case for bug #12616253 from mariadb-5.3 thatIgor Babaev2012-01-142-0/+62
| | | | | | | | | | | | | | | | | | | | was actually a duplicate of LP bug #888456 fixed in mariadb-5.2.
* | | | | Back-ported the fix and the test case for bug #50257 from mariadb-5.3 code line.Igor Babaev2012-01-136-14/+39
| | | | | | | | | | | | | | | | | | | | Adjusted results for a few test cases.
* | | | | Back-ported the test cases for bug #12763207 from mysql-5.6 code line into 5.2Igor Babaev2012-01-132-0/+106
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Completed the fix for this bug. Note: in 5.3 the affected 'if' statement in Item_in_subselect::single_value_transformer() starting with the condition (thd->variables.sql_mode & MODE_ONLY_FULL_GROUP_BY) should be removed altogether. The change from table.cc is not needed either. This is because in 5.3 - min/max transformation for subqueries are done at the optimization phase - evaluation of the expensive subqueries is done at the execution phase. Added an EXPLAIN EXTENDED to the test case for bug #12329653.
* | | | | Fixed compiler and test failures found by buildbotMichael Widenius2012-01-084-5/+6
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | configure.in: Added testing of STRNDUP (not found on solaris) mysql-test/include/wait_until_connected_again.inc: Also test for error 2005 (can happen on windows) mysql-test/include/wait_until_disconnected.inc: Also test for error 2005 (can happen on windows) mysql-test/suite/innodb_plugin/r/innodb_bug30423.result: Number of rows is not stable (found difference on Solaris) mysql-test/suite/innodb_plugin/t/innodb_bug30423.test: Number of rows is not stable (found difference on Solaris) plugin/auth_pam/auth_pam.c: Use internal strndup if it doesn't exist on system (solaris) Changed code so that it should also compile on solaris.
* | | | | Fix of LP BUG#793589 Wrong result with double ORDER BYunknown2012-01-052-0/+83
| | | | | | | | | | | | | | | | | | | | Problem was in caching 'eq_ref' dependency between calls of remove_const() for ORDER BY and GROUP BY lists.
View Lorry Controller Status