summaryrefslogtreecommitdiff
path: root/mysql-test/t/explain_json.test
Commit message (Collapse)AuthorAgeFilesLines
* Create 'main' test directory and move 't' and 'r' thereMichael Widenius2018-03-291-419/+0
|
* MDEV-10844: EXPLAIN FORMAT=JSON doesn't show order direction for filesortVarun Gupta2017-12-301-0/+11
| | | | | Currently explain format=json does not show the order direction of fields used during filesort. This patch would remove this limitation
* Merge branch '10.1' into 10.2Sergei Golubchik2017-02-101-5/+5
|\
| * MDEV-11866: ANALYZE FORMAT=JSON not predicatable for ↵Daniel Black2017-01-231-5/+5
| | | | | | | | | | | | | | | | | | | | | | | | | | r_total_time_ms/r_buffer_size [0-9]*[.]?[0-9]* wasn't a sufficient regex to cover the %lg used in Json_writer::add_double. Exponent formats where missed. Here we normalize all the replace_regex expressions for ANALYZE FORMAT=JSON into one include file. Signed-off-by: Daniel Black <daniel.black@au.ibm.com>
* | MDEV-9652: EXPLAIN FORMAT=JSON should show outer_ref_condSergei Petrunia2016-02-281-0/+10
|/ | | | Show outer_ref_condition in EXPLAIN FORMAT=JSON output.
* MDEV-8829: Assertion `0' failed in Explain_table_access::tag_to_jsonSergei Petrunia2015-09-241-0/+80
| | | | - Add EXPLAIN/ANALYZE FORMAT=JSON handling for a few special cases.
* MDEV-7970: EXPLAIN FORMAT=JSON does not print HAVINGOleksandr Byelkin2015-09-181-1/+23
| | | | Printing non-trivial HAVING added.
* MDEV-8785 Wrong results for EXPLAIN EXTENDED...WHERE NULLIF(latin1_col, ↵Alexander Barkov2015-09-101-0/+8
| | | | _utf8'a' COLLATE utf8_bin) IS NOT NULL
* MDEV-8786 Wrong result for SELECT FORMAT=JSON * FROM t1 WHERE a=_latin1 0xDFAlexander Barkov2015-09-101-0/+7
|
* 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
View Lorry Controller Status