summaryrefslogtreecommitdiff
path: root/mysql-test/r/explain_json.result
Commit message (Collapse)AuthorAgeFilesLines
* Create 'main' test directory and move 't' and 'r' thereMichael Widenius2018-03-291-1646/+0
|
* Merge bb-10.2-ext into 10.3Marko Mäkelä2018-01-041-0/+60
|\
| * Merge remote-tracking branch 'origin/10.2' into bb-10.2-extMonty2018-01-011-0/+60
| |\ | | | | | | | | | | | | | | | | | | | | | | | | | | | Conflicts: cmake/make_dist.cmake.in mysql-test/r/func_json.result mysql-test/r/ps.result mysql-test/t/func_json.test mysql-test/t/ps.test sql/item_cmpfunc.h
| | * MDEV-10844: EXPLAIN FORMAT=JSON doesn't show order direction for filesortVarun Gupta2017-12-301-0/+60
| | | | | | | | | | | | | | | Currently explain format=json does not show the order direction of fields used during filesort. This patch would remove this limitation
* | | Changed "const row not found" to "Const row not found"Monty2017-12-021-1/+1
|/ / | | | | | | | | Also changed Unique row not found to use uppercase first. This was done to make these messages consistent with the rest
* | Merge 10.2 into bb-10.2-extMarko Mäkelä2017-09-251-3/+3
|\ \ | |/
| * Merge 10.1 into 10.2Marko Mäkelä2017-09-251-3/+3
| |\
| | * MDEV-8840: ANALYZE FORMAT=JSON produces wrong data with BKAVarun Gupta2017-09-241-3/+3
| | | | | | | | | | | | | | | | | | The issue was that r_loops, r_rows and r_filtered in ANALYZE FORMAT= JSON were not calculated for the table on which we were performing the MRR scan in the BKA join Fixed this by adding respective counter in the JOIN_TAB_SCAN_MRR::open and JOIN_TAB_SCAN_MRR::next
| | * MDEV-10880: Assertions `keypart_map' or `prebuilt->search_tuple->n_fields > ↵Oleksandr Byelkin2017-06-231-9/+9
| | | | | | | | | | | | | | | | | | 0' fail on DISTINCT and GROUP BY constant add_group_and_distinct_keys() should take into account JOIN::simple_group.
* | | Merge tag 'mariadb-10.2.6' into bb-10.2-extAlexander Barkov2017-05-261-2/+2
|\ \ \ | |/ /
| * | Merge branch '10.1' into 10.2Sergei Golubchik2017-05-091-2/+2
| |\ \ | | |/ | | | | | | | | | Revert commit db0917f68f, because the fix for MDEV-12696 is coming from 5.5 and 10.1 in this merge.
| | * Merge branch '10.0' 10.1Sergei Golubchik2017-04-281-1/+1
| | |
| * | MDEV-10355 Weird error message upon CREATE TABLE with DEFAULTSergei Golubchik2017-04-301-3/+3
| | | | | | | | | | | | | | | | | | | | | post-fix for 0b52b28b91 * restore EXPLAIN output * remove redundant code
| * | MDEV-10355 Weird error message upon CREATE TABLE with DEFAULTbb-10.2-MDEV-10355Jacob Mathew2017-04-181-3/+3
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Fixed handling of default values with cached temporal functions so that the CREATE TABLE statement now succeeds. Fixed virtual column session cleanup. Fixed the error message. Added quoting of date/time values in cases when this was omitted. Added a test case in default.test. Updated test result files.
* | | MDEV-10141: Add support for INTERSECT (and common parts for EXCEPT)Oleksandr Byelkin2017-03-141-0/+2
|/ / | | | | | | MDEV-10140: Add support for EXCEPT
* | Item::print(): remove redundant parenthesesSergei Golubchik2016-12-121-45/+45
| | | | | | | | | | by introducing new Item::precedence() method and using it to decide whether parentheses are required
* | Fixed a flaw in the implementation of condition push-downIgor Babaev2016-09-041-0/+1
| | | | | | | | | | | | | | | | for materialized views and derived tables: there were no push-down if the view was defined as union of selects without aggregation. Added test cases with such unions. Adjusted result files after the merge of the code for mdev-9197.
* | Merge branch '10.2' into 10.2-mdev9864Galina Shalygina2016-05-081-7/+5
| |
* | MDEV-9652: EXPLAIN FORMAT=JSON should show outer_ref_condSergei Petrunia2016-02-281-0/+40
|/ | | | Show outer_ref_condition in EXPLAIN FORMAT=JSON output.
* Fix typos in JSON MRR outputSergei Petrunia2015-09-241-2/+2
|
* MDEV-8829: Assertion `0' failed in Explain_table_access::tag_to_jsonSergei Petrunia2015-09-241-0/+349
| | | | - Add EXPLAIN/ANALYZE FORMAT=JSON handling for a few special cases.
* MDEV-7970: EXPLAIN FORMAT=JSON does not print HAVINGOleksandr Byelkin2015-09-181-0/+84
| | | | Printing non-trivial HAVING added.
* MDEV-8785 Wrong results for EXPLAIN EXTENDED...WHERE NULLIF(latin1_col, ↵Alexander Barkov2015-09-101-0/+20
| | | | _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/+20
|
* MDEV-6066: Merge new defaults from 5.6 and 5.7 (defaults changed, QC can be ↵Oleksandr Byelkin2015-09-041-6/+6
| | | | stopped with no-zero size)
* Update test resultsSergei Petrunia2015-07-021-16/+22
|
* MDEV-7836: ANALYZE FORMAT=JSON should provide info about GROUP/ORDER BYSergei Petrunia2015-04-121-14/+18
| | | | | Fix EXPLAIN FORMAT=JSON to produce output that's not worse than the tabular form.
* MergeSergei Petrunia2015-04-121-0/+6
|\
| * MDEV-7835: ANALYZE FORMAT=JSON should show buffer sizesOleksandr Byelkin2015-04-091-0/+6
| |
* | MDEV-7836: ANALYZE FORMAT=JSON should provide info about GROUP/ORDER BYSergei Petrunia2015-04-121-15/+24
|/ | | | Provide basic info about sorting/grouping done by the queries.
* MDEV-7860: EXPLAIN FORMAT=JSON crashes for loose scan querySergei Petrunia2015-04-081-0/+139
| | | | | | | (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/+12
| | | | | - 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/+29
|
* Update test resultsbb-10.1-explain-jsonSergei Petrunia2014-12-061-35/+35
|
* Merge bb-10.1-explain-json into 10.1Sergei Petrunia2014-12-061-1/+53
|\
| * EXPLAIN FORMAT=JSON : Fix MDEV-7266, bug in pretty-printerSergei Petrunia2014-12-061-1/+1
| | | | | | | | | | | | - Single_line_formatting_helper should not accidentally exit the DISABLED state. No JSON construct should be able to move the Single_line_formatting_helper from DISABLED state.
| * EXPLAIN JSON: Print out the "expensive constant condition" attached to joins.Sergei Petrunia2014-12-061-0/+52
| |
* | MDEV-7264: Assertion `0' failed in subselect_engine::get_identifier()Sergei Petrunia2014-12-061-0/+35
|/ | | | | | | | 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/+59
|
* EXPLAIN FORMAT=JSON: Support "range checked for each record"Sergei Petrunia2014-12-061-0/+26
|
* EXPLAIN FORMAT=JSON: Support range+MRR plans (when MRR is used but BKA is not)Sergei Petrunia2014-12-061-0/+27
|
* EXPLAIN FORMAT=JSONSergei Petrunia2014-12-021-0/+72
| | | | | Add support for semi-join strategies: FirstMatch, DuplicateWeedout, LooseScan.
* EXPLAIN FORMAT=JSON: support SJ-MaterializationSergei Petrunia2014-12-011-1/+53
| | | | | | | | - 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/+36
|
* EXPLAIN FORMAT=JSON: Add support for non-merged semi-joinsSergei Petrunia2014-11-291-0/+42
|
* EXPLAIN FORMAT=JSON: support derived tablesSergei Petrunia2014-11-281-0/+71
|
* Make explain_json.test pass on case-insensitive FS.Sergei Petrunia2014-11-281-7/+7
|
* EXPLAIN FORMAT=JSON: Add support for single-table UPDATE/DELETE.Sergei Petrunia2014-11-281-4/+55
|
* EXPLAIN FORMAT=JSON: support join bufferingSergei Petrunia2014-11-271-0/+33
| | | | | | | | | - 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/+134
| | | | | | | | | | 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.
View Lorry Controller Status