summaryrefslogtreecommitdiff
path: root/mysql-test/main/subselect_sj.result
Commit message (Collapse)AuthorAgeFilesLines
* Merge branch '10.2' into 10.3Oleksandr Byelkin2019-10-311-0/+26
|
* Merge branch '10.2' into 10.3Monty2019-09-031-21/+25
|
* MDEV-20109: Optimizer ignores distinct key created for materialized...Sergei Petrunia2019-08-301-1/+1
| | | | Adjust the testcase according to the review input
* MDEV-20109: Optimizer ignores distinct key created for materialized...Sergei Petrunia2019-08-301-18/+42
| | | | | | | | | | | | | | | (Backported to 10.3, addressed review input) Sj_materialization_picker::check_qep(): fix error in cost/fanout calculations: - for each join prefix, add #prefix_rows / TIME_FOR_COMPARE to the cost, like best_extension_by_limited_search does - Remove the fanout produced by the subquery tables. - Also take into account join condition selectivity optimize_wo_join_buffering() (used by LooseScan and FirstMatch) - also add #prefix_rows / TIME_FOR_COMPARE to the cost of each prefix. - Also take into account join condition selectivity
* MDEV-19600: The optimizer should be able to produce rows=1 estimate for ↵bb-10.3-mdev19600Sergei Petrunia2019-06-051-9/+65
| | | | | | | unique index with NULLable columns Modify best_access_path() to produce rows=1 estimate for null-rejecting lookups on unique NULL keys.
* Merge 10.2 into 10.3Marko Mäkelä2019-05-291-0/+1
|
* Merge remote-tracking branch 'origin/10.2' into 10.3Alexander Barkov2019-03-221-0/+7
|
* Merge branch '10.2' into 10.3Sergei Golubchik2018-05-111-0/+26
|
* Create 'main' test directory and move 't' and 'r' thereMichael Widenius2018-03-291-0/+3168