summaryrefslogtreecommitdiff
path: root/mysql-test/main/subselect_cache.result
Commit message (Collapse)AuthorAgeFilesLines
* MDEV-30032: EXPLAIN FORMAT=JSON output: part #2: print 'loops'.Sergei Petrunia2023-02-031-0/+10
|
* MDEV-30032: EXPLAIN FORMAT=JSON output: print costsSergei Petrunia2023-02-031-0/+20
| | | | Basic printout for join and table execution costs.
* MDEV-28926 Add time spent on query optimizer to JSON ANALYZE (#2193)Luis Eduardo Oliveira Lizardo2022-10-261-0/+6
| | | | | | | | * Add query optimizer timer to ANALYZE FORMAT=JSON * Adapt tests and results * Change logic to always close the writer after printing query blocks
* Merge 10.7 into 10.8Marko Mäkelä2022-07-281-96/+96
|\
| * Merge 10.4 into 10.5Marko Mäkelä2022-07-271-96/+96
| |\
| | * MDEV-21445 Strange/inconsistent behavior of IN condition when mixing numbers ↵Alexander Barkov2022-07-061-96/+96
| | | | | | | | | | | | and strings
* | | MDEV-27036: resolve duplicated key issues of JSON tracing outputs:Sergei Krivonos2021-11-261-91/+131
|/ / | | | | | | | | | | | | | | | | | | | | MDEV-27036: repeated "table" key resolve for print_explain_json MDEV-27036: duplicated keys in best_access_path MDEV-27036: Explain_aggr_filesort::print_json_members: resolve duplicated "filesort" member in Json object MDEV-27036: Explain_basic_join:: print_explain_json_interns fixed start_dups_weedout case for main.explain_json test
* | MDEV-20854: ANALYZE for statements: not clear where the time is spentSergei Petrunia2019-11-121-5/+10
| | | | | | | | | | | | | | | | | | | | | | | | | | Count the "gap" time between table accesses and display it as r_other_time_ms in the "table" element. * The advantage of this approach is that it doesn't add any new my_timer_cycles() calls. * The disadvantage is that the definition of what is done during "other time" is not that clear: it includes checking the WHERE (for this table), constructing index lookup tuple (for the next table) writing to GROUP BY temporary table (as we dont account for that time separately [yet], etc)
* | MDEV-19713 Remove big_tables system variableSergei Golubchik2019-09-281-2/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | mark big_tables deprecated, the server can put temp tables on disk as needed avoiding "table full" errors. in case someone would really need to force a tmp table to be created on disk from the start and for testing allow tmp_memory_table_size to be set to 0. fix tests to use that instead (and add a test that it actually works). make sure in-memory TREE size limit is never 0 (it's [ab]using tmp_memory_table_size at the moment) remove few sys_vars.*_basic tests
* | removes references to a sysvar that disappeared 6 years agoSergei Golubchik2019-09-281-1/+1
|/
* Merge branch '10.2' into 10.3Oleksandr Byelkin2019-07-261-0/+2
|
* Create 'main' test directory and move 't' and 'r' thereMichael Widenius2018-03-291-0/+3805