summaryrefslogtreecommitdiff
path: root/mysql-test/r/derived.result
Commit message (Collapse)AuthorAgeFilesLines
* Create 'main' test directory and move 't' and 'r' thereMichael Widenius2018-03-291-1164/+0
|
* Merge bb-10.2-ext into 10.3Marko Mäkelä2018-02-151-0/+41
|\
| * Merge remote-tracking branch 'origin/10.2' into bb-10.2-extAlexander Barkov2018-02-081-0/+41
| |\
| | * Merge branch 'github/10.1' into 10.2Sergei Golubchik2018-02-061-0/+41
| | |\
| | | * Merge branch 'github/10.0' into 10.1Sergei Golubchik2018-02-021-0/+41
| | | |\
| | | | * Merge remote-tracking branch '5.5' into 10.0Vicențiu Ciorbaru2018-01-241-0/+41
| | | | |\
| | | | | * MDEV-14786: Server crashes in Item_cond::transform on 2nd execution of SP ↵Oleksandr Byelkin2018-01-231-0/+16
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | querying from a view MDEV-14957: JOIN::prepare gets unusable "conds" as argument Do not touch merged derived (it is irreversible) Fix first argument of in_optimizer for calls possible before fix_fields()
| | | | | * MDEV-14241: Server crash in key_copy / get_matching_chain_by_join_key or ↵Varun Gupta2018-01-191-0/+25
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | valgrind warnings In this case we were using the optimization derived_with_keys but we could not create a key because the length of the key was greater than the max allowed(MI_MAX_KEY_LENGTH). To do the join we needed to create a hash join key instead, but in the explain output it showed that we were still referring to derived keys which were created but not used.
* | | | | | Changed "const row not found" to "Const row not found"Monty2017-12-021-28/+28
|/ / / / / | | | | | | | | | | | | | | | | | | | | Also changed Unique row not found to use uppercase first. This was done to make these messages consistent with the rest
* | | | | Merge 10.2 into bb-10.2-extMarko Mäkelä2017-06-271-1/+1
|\ \ \ \ \ | |/ / / /
| * | | | Fixed the bug mdev-12845.Igor Babaev2017-06-221-1/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | This patch fills in a serious flaw in the code that supports condition pushdown into materialized views / derived tables. If a predicate happened to contain a reference to a mergeable view / derived table and it does not depended directly on the target materialized view / derived table then the predicate was not considered as a subject to pusdown to this view / derived table.
* | | | | Merge remote-tracking branch 'origin/10.2' into bb-10.2-extAlexander Barkov2017-03-311-0/+23
|\ \ \ \ \ | |/ / / /
| * | | | Merge branch '10.1' into 10.2Sergei Golubchik2017-03-301-0/+23
| |\ \ \ \ | | |/ / /
| | * | | Merge 10.0 into 10.1Marko Mäkelä2017-03-091-0/+23
| | |\ \ \ | | | |/ / | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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 branch '5.5' into 10.0Vicențiu Ciorbaru2017-03-031-0/+23
| | | |\ \ | | | | |/
| | | | * Fixed bug mdev-9028.Igor Babaev2017-02-161-0/+23
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | This patch is actually a complement for the fix of bug mdev-6892. The procedure create_tmp_table() now must take into account Item_direct_refs that wrap up constant fields of derived tables/views that are used as inner tables in outer join operations.
* | | | | Merge remote-tracking branch 'origin/10.2' into bb-10.2-extAlexander Barkov2017-03-181-0/+16
|\ \ \ \ \ | |/ / / /
| * | | | MDEV-11363: Assertion `!derived->first_sel ect()->first_inner_unit() || ↵Oleksandr Byelkin2017-03-091-0/+16
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | derived->first_select()->first_inner_unit()->first_select()-> exclude_from_table_unique_test' failed in TABLE_LIST::set_check_materialized() Do not try to materialize derived table which already merged (irreversebly).
* | | | | MDEV-10141: Add support for INTERSECT (and common parts for EXCEPT)Oleksandr Byelkin2017-03-141-1/+1
|/ / / / | | | | | | | | | | | | MDEV-10140: Add support for EXCEPT
* | | | MDEV-10554: Assertion ↵Oleksandr Byelkin2017-02-101-0/+18
| | | | | | | | | | | | | | | | | | | | | | | | `!derived->first_select()->exclude_from_table_unique_test || derived->outer_select()-> exclude_from_table_unique_test' failed in TABLE_LIST::set_check_merged() Mark and check excluded because of merging derived tables and views.
* | | | Merge branch '10.1' into 10.2Sergei Golubchik2016-12-291-0/+65
|\ \ \ \ | |/ / /
| * | | Merge branch '10.0' into 10.1Sergei Golubchik2016-12-111-0/+65
| |\ \ \ | | |/ /
| | * | Merge branch '5.5' into 10.0Sergei Golubchik2016-12-091-0/+65
| | |\ \ | | | |/
| | | * MDEV-10663: Use of Inline table columns in HAVING clause throws 1463 ErrorOleksandr Byelkin2016-12-061-0/+65
| | | | | | | | | | | | | | | | check for VIEW/DERIVED fields
* | | | 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
* | | | Merge branch '10.1' into 10.2Sergei Golubchik2016-09-091-2/+2
|\ \ \ \ | |/ / /
| * | | MDEV-10470: main.derived fails, buildbot is brokenSergei Petrunia2016-08-011-2/+2
| | | | | | | | | | | | | | | | - Update test result (checked)
* | | | MDEV-6720 - enable connection log in mysqltest by defaultSergey Vojtovich2016-03-311-0/+5
|/ / /
* | | Merge branch '10.0' into 10.1Sergei Golubchik2016-02-231-0/+345
|\ \ \ | |/ /
| * | Merge branch '5.5' into 10.0Sergei Golubchik2016-02-151-0/+345
| |\ \ | | |/
| | * MDEV-9462: Out of memory using explain on 2 empty tablesOleksandr Byelkin2016-02-061-0/+319
| | | | | | | | | | | | Fixed adding derived tables items to outer one.
| | * MDEV-7827: Assertion `!table || (!table->read_set || ↵Oleksandr Byelkin2016-02-051-0/+25
| | | | | | | | | | | | | | | | | | | | | bitmap_is_set(table->read_set, field_index))' failed in Field_long::val_str on EXPLAIN EXTENDED (Solution by Sergei Petrunia) It appeared that semijoin conditions was not iterated when we were updating used tables. So now they do.
* | | MDEV-8747 Wrong result for SELECT..WHERE derived_table_column='a' AND ↵Alexander Barkov2015-09-061-0/+45
| | | | | | | | | | | | | | | | | | derived_table_column<>_latin1'A' COLLATE latin1_bin MDEV-8749 Wrong result for SELECT..WHERE derived_table_enum_column='number' AND derived_table_enum_column OP number
* | | Merge branch '10.0' into 10.1Sergei Golubchik2015-09-031-1/+26
|\ \ \ | |/ / | | | | | | | | | referenced_by_foreign_key2(), needed for InnoDB to compile, was taken from 10.0-galera
| * | MDEV-6219: Server crashes in Bitmap<64u>::merge (this=0x180, map2=...) on ↵Oleksandr Byelkin2015-08-311-1/+26
| |/ | | | | | | | | | | | | | | 2nd execution of PS with INSERT .. SELECT, derived_merge Problem: Not all permanent Item_direct_view_ref was in permanent list of used items of the view. Solution: Detect creating permenent view/derived table reference and put them in the permanent list at once.
* | Merge tag 'mariadb-10.0.19' into 10.1Sergei Golubchik2015-06-011-0/+12
|\ \ | |/
| * MDEV-6892: WHERE does not applyOleksandr Byelkin2015-04-231-0/+12
| | | | | | | | | | | | | | | | Taking into account implicit dependence of constant view field from nullable table of left join added. Fixed finding real table to check if it turned to NULL (materialized view & derived taken into account) Removed incorrect uninitialization.
* | MDEV-334: Backport of UNION ALL optimization from mysql-5.7.Igor Babaev2014-10-141-1/+0
|/ | | | | | Although the original code of mysql-5.7 was adjusted to the current MariaDB code the main ideas of the optimization were preserved.
* MDEV-6163: Error while executing an update query that has the same table in ↵unknown2014-06-041-0/+14
| | | | | | a sub-query We have to run the derived table prepare before the unique table check to mark the derived table (in this case the unique table check can turn that table to materialized one).
* merge 5.3->5.5unknown2014-01-261-0/+22
|\
| * merge of MDEV-5356 5.1->5.3 (with more fixes and test suite).unknown2014-01-231-0/+22
| |\ | | | | | | | | | | | | | | | | | | | | | | | | THD::thd->activate_stmt_arena_if_needed() should be used to temporary activating statement arena instead of direct usage of THD::set_n_backup_active_arena() because possible such scenario: 1) func1 saves current arena and activates copy1 of statement arena 2) func2 saves copy1 of statement arena setup by func1 and activates copy2 3) some changes made for copy 2 4) func2 stores changed copy2 back to statenet arena and activates copy1 5) func1 store unchanged copy1 back to statemnt arena (rewrite changed copy 2 so changes become lost) and activates arena which was before.
* | \ 5.3 mergeSergei Golubchik2013-12-131-0/+14
|\ \ \ | |/ /
| * | MDEV-5353: server crash on subselect if WHERE applied to some result fieldunknown2013-12-041-0/+14
| | | | | | | | | | | | Correct processing of view/derived with no tables added.
* | | Merge 5.3->5.5unknown2013-10-291-0/+27
|\ \ \ | |/ /
| * | MDEV-5143: update of a joined table with a nested subquery with a syntax ↵unknown2013-10-211-0/+27
| | | | | | | | | | | | | | | | | | | | | error crashes mysqld with signal 11 Added check of SELECT_LEX::handle_derived() result.
* | | MDEV-5012 Server crashes in Item_ref::real_item on EXPLAIN with select ↵Sergei Golubchik2013-09-131-0/+14
| | | | | | | | | | | | | | | | | | subqueries or views, constant table, derived_merge+derived_with_keys revert incorrect change, merged from mysql-5.5
* | | merge 5.3->5.5unknown2013-09-131-1/+24
|\ \ \ | |/ /
| * | MDEV-5005: Subquery in Procedure somehow affecting temporary tableunknown2013-09-121-0/+23
| | | | | | | | | | | | Removed unneeded set of TABLE_LIST::skip_temporary flag.
* | | merge with mysql-5.5.30 minus few incorrect or not applicable changesetsSergei Golubchik2013-02-281-0/+13
|\ \ \
* \ \ \ 5.3 mergeSergei Golubchik2012-01-131-3/+7
|\ \ \ \ | | |/ / | |/| |
View Lorry Controller Status