summaryrefslogtreecommitdiff
path: root/mysql-test/r/derived_view.result
Commit message (Collapse)AuthorAgeFilesLines
* Create 'main' test directory and move 't' and 'r' thereMichael Widenius2018-03-291-2981/+0
|
* Tests: full test results [#387]Aleksey Midenkov2017-12-211-2/+0
|
* System Versioning 1.0 pre3Aleksey Midenkov2017-12-111-2/+2
|\ | | | | | | Merge branch '10.3' into trunk
| * Changed "const row not found" to "Const row not found"Monty2017-12-021-2/+2
| | | | | | | | | | Also changed Unique row not found to use uppercase first. This was done to make these messages consistent with the rest
* | Tests: TRT-related results [#305]Aleksey Midenkov2017-11-211-0/+2
| |
* | System Versioning pre0.12Aleksey Midenkov2017-11-071-0/+2
|\ \ | |/ |/| | | Merge remote-tracking branch 'origin/archive/2017-10-17' into 10.3
| * Scripts: VTMD table [closes #122]kevg2017-05-241-0/+2
| |
* | Merge remote-tracking branch 'origin/10.2' into bb-10.2-extAlexander Barkov2017-07-041-1/+1
|\ \
| * | Fixed the bug mdev-13193.Igor Babaev2017-06-291-1/+1
| | | | | | | | | | | | | | | | | | | | | | | | When an equality that can be pushed into a materialized derived table / view is extracted from multiple equalities and their operands are cloned then if they have some pointers to Item_equal objects those pointers must be set to NULL in the clones. Anyway they are not valid in the pushed predicates.
* | | Merge 10.2 into bb-10.2-extMarko Mäkelä2017-06-271-2/+2
|\ \ \ | |/ /
| * | Fixed the bug mdev-12845.Igor Babaev2017-06-221-2/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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-06-151-0/+59
|\ \ \ | |/ / | | / | |/ |/|
| * Merge 10.1 into 10.2Marko Mäkelä2017-05-231-0/+59
| |\
| | * Merge 10.0 into 10.1Marko Mäkelä2017-05-231-0/+21
| | |\
| | | * Merge branch '5.5' into 10.0mariadb-10.0.31Sergei Golubchik2017-05-201-0/+21
| | | |\
| | | | * Fixed the bug mdev-12812.Igor Babaev2017-05-171-0/+21
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | This is another correction of the patch for bug mdev-12670. If a derived table is merged into a select with STRAIGHT_JOIN modifier all IN subquery predicates contained in the specification of the derived table cannot be subject to conversion to semi-joins.
| | * | | Merge 10.0 into 10.1Marko Mäkelä2017-05-201-0/+38
| | |\ \ \ | | | |/ / | | | | | | | | | | | | | | | | | | | | Significantly reduce the amount of InnoDB, XtraDB and Mariabackup code changes by defining pfs_os_file_t as something that is transparently compatible with os_file_t.
| | | * | Merge remote-tracking branch 'origin/5.5' into 10.0Vicențiu Ciorbaru2017-05-171-0/+38
| | | |\ \ | | | | |/
| | | | * Fixed the bugs mdev-12670 and mdev-12675.Igor Babaev2017-05-091-0/+38
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | The code that blocked conversion of a IN subselect pedicate to a semi-join if it occurred in the ON expression of an outer join did not do it correctly. As a result, the conversion was blocked for IN subselect predicates encountered in ON expressions of INNER joins or in WHERE conditions of mergeable views / derived tables. This patch fixes this problem.
* | | | | Merge remote-tracking branch 'origin/10.2' into bb-10.2-extAlexander Barkov2017-03-311-0/+5
|\ \ \ \ \ | |/ / / /
| * | | | Merge branch '10.1' into 10.2Sergei Golubchik2017-03-301-0/+5
| |\ \ \ \ | | |/ / /
| | * | | MDEV-11943 I_S.TABLES inconsistencies with tables with unknown storage engineSergei Golubchik2017-03-101-0/+5
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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-24/+24
|/ / / / | | | | | | | | | | | | MDEV-10140: Add support for EXCEPT
* | | | Merge branch '10.1' into 10.2Sergei Golubchik2016-12-291-0/+85
|\ \ \ \ | |/ / /
| * | | Merge branch '10.0' into 10.1Sergei Golubchik2016-12-111-0/+85
| |\ \ \ | | |/ /
| | * | Merge branch '5.5' into 10.0Sergei Golubchik2016-12-091-0/+85
| | |\ \ | | | |/
| | | * Fixed bug mdev-11161.Igor Babaev2016-11-111-0/+83
| | | | | | | | | | | | | | | | | | | | | | | | | | | | The flag TABLE_LIST::fill_me must be reset to false at the prepare phase for any materialized derived table used in the executed query. Otherwise if the optimizer decides to generate a key for such a table it is generated only for the first execution of the query.
* | | | Item::print(): remove redundant parenthesesSergei Golubchik2016-12-121-55/+55
| | | | | | | | | | | | | | | | | | | | 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/+10
|\ \ \ \ | |/ / /
| * | | Merge branch '10.0' into 10.1Sergei Golubchik2016-08-251-0/+10
| |\ \ \ | | |/ /
| | * | Added new status variables to make it easier to debug certain problems:Monty2016-08-211-0/+10
| | | | | | | | | | | | | | | | | | | | | | | | - Handler_read_retry - Update_scan - Delete_scan
* | | | The code that pushed conditions into derived did notIgor Babaev2016-09-051-9/+48
| | | | | | | | | | | | | | | | | | | | take into account that the list of equal items in an Item_equal object may contain items with type() == REF_ITEM.
* | | | Fixed a flaw in the implementation of condition push-downIgor Babaev2016-09-041-6/+293
|/ / / | | | | | | | | | | | | | | | | | | | | | 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-9487: Server crashes in Time_and_counter_tracker::incr_loops with UNION ↵Oleksandr Byelkin2016-05-041-3/+3
| | | | | | | | | | | | | | | | | | in ALL subquery Do not mark subquery as inexpensive when it is not optimized.
* | | MDEV-6066: Merge new defaults from 5.6 and 5.7 (defaults changed, QC can be ↵Oleksandr Byelkin2015-09-041-8/+2
|/ / | | | | | | stopped with no-zero size)
* | Merge branch '5.5' into 10.0Sergei Golubchik2015-03-061-3/+3
|\ \ | |/
| * MDEV-6838 Using too big key for internal temp tablesSergei Golubchik2015-03-061-3/+3
| | | | | | | | update test results after the fix
* | 5.5 mergeSergei Golubchik2014-09-161-0/+88
|\ \ | |/
| * 5.3 mergeSergei Golubchik2014-09-121-0/+88
| |\
| | * Fixed bug mdev-5721.Igor Babaev2014-07-311-0/+88
| | | | | | | | | | | | | | | Do not define a look-up key for a temporary table if its length exceeds the maximum length of such keys.
* | | MDEV-6047: Make exists_to_in optimization ON by defaultunknown2014-06-091-1/+1
| | |
* | | 5.5 mergeSergei Golubchik2014-03-261-0/+40
|\ \ \ | |/ /
| * | 5.3-mergeSergei Golubchik2014-03-161-0/+40
| |\ \ | | |/
| | * MDEV-5740: Assertion ↵unknown2014-03-071-0/+40
| | | | | | | | | | | | | | | | | | | | | `!derived->first_select()->exclude_from_table_unique_test || derived->outer_select()-> exclude_from_table_unique_test' failed on 2nd execution of PS with derived_merge Do not check tables of executed units. Debug info about stages of derived tables execution added.
* | | 5.5 mergeSergei Golubchik2014-02-251-1/+1
|\ \ \ | |/ /
| * | 5.3 mergeSergei Golubchik2014-02-221-1/+1
| |\ \ | | |/
| | * After constant row substitution the optimizer should call the methodIgor Babaev2014-02-201-1/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | update_used_tables for the the where condition to update cached indicators of constant subexpressions. It should be done before further possible simplification of the where condition. This change caused simplification of the executed where conditions in many test cases.
* | | 5.5 mergeSergei Golubchik2014-02-011-0/+109
|\ \ \ | |/ /
| * | Merge 5.3->5.5unknown2014-01-151-0/+109
| |\ \ | | |/
| | * MDEV-5414: RAND() in a subselect : different behavior in MariaDB and MySQLunknown2013-12-181-0/+109
| | | | | | | | | | | | | | | | | | Materialization forced in case if rand() used in view or derived table to avoud several calls of rand for gting value of a field. Fixed set variable uncachable flag from - it shouldbe a side effect not a random value.
View Lorry Controller Status