summaryrefslogtreecommitdiff
path: root/mysql-test/include/icp_tests.inc
Commit message (Collapse)AuthorAgeFilesLines
* MDEV-4778: Incorrect results from Aria/MyISAM SELECT using index with prefix ↵Sergey Petrunya2013-07-161-0/+21
| | | | | | | | | | length on TEXT column Backport the fix olav.sandstaa@sun.com-20101102184747-qfuntqwj021imy9r: "Fix for Bug#52660 Perf. regr. using ICP for MyISAM on range queries on an index containing TEXT" (together with further fixes in that code) into MyISAM and Aria.
* MDEV-308 lp:1008516 - Failing assertion: templ->mysql_col_len == lenSergei Golubchik2012-06-041-0/+18
| | | | | remove the offending assert. take the test case from mysql Bug#58015
* Changed names of statistic variables and counting matches instaed of ↵unknown2012-02-221-3/+3
| | | | rejected rows.
* Counters for Index Condition Pushdown added (MDEV-130).unknown2012-02-161-0/+22
|
* Fixed LP bug #904832.Igor Babaev2011-12-181-0/+108
| | | | | Do not perform index condition pushdown for conditions containing subqueries and stored functions.
* Fixed LP bug #879871. Igor Babaev2011-11-111-0/+20
| | | | | | The function add_ref_to_table_cond missed updating the value of join_tab->pre_idx_push_select_cond after having updated the value of join_tab->select->pre_idx_push_select_cond.
* Fixed LP bug #886145.Igor Babaev2011-11-061-0/+27
| | | | | | | | | | | | | | | The bug happened because in some cases the function JOIN::exec did not save the value of TABLE::pre_idx_push_select_cond in TABLE::select->pre_idx_push_select_cond for the sort table. Noticed and fixed a bug in the function make_cond_remainder that builds the remainder condition after extraction of an index pushdown condition from the where condition. The code erroneously assumed that the function make_cond_for_table left the value of ICP_COND_USES_INDEX_ONLY in sub-condition markers. Adjusted many result files from the regression test suite after this fix .
* Fixed LP bug #885168.Igor Babaev2011-11-041-0/+29
| | | | | | The call of the virtual function cancel_pushed_idx_cond in the code of the function test_if_skip_sort_order was misplaced when backporting the fix for bug 58816.
* Backported the fix and the test case for bug 12822678 from the mysql-5.6 ↵Igor Babaev2011-11-011-0/+26
| | | | | | | code line. Fixed a bug in select_describe. Adjusted results for affected test cases.
* Backported the test case for bug 59843 from the mysql-5.6 code line.Igor Babaev2011-10-311-0/+17
| | | | (Failed to reproduce the bug in mariadb-5.3).
* Backported the fix and the test case for bug 59483 from the mysql-5.6 code line.Igor Babaev2011-10-301-0/+23
|
* Backported the test case for bug 58838 from mysql-5.6 code line.Igor Babaev2011-10-301-0/+22
| | | | | The bug was fixed by the patches for LP bugs 668644,702322 that were applied earlier to the mariadb-5.3 code.
* Backported the test case for bug 59186 from mysql-5.6 code line.Igor Babaev2011-10-301-0/+29
| | | | | The bug was fixed by the patch for LP bug 694092 that was applied earlier to the mariadb-5.3 code.
* Backported the test case for bug 58837. The fix was backported earlier.Igor Babaev2011-10-301-0/+31
|
* Backported the fix and the test case for bug #58816 from mysql-5.6 code line.Igor Babaev2011-10-291-0/+25
|
* Merge.Igor Babaev2011-10-281-0/+241
|\
| * Backported the test case for bug 52605.Igor Babaev2011-05-291-0/+35
| |
| * Backported the test case for bug 52660 from mysql code line.Igor Babaev2011-05-271-0/+33
| | | | | | | | | | | | Extended the test case to show how MariaDB applies ICP for indexes with some components defined on the beginning of fields.
| * Backported the test case for bug 43618 from mysql code line.Igor Babaev2011-05-271-0/+41
| |
| * Backported the test case for bug 43617 fixed by the patch for bug 42580.Igor Babaev2011-05-271-0/+73
| | | | | | | | | | | | Backported the test case for bug 49906 fixed by the patch for LP bug 625841. Slightly optimized the code of the fix for LP bug 625841.
| * Downported InnoDB support of Index Condition Pushdown from MySQL-5.6 code line.Igor Babaev2011-05-251-0/+60
| |
* | BUG#778434 Wrong result with in_to_exists=on in maria-5.3-mwl89Sergey Petrunya2011-07-141-0/+29
|/ | | | | | - Make {ha_myisam,ha_maria}::index_read_idx_map check pushed index condition. - Address review feedback (added comments)
* Backported test case for bug #36981.Igor Babaev2011-02-081-0/+59
|
* Backport of:Sergey Petrunya2011-01-141-0/+139
| | | | | | | | | | | | | | | 3150 Olav Sandstaa 2010-05-07 Test cases for the following "ICP for InnoDB" bugs: Bug#40992 InnoDB: Crash when engine_condition_pushdown is on Bug#35080 Innodb crash at mem_block_get_len line 72 Bug#41996 multi-table delete crashes server (InnoDB table) Bug#43448 Server crashes on multi table delete with Innodb All these bugs are duplicates of either one or both of Bug 43360 or 36981. (backporting of olav@sun.com-20100226091930-qxvakxmcp6463t5w)
* Test case backport for: Bug#42580 - Innodb's ORDER BY ..LIMIT returns no ↵Sergey Petrunya2011-01-141-0/+29
rows for null-safe operator <=> NULL
View Lorry Controller Status