summaryrefslogtreecommitdiff
path: root/mysql-test/r/subselect4.result
Commit message (Collapse)AuthorAgeFilesLines
* Create 'main' test directory and move 't' and 'r' thereMichael Widenius2018-03-291-2516/+0
|
* Merge branch '10.2' into 10.3Sergei Golubchik2018-03-281-0/+11
|\
| * Merge branch '10.1' into 10.2Sergei Golubchik2018-03-251-0/+11
| |\
| | * Merge branch '10.0' into 10.1Sergei Golubchik2018-03-231-0/+11
| | |\
| | | * Merge branch '5.5' into 10.0Sergei Golubchik2018-03-231-0/+11
| | | |\
| | | | * MDEV-15555: select from DUAL where false yielding wrong result when in a INVarun Gupta2018-03-211-0/+11
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | For the query having an IN subquery with no tables, we were converting the subquery with an expression between the left part and the select list of the subquery . This can give incorrect results when we have a condition in the subquery with a dual table (as this is treated as a no table). The fix is that we don't do this conversion when we have conds in the subquery with a dual table.
* | | | | Changed "const row not found" to "Const row not found"Monty2017-12-021-10/+10
| | | | | | | | | | | | | | | | | | | | | | | | | Also changed Unique row not found to use uppercase first. This was done to make these messages consistent with the rest
* | | | | Merge tag 'mariadb-10.2.6' into bb-10.2-extAlexander Barkov2017-05-261-3/+5
|\ \ \ \ \ | |/ / / /
| * | | | Merge branch '10.1' into 10.2Sergei Golubchik2017-05-091-3/+5
| |\ \ \ \ | | |/ / / | | | | | | | | | | | | | | | Revert commit db0917f68f, because the fix for MDEV-12696 is coming from 5.5 and 10.1 in this merge.
| | * | | Merge branch '10.0' 10.1Sergei Golubchik2017-04-281-3/+5
| | |\ \ \ | | | |/ /
| | | * | Merge branch '5.5' into 10.0Sergei Golubchik2017-04-211-3/+5
| | | |\ \ | | | | |/
| | | | * Fixed the bug mdev-12429 and its duplicates mdev-12145 and mdev-9886.Igor Babaev2017-04-041-3/+5
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Also fixed a wrong result for a test case for mdev-7691 (the alternative one). The test cases for all these bug have materialized semi-joins used inside dependent sub-queries. The patch actually reverts the change inroduced by Monty in 2003. It looks like this change is not valid anymore after the implementation of semi-joins. Adjusted output from EXPLAIN for many other test cases.
* | | | | Merge remote-tracking branch 'origin/10.2' into bb-10.2-extAlexander Barkov2017-03-311-0/+47
|\ \ \ \ \ | |/ / / /
| * | | | Merge branch '10.1' into 10.2Sergei Golubchik2017-03-301-0/+47
| |\ \ \ \ | | |/ / /
| | * | | Merge branch '10.0' into 10.1Sergei Golubchik2017-03-211-0/+13
| | |\ \ \ | | | |/ /
| | | * | Merge branch '5.5' into 10.0Sergei Golubchik2017-03-211-0/+13
| | | |\ \ | | | | |/
| | | | * MDEV-6486: Assertion `!table || (!table->read_set || ↵Varun Gupta2017-03-141-0/+13
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | bitmap_is_set(table->read_set, field_index))' failed with SELECT SQ, TEXT field The functon find_all_keys does call Item_subselect::walk, which calls walk() for the subquery The issue is that when a field is represented by Item_outer_ref(Item_direct_ref(Item_copy_string( ...))). Item_copy_string does have a pointer to an Item_field in Item_copy::item but does not implement Item::walk method, so we are not able to set the bitmap for that field. This is the reason why the assert fails. Fixed by adding the walk method to Item_copy class.
| | * | | Merge 10.0 into 10.1Marko Mäkelä2017-03-091-0/+34
| | |\ \ \ | | | |/ / | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Also, implement MDEV-11027 a little differently from 5.5 and 10.0: recv_apply_hashed_log_recs(): Change the return type back to void (DB_SUCCESS was always returned). Report progress also via systemd using sd_notifyf().
| | | * | Merge 5.5 into 10.0Marko Mäkelä2017-03-081-0/+34
| | | |\ \ | | | | |/ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Also, implement MDEV-11027 a little differently from 5.5: recv_sys_t::report(ib_time_t): Determine whether progress should be reported. recv_apply_hashed_log_recs(): Rename the parameter to last_batch.
| | | | * MDEV-11078: NULL NOT IN (non-empty subquery) should never return resultsVarun Gupta2017-03-051-0/+34
| | | | | | | | | | | | | | | | | | | | | | | | | Disabling the cond guards during the creation of Tricond Item for constant and NULL left expression items
* | | | | MDEV-10141: Add support for INTERSECT (and common parts for EXCEPT)Oleksandr Byelkin2017-03-141-4/+4
|/ / / / | | | | | | | | | | | | MDEV-10140: Add support for EXCEPT
* | | | Merge branch '10.1' into 10.2Sergei Golubchik2017-02-101-0/+51
|\ \ \ \ | |/ / /
| * | | MDEV-10232: Scalar result of subquery changes after adding an outer select stmtVarun Gupta2017-01-211-0/+12
| | | | | | | | | | | | | | | | | | | | In a subquery, we don't have to maintain order Added a fix such that order is considered when there is a limit clause.
| * | | Merge branch '10.0' into 10.1Vicențiu Ciorbaru2017-01-161-0/+39
| |\ \ \ | | |/ /
| | * | Merge remote-tracking branch 'origin/5.5' into 10.0vicentiu2017-01-061-0/+39
| | |\ \ | | | |/
| | | * MDEV-7691: Assertion `outer_context || !*from_field || *from_field == ↵Sergei Petrunia2016-12-191-0/+39
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | not_found_field' ... The bug occurred when a subquery - has a reference to outside, to grand-parent query or further up - is converted to a semi-join (i.e. merged into its parent). Then the reference to outside had form Item_ref(Item_field(...)). - Conversion to semi-join would call item->fix_after_pullout() for the outside reference. - Item_ref::fix_after_pullout would call Item_field->fix_after_pullout - The Item_field would construct a new Name_resolution_context object This process ignored the fact that the Item_field does not belong to any of the subselects being flattened. The result was crash in the next call to Item_field::fix_fields(), where we would try to use an invalid Name_resolution_context object. Fixed by not creating Name_resolution_context object if the Item_field's context does not belong to the subselect(s) that were flattened.
* | | | Item::print(): remove redundant parenthesesSergei Golubchik2016-12-121-1/+1
| | | | | | | | | | | | | | | | | | | | by introducing new Item::precedence() method and using it to decide whether parentheses are required
* | | | Remove end . from error messages to get them consistentMonty2016-10-051-2/+2
| | | | | | | | | | | | | | | | Fixed a few failing tests
* | | | MDEV-8646: Re-engineer the code for post-join operationsSergei Petrunia2016-03-281-2/+2
| | | | | | | | | | | | | | | | | | | | - Make EXPLAIN code use the post-join operations - Remove Sort_and_group_tracker that was used for that purpose
* | | | This is the consolidated patch for mdev-8646:bb-10.2-mdev8646Igor Babaev2016-02-091-1/+1
|/ / / | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | "Re-factor the code for post-join operations". The patch mainly contains the code ported from mysql-5.6 and created for two essential architectural changes: 1. WL#5558: Resolve ORDER BY execution method at the optimization stage 2. WL#6071: Inline tmp tables into the nested loops algorithm The first task was implemented for mysql-5.6 by Ole John Aske. It allows to make all decisions on ORDER BY operation at the optimization stage. The second task implemented for mysql-5.6 by Evgeny Potemkin adds JOIN_TAB nodes for post-join operations that require temporary tables. It allows to execute these operations within the nested loops algorithm that used to be used before this task only for join queries. Besides these task moves all planning on the execution of these operations from the execution phase to the optimization phase. Some other re-factoring changes of mysql-5.6 were pulled in, mainly because it was easier to pull them in than roll them back. In particular all changes concerning Ref_ptr_array were incorporated. The port required some changes in the MariaDB code that concerned the functionality of EXPLAIN and ANALYZE. This was done mainly by Sergey Petrunia.
* | | MDEV-6513 deprecate engine_condition_pushdown value of the @@optimizer_switchSergei Golubchik2014-10-101-0/+4
|/ / | | | | | | | | | | * ignore the OPTIMIZER_SWITCH_ENGINE_CONDITION_PUSHDOWN bit * issue a deprecation warning on 'engine_condition_pushdown=on' * remove unused remains of the old pre-5.5 engine_condition_pushdown variable
* | 5.5 mergeSergei Golubchik2014-03-261-0/+22
|\ \ | |/
| * 5.3-mergeSergei Golubchik2014-03-161-0/+22
| |\
| | * Fixed bug mdev-5686.Igor Babaev2014-03-061-0/+22
| | | | | | | | | | | | | | | | | | The calls of the function remove_eq_conds() may change the and/or structure of the where conditions. So JOIN::equal_cond should be updated for non-recursive calls of remove_eq_conds().
* | | 10.0-base mergeSergei Golubchik2014-02-261-0/+27
|\ \ \
| * \ \ 5.5 mergeSergei Golubchik2014-02-251-0/+27
| |\ \ \ | | |/ /
| | * | Merge 5.3->5.5Igor Babaev2014-02-101-0/+27
| | |\ \ | | | |/
| | | * Fixed bug mdev-5468.Igor Babaev2014-02-051-0/+27
| | | | | | | | | | | | | | | | | | | | | | | | | | | | The field JOIN::select_lex->where should be updated after the call of remove_eq_conds() in the function make_join_statistics(). This matters for subselects.
* | | | 10.0-base mergeSergei Golubchik2013-12-161-0/+22
|\ \ \ \ | |/ / /
| * | | 5.5 mergeSergei Golubchik2013-11-231-0/+22
| |\ \ \ | | |/ /
| | * | Merge 5.3->5.5Igor Babaev2013-11-211-0/+22
| | |\ \ | | | |/
| | | * Another attempt to fix bug mdev-5103.Igor Babaev2013-11-211-0/+22
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | The earlier pushed fix for the bug was incomplete. It did not remove the main cause of the problem: the function remove_eq_conds() removed always true multiple equalities from any conjunct, but did not adjust the list of them stored in Item_cond_and::cond_equal.current_level. Simplified the test case for the bug and moved it to another test file. The fix triggered changes in EXPLAIN EXTENDED for some queries.
| | * | Merge 5.3->5.5Igor Babaev2013-08-271-1/+1
| | |\ \ | | | |/
| | * | Merge 5.3->5.5.Igor Babaev2013-08-181-1/+1
| | |\ \ | | | |/ | | | | | | | | | | | | | | | | | | | | In particular: Merged the patch for bug mdev-4418 from 5.3 into 5.5. Fixed a bug in the patch that should be backported to 5.3.
* | | | Merge 10.0-base -> 10.0Sergey Petrunya2013-10-161-8/+8
|\ \ \ \ | |/ / /
| * | | [SHOW] EXPLAIN UPDATE/DELETE, code re-structuringSergey Petrunya2013-06-181-8/+8
| | | | | | | | | | | | | | | | | | | | | | | | | | | | Part 2 of: - Pass more tests - select with subselects is now shown with type=PRIMARY where it used to be (incorrectly) 'SIMPLE'
* | | | MDEV-4865 Change related to --log option/variable was merged partiallySergei Golubchik2013-08-131-19/+6
| | | | | | | | | | | | | | | | | | | | Complete the merge of magne.mahre@oracle.com-20101102115354-vxcaxminmzglzalk (WL#5185 Remove deprecated 5.1 features)
* | | | 10.0-monty mergeSergei Golubchik2013-07-211-1/+1
|\ \ \ \ | |/ / / |/| | | | | | | | | | | | | | | | | | | | | | | includes: * remove some remnants of "Bug#14521864: MYSQL 5.1 TO 5.5 BUGS PARTITIONING" * introduce LOCK_share, now LOCK_ha_data is strictly for engines * rea_create_table() always creates .par file (even in "frm-only" mode) * fix a 5.6 bug, temp file leak on dummy ALTER TABLE
| * | | Fix a number of trivial test failures by updating error message:Sergey Petrunya2013-07-031-1/+1
| | | | | | | | | | | | | | | | | | | | | | | | "Unknown table tbl" is now "Unknown table database.tbl" (part#3)
* | | | Merge 5.5->10.0-baseIgor Babaev2013-03-311-5/+19
|\ \ \ \ | |/ / / |/| / / | |/ /
View Lorry Controller Status