summaryrefslogtreecommitdiff
path: root/mysql-test/r/join.result
Commit message (Collapse)AuthorAgeFilesLines
* Create 'main' test directory and move 't' and 'r' thereMichael Widenius2018-03-291-1559/+0
|
* Tests: full test results [#387]Aleksey Midenkov2017-12-211-1/+0
|
* Tests: TRT-related results [#305]Aleksey Midenkov2017-11-211-0/+1
|
* System Versioning pre0.12Aleksey Midenkov2017-11-071-0/+1
|\ | | | | | | Merge remote-tracking branch 'origin/archive/2017-10-17' into 10.3
| * Scripts: VTMD table [closes #122]kevg2017-05-241-0/+1
| |
* | Merge remote-tracking branch 'origin/10.2' into bb-10.2-extAlexander Barkov2017-07-071-2/+2
|\ \ | |/ |/|
| * MDEV-13132 Information Schema does not show whether column default is ↵Sergei Golubchik2017-07-051-2/+2
| | | | | | | | | | | | | | expression or literal Fix INFORMATION_SCHEMA.COLUMNS.COLUMN_DEFAULT to be standard-compliant, but keep SHOW COLUMNS backward-compatibly unchanged.
* | Merge remote-tracking branch 'origin/10.2' into bb-10.2-extAlexander Barkov2017-03-311-0/+3
|\ \ | |/
| * Merge branch '10.1' into 10.2Sergei Golubchik2017-03-301-0/+3
| |\
| | * MDEV-11943 I_S.TABLES inconsistencies with tables with unknown storage engineSergei Golubchik2017-03-101-0/+3
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Make SELECT <columns> FROM I_S.TABLES behave identically independently from whether <columns> require opening the table in engine or <columns> can be filled with only opening the frm. In particular, fill_schema_table_from_frm() should not silently skip frms with unknown engine, but should fill the I_S.TABLES row with NULLs just like fill_schema_table_by_open() does.
* | | MDEV-10141: Add support for INTERSECT (and common parts for EXCEPT)Oleksandr Byelkin2017-03-141-1/+1
|/ / | | | | | | MDEV-10140: Add support for EXCEPT
* | MDEV-7635: Update tests to adapt to the new default sql_modeNirbhay Choubey2017-02-101-0/+2
| |
* | Item::print(): remove redundant parenthesesSergei Golubchik2016-12-121-2/+2
| | | | | | | | | | by introducing new Item::precedence() method and using it to decide whether parentheses are required
* | Merge branch '10.1' into 10.2Sergei Golubchik2016-09-091-0/+2
|\ \ | |/
| * Added new status variables to make it easier to debug certain problems:Monty2016-08-211-0/+2
| | | | | | | | | | | | - Handler_read_retry - Update_scan - Delete_scan
* | Fixed a flaw in the implementation of condition push-downIgor Babaev2016-09-041-1/+1
| | | | | | | | | | | | | | | | for materialized views and derived tables: there were no push-down if the view was defined as union of selects without aggregation. Added test cases with such unions. Adjusted result files after the merge of the code for mdev-9197.
* | MDEV-10095 Fix derived tables to return a syntax error instead of "Illegal ↵Alexander Barkov2016-05-211-1/+1
|/ | | | usage of UNION and LIMIT"
* Fixed bug mdev-5635.Igor Babaev2014-02-271-0/+11
| | | | | | | After constant row substitution some field items become constant items. The range analyzer should take into account this fact when looking for ranges.
* MDEV-4332 Increase username length from 16 charactersSergei Golubchik2013-11-031-1/+1
| | | | 10.0 part of the task, fix system tables
* 5.5 merge and fixes for compiler/test errorsSergei Golubchik2013-09-181-1/+20
|\
| * Fixed bug mdev-4959.Igor Babaev2013-08-281-0/+19
| | | | | | | | The fix for mdev-4420 was not quite correct. This patch corrects it.
| * Fixed bug mdev-4420.Igor Babaev2013-08-231-1/+1
| | | | | | | | | | | | | | | | The code of JOIN::optimize that performed substitutions for the best equal field in all ref items did not take into account that a multiple equality could contain the result of the single-value subquery if the subquery is inexpensive. This code was corrected. Also made necessary corresponding corrections in the code of make_join_select().
* | 5.5 mergeSergei Golubchik2013-07-171-0/+5
|\ \ | |/
| * mysql-5.5.32 mergeSergei Golubchik2013-07-161-1/+1
| |\
| | * merge 5.1-security => 5.5-securityKristofer Pettersson2010-09-081-35/+0
| | |\
| | * \ merge from 5.5-mergeGeorgi Kodinov2010-09-021-0/+1
| | |\ \
| | * \ \ Automerge.Alexey Kopytov2010-08-261-0/+71
| | |\ \ \
| * | | | | MDEV-4752: Segfault during parsing of illegal queryunknown2013-07-041-0/+5
| | | | | | | | | | | | | | | | | | | | | | | | Fix of nested join parsing of illegal query.
* | | | | | Patch by Hartmut HolzgraefeMichael Widenius2013-03-171-0/+41
|/ / / / / | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | STRAIGHT_JOIN couldn't be combined with NATURAL or USING(), INNER JOIN not with NATURAL (MDEV-4271, MySQL Bug #35268) Separate rules existed for "natural" (non-outer) joins and for STRAIGHT_JOIN, with the only difference code wise being that with STRAIGHT_JOIN the "straight" property of the right side table was set before calling the appropriate add_...() function. The "natural_join" parser rule has now been extended to also accept STRAIGHT_JOIN, and the rule result value is set to 1 for straight joins, 0 otherwise, so acting as a "straight" flag that can directly be assigned to the "straight" property of the right side table. The rule parsing NATURAL JOIN was hard coded to accept just this keyword combination, without support for either STRAIGHT_JOIN or the optional INNER. The "natural_join" rule has now been split up in an inner "inner_join" rule that matches the JOIN, INNER JOIN and STRAIGHT_JOIN cases while "natural_join" also matches CROSS JOIN. The NATURAL rule has been changed to accept "inner_join" instead of just JOIN, so now NATURAL STRAIGHT_JOIN and NATURAL INNER JOIN also work as expected. As a side effect the removal of the duplciated rules for STRAIGHT_JOIN handling has reduced the shift/reduce conflict count by one. mysql-test/r/join.result: Added new test cases mysql-test/t/join.test: Added new test cases sql/sql_yacc.yy: The "natural_join" parser rule was extended to also accept STRAIGHT_JOIN NATURAL STRAIGHT_JOIN and NATURAL INNER JOIN also now work as expected
* | | | | Merge mariadb 5.3->mariadb 5.5unknown2012-03-241-0/+70
|\ \ \ \ \
| * | | | | Fixed LP bug #954900.Igor Babaev2012-03-221-0/+70
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | If the first component of a ref key happened to be a constant appeared after constant row substitution then no store_key element should be created for such a component. Yet create_ref_for_key() erroneously could create such an element that caused construction of invalid ref keys and wrong results for some joins.
* | | | | | Merge 5.3->5.5.Igor Babaev2012-03-011-0/+49
|\ \ \ \ \ \ | |/ / / / /
| * | | | | Merge 5.2->5.3Sergey Petrunya2012-02-241-0/+49
| |\ \ \ \ \
| | * | | | | Back-ported the fix and test cases for bugs #59487 and #43368 fromIgor Babaev2012-02-221-0/+49
| | | | | | | | | | | | | | | | | | | | | | | | | | | | the mysql-5.6 code line.
* | | | | | | 5.3.4 mergeSergei Golubchik2012-02-151-0/+2
|\ \ \ \ \ \ \ | |/ / / / / /
| * | | | | | Adjust test results after Monty's push of the newunknown2012-01-181-0/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | handler counter Handler_read_rnd_deleted.
* | | | | | | 5.3 mergeSergei Golubchik2012-01-131-1/+4
|\ \ \ \ \ \ \ | |/ / / / / /
| * | | | | | Back-ported the patch of the mysql-5.6 code line thatIgor Babaev2011-12-241-1/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | fixed several defects in the greedy optimization: 1) The greedy optimizer calculated the 'compare-cost' (CPU-cost) for iterating over the partial plan result at each level in the query plan as 'record_count / (double) TIME_FOR_COMPARE' This cost was only used locally for 'best' calculation at each level, and *not* accumulated into the total cost for the query plan. This fix added the 'CPU-cost' of processing 'current_record_count' records at each level to 'current_read_time' *before* it is used as 'accumulated cost' argument to recursive best_extension_by_limited_search() calls. This ensured that the cost of a huge join-fanout early in the QEP was correctly reflected in the cost of the final QEP. To get identical cost for a 'best' optimized query and a straight_join with the same join order, the same change was also applied to optimize_straight_join() and get_partial_join_cost() 2) Furthermore to get equal cost for 'best' optimized query and a straight_join the new code substrcated the same '0.001' in optimize_straight_join() as it had been already done in best_extension_by_limited_search() 3) When best_extension_by_limited_search() aggregated the 'best' plan a plan was 'best' by the check : 'if ((search_depth == 1) || (current_read_time < join->best_read))' The term '(search_depth == 1' incorrectly caused a new best plan to be collected whenever the specified 'search_depth' was reached - even if this partial query plan was more expensive than what we had already found.
| * | | | | | Made the optimizer switch flags 'outer_join_with_cache', 'semijoin_with_cache'Igor Babaev2011-12-151-0/+3
| | | | | | | | | | | | | | | | | | | | | | | | | | | | set to 'on' by default.
* | | | | | | after merge changes:Sergei Golubchik2011-12-121-2/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | * rename all debugging related command-line options and variables to start from "debug-", and made them all OFF by default. * replace "MySQL" with "MariaDB" in error messages * "Cast ... converted ... integer to it's ... complement" is now a note, not a warning * @@query_cache_strip_comments now has a session scope, not global.
* | | | | | | 5.3->5.5 mergeSergei Golubchik2011-11-271-1/+1
|\ \ \ \ \ \ \ | |/ / / / / /
| * | | | | | Made the optimizer switch for index condition pushdown set to 'on' by default. Igor Babaev2011-11-211-1/+1
| | | | | | |
* | | | | | | 5.3->5.5 mergeSergei Golubchik2011-11-221-0/+8
|\ \ \ \ \ \ \ | |/ / / / / /
| * | | | | | lp:839387 Assertion `(Item_result)i != TIME_RESULT' failed with CASE + datetimeSergei Golubchik2011-09-071-0/+8
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | remove incorrect DBUG_ASSERT(). Fix incorrectly used cmp_item::get_comparator() in Item_func_case and Item_equal
* | | | | | | merge with 5.3Sergei Golubchik2011-10-191-8/+127
|\ \ \ \ \ \ \ | |/ / / / / / | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | sql/sql_insert.cc: CREATE ... IF NOT EXISTS may do nothing, but it is still not a failure. don't forget to my_ok it. ****** CREATE ... IF NOT EXISTS may do nothing, but it is still not a failure. don't forget to my_ok it. sql/sql_table.cc: small cleanup ****** small cleanup
| * | | | | | Set the default to be mrr=off,mrr_sort_keys=off:Sergey Petrunya2011-07-081-1/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | - Set the default - Adjust the testcases so that 'new' tests are run with optimizations turned on. - Pull out relevant tests from "irrelevant" tests and run them with optimizations on. - Run range.test and innodb.test with both mrr=on and mrr=off
| * | | | | | Merge 5.2 -> 5.3 Sergey Petrunya2011-06-241-0/+19
| |\ \ \ \ \ \ | | |/ / / / / | | | | | | | | | | | | | | (testcase for #798597 now crashes)
| | * | | | | Fix for bug lp:798597 Incorrect "Duplicate entry" error with views and GROUP BYMichael Widenius2011-06-241-0/+19
| | | |_|_|/ | | |/| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | mysql-test/r/join.result: Test case for LP:798597 mysql-test/t/join.test: Test case for LP:798597 sql/sql_select.cc: In simplify_joins we reset table->maybe_null for outer join tables that can't ever be NULL. This caused a conflict between the previously calculated items and the group_buffer against the fields in the temporary table that are created as not null thanks to the optimization. The fix is to correct the group by items to also be not_null so that they match the used fields and keys.
| * | | | | MWL#89unknown2011-03-301-1/+1
| |\ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | Merge 5.3 with 5.3-mwl89.
| * | | | | | Fixed LP bugs BUG#729067/730466.Igor Babaev2011-03-121-0/+35
| |/ / / / / | | | | | | | | | | | | | | | | | | | | | | | | Do not reset the value of the item_equal field in the Item_field object once it has been set.
View Lorry Controller Status