summaryrefslogtreecommitdiff
path: root/mysql-test/main/table_value_constr.result
Commit message (Collapse)AuthorAgeFilesLines
* Merge 10.3 into 10.4Marko Mäkelä2018-09-111-0/+92
|\
| * MDEV-16930 Crash when VALUES in derived table contains expressionsIgor Babaev2018-08-211-0/+35
| | | | | | | | | | | | | | | | | | | | | | | | This patch always provides columns of the temporary table used for materialization of a table value constructor with some names. Before this patch these names were always borrowed from the items of the first row of the table value constructor. When this row contained expressions and expressions were not named then it could cause different kinds of problems. In particular if the TVC is used as the specification of a derived table this could cause a crash. The names given to the expressions used in a TVC are the same as those given to the columns of the result set from the corresponding SELECT.
| * MDEV-17017 Explain for query using derived table specified with a tableIgor Babaev2018-08-211-0/+57
| | | | | | | | | | | | | | | | | | | | value constructor shows wrong number of rows If the specification of a derived table contained a table value constructor then the optimizer incorrectly estimated the number of rows in the derived table. This happened because the optimizer did not take into account the number of rows in the constructor. The wrong estimate could lead to choosing inefficient execution plans.
* | MDEV-11953: support of brackets in UNION/EXCEPT/INTERSECT operationsOleksandr Byelkin2018-07-041-1/+0
|/
* MDEV-16038 Assertion `map->n_bits > 0' failed (my_bitmap.c:386: ↵Igor Babaev2018-04-261-1/+6
| | | | | | | bitmap_is_clear_all) Rows with no elements are not allowed in a table value constructor unless it is used in an INSERT statement.
* MDEV-15940 Crash when using CURSOR with VALUES()Igor Babaev2018-04-211-0/+21
| | | | | | The function st_select_lex_unit::get_column_types() should take into account that a unit may contain only a table value constructor and nothing more.
* Create 'main' test directory and move 't' and 'r' thereMichael Widenius2018-03-291-0/+2073