summaryrefslogtreecommitdiff
path: root/mysql-test/t/explain_json.test
Commit message (Collapse)AuthorAgeFilesLines
* MDEV-7860: EXPLAIN FORMAT=JSON crashes for loose scan querySergei Petrunia2015-04-081-0/+71
| | | | | | | (Based on original patch by Sanja Byelkin) Make the code that produces JSON output handle LooseScan quick select. The output we produce is compatible with MySQL 5.6.
* MDEV-7927: Server crashes in in Time_and_counter_tracker::incr_loopsSergei Petrunia2015-04-081-0/+8
| | | | | - JOIN::save_explain_data should also set JOIN::tracker (it already sets join_tab[0].tracker). This is needed for UNIONs inside subqueries.
* Add a testcase for EXPLAIN FORMAT=JSON for ROR-union index_merge.Sergei Petrunia2015-02-171-0/+3
|
* Merge bb-10.1-explain-json into 10.1Sergei Petrunia2014-12-061-1/+19
|\
| * EXPLAIN JSON: Print out the "expensive constant condition" attached to joins.Sergei Petrunia2014-12-061-1/+19
| |
* | MDEV-7264: Assertion `0' failed in subselect_engine::get_identifier()Sergei Petrunia2014-12-061-0/+12
|/ | | | | | | | Switch EXPLAIN JSON from using subselect_engine::get_identifier() to the number from Item_subselect::unit. Remove subselect_union_engine::get_identifier() because it was added only for EXPLAIN JSON code.
* EXPLAIN FORMAT=JSON: Full scan on NULL key (join case)Sergei Petrunia2014-12-061-0/+14
|
* EXPLAIN FORMAT=JSON: Support "range checked for each record"Sergei Petrunia2014-12-061-0/+5
|
* EXPLAIN FORMAT=JSON: Support range+MRR plans (when MRR is used but BKA is not)Sergei Petrunia2014-12-061-0/+12
|
* EXPLAIN FORMAT=JSONSergei Petrunia2014-12-021-0/+19
| | | | | Add support for semi-join strategies: FirstMatch, DuplicateWeedout, LooseScan.
* EXPLAIN FORMAT=JSON: support SJ-MaterializationSergei Petrunia2014-12-011-1/+10
| | | | | | | | - Switch Explain data structure from "flat" representation of SJ-Materialization into nested one. - Update functions that print tabular output to operate on the nested structure. - Add function to generate JSON output.
* EXPLAIN FORMAT=JSON: support EXPLAIN FORMAT=JSON INSERT ...Sergei Petrunia2014-11-291-1/+8
|
* EXPLAIN FORMAT=JSON: Add support for non-merged semi-joinsSergei Petrunia2014-11-291-0/+6
|
* EXPLAIN FORMAT=JSON: support derived tablesSergei Petrunia2014-11-281-0/+13
|
* Make explain_json.test pass on case-insensitive FS.Sergei Petrunia2014-11-281-2/+2
|
* EXPLAIN FORMAT=JSON: Add support for single-table UPDATE/DELETE.Sergei Petrunia2014-11-281-0/+10
|
* EXPLAIN FORMAT=JSON: support join bufferingSergei Petrunia2014-11-271-0/+12
| | | | | | | | | - Basic support for JOIN buffering - The output is not polished but catches the main point: tab->select_cond and tab->cache_select->cond are printed separately. - Hash join support is poor still. - Also fixed identation in JOIN_TAB::save_explain_data
* EXPLAIN FORMAT=JSON: further developmentSergei Petrunia2014-11-271-0/+20
| | | | | | | | | | Writing JSON: - Fix a bug in Single_line_formatting_helper - Add Json_writer_nesting_guard - safety class EXPLAIN JSON support - Add basic subquery support - Add tests for UNION/UNION ALL.
* Make testsuite to passSergei Petrunia2014-11-211-1/+1
| | | | | | | | - Drop all tables in explain_json.test - Tabular form should print ref='' when type='fulltext' (another peculiarity of the traditional EXPLAIN format) - String_list::append_str should allocate memory for \0, too - Some temporary code for EXPLAIN JSON and join buffering.
* EXPLAIN FORMAT=JSON: produce used_key_parts, JSON-ish output for index_merge.Sergei Petrunia2014-08-141-3/+18
|
* MDEV-6109: EXPLAIN JSONSergei Petrunia2014-08-121-9/+9
| | | | Add pretty-printing of possible_keys column.
* MDEV-6109: EXPLAIN JSONSergei Petrunia2014-08-091-0/+27
- Add first testcases - Don't overquote when printing conditions - Other small output fixes