summaryrefslogtreecommitdiff
path: root/sql
Commit message (Collapse)AuthorAgeFilesLines
* EXPLAIN FORMAT=JSON: Do set usable_key_parts for key in the temp. tableSergei Petrunia2014-12-021-0/+1
| | | | | | If we didn't do it, SJ-Materialization table would appear to EXPLAIN JSON code as having different keyparts than it actually has. This caused unpredictable content in "used_key_parts"
* Merge ../10.1 into bb-10.1-explain-jsonSergei Petrunia2014-12-0214-59/+914
|\
| * MDEV-7245: Incorrect display of subquery cache in union.resultSergei Petrunia2014-12-021-0/+3
| | | | | | | | - Do set nest_level and nest_level_base for fake_select_lex objects.
| * don't skip wsrep position recovery silentlySergei Golubchik2014-12-011-1/+4
| | | | | | | | | | | | control scripts (mysqld_safe for example) want to know whether a recovery was successful or not. total silence is too suspicious to be trusted.
| * MDEV-7188 main.signal_demo3 and sys_vars.max_sp_recursion_depth_func fail in ↵Sergei Golubchik2014-12-011-25/+2
| | | | | | | | | | | | biuldbot on labrador with Thread stack overrun reduce stack requirememnts for CALL by just a little bit
| * MDEV-4412 : SLOW QUERY LOG - add affected rows (UPDATE / DELETE) in slow ↵Nirbhay Choubey2014-11-301-3/+13
| | | | | | | | | | | | query log Added Rows_affected to slow query log & mysql.slow_log table.
| * MDEV-4018 : Feature Request: microseconds in GET_LOCK()Nirbhay Choubey2014-11-303-8/+8
| | | | | | | | | | Updated MDL_context's lock methods to accept double precision lock_wait_timeout.
| * MDEV-6961: mysqld should terminate when started with --wsrep-recoverNirbhay Choubey2014-11-301-2/+3
| | | | | | | | | | Fixed the condition to make sure mysqld process terminates when started with wsrep-recover.
| * MDEV-4045 Missing OGC Spatial functions.Alexey Botchkov2014-11-287-21/+882
| | | | | | | | | | | | | | | | | | | | | | | | Missing GIS functions added: IsRing() PointOnSurface PointOnSurface Relate Distance Intersection ConvexHull Other old OpenGis standard inconsistencies fixed.
* | EXPLAIN FORMAT=JSON: support SJ-MaterializationSergei Petrunia2014-12-013-73/+188
| | | | | | | | | | | | | | | | - 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-292-6/+16
| |
* | ANALYZE FORMAT=JSON: better output and testsSergei Petrunia2014-11-294-8/+55
| | | | | | | | | | | | - Print r_loops - Always print r_* members. Print NULL values if no scans took place - Added testcases.
* | EXPLAIN FORMAT=JSON: Add support for non-merged semi-joinsSergei Petrunia2014-11-295-7/+69
| |
* | EXPLAIN FORMAT=JSON: support derived tablesSergei Petrunia2014-11-284-9/+57
| |
* | EXPLAIN FORMAT=JSON: Add support for single-table UPDATE/DELETE.Sergei Petrunia2014-11-287-193/+344
| |
* | EXPLAIN FORMAT=JSON: support join bufferingSergei Petrunia2014-11-273-12/+52
| | | | | | | | | | | | | | | | | | - 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-277-14/+144
| | | | | | | | | | | | | | | | | | | | 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.
* | Merge ../10.1-explain-json-r4 into 10.1Sergei Petrunia2014-11-2718-155/+1114
|\ \ | |/ |/|
| * Make testsuite to passSergei Petrunia2014-11-211-2/+13
| | | | | | | | | | | | | | | | - 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.
| * Better commentsSergei Petrunia2014-11-211-1/+7
| |
| * Better commentsSergei Petrunia2014-11-202-0/+24
| |
| * Merge ../10.1 into bb-10.1-explain-jsonSergei Petrunia2014-10-15126-21330/+12836
| |\
| * | EXPLAIN FORMAT=JSON: produce used_key_parts, JSON-ish output for index_merge.Sergei Petrunia2014-08-144-39/+146
| | |
| * | EXPLAIN FORMAT=JSON: produce the 'ref' column.Sergei Petrunia2014-08-123-41/+48
| | |
| * | MDEV-6109: EXPLAIN JSONSergei Petrunia2014-08-122-16/+266
| | | | | | | | | | | | Add pretty-printing of possible_keys column.
| * | MDEV-6109: EXPLAIN JSONSergei Petrunia2014-08-096-20/+32
| | | | | | | | | | | | | | | | | | - Add first testcases - Don't overquote when printing conditions - Other small output fixes
| * | Merge 10.1 (with ANALYZE) and 10.1-explain-jsonSergei Petrunia2014-08-0914-104/+642
| |\ \
| | * | MDEV-6109: EXPLAIN JSON10.1-explain-jsonSergei Petrunia2014-05-2714-111/+641
| | | | | | | | | | | | | | | | | | | | | | | | | | | | - First code, "EXPLAIN FORMAT=JSON stmt" and "ANALYZE FORMAT=JSON stmt" work for basic queries. Complex constructs (e.g subqueries, etc) not yet supported. - No test infrastructure yet
* | | | MDEV-7053: WSREP_STATUS & WSREP_MEMBERSHIP I_S tablesNirbhay Choubey2014-11-224-22/+80
| | | | | | | | | | | | | | | | | | | | wsrep_info INFORMATION_SCHEMA plugin to provide WSREP_STATUS and WSREP_MEMBERSHIP tables.
* | | | Removing some duplicate code: deriving Item_func_opt_neg from Item_bool_func.Alexander Barkov2014-11-201-7/+5
| | | |
* | | | Deriving Item_bool_func from Item_bool_func2.Alexander Barkov2014-11-201-5/+3
| | | |
* | | | MDEV-7005 NULLIF does not work as documentedAlexander Barkov2014-11-203-56/+86
| | | | | | | | | | | | | | | | MDEV-7146 NULLIF returns unexpected result with a YEAR field
* | | | Sharing similar code between Item_func_ifnull and Item_func_ifAlexander Barkov2014-11-192-54/+42
| | | |
* | | | MDEV-5231: Per query variables from Percona Server (rewritten)Oleksandr Byelkin2014-11-1116-49/+231
| | | |
* | | | MDEV-5528 Command line variable to choose MariaDB-5.3 vs MySQL-5.6 temporal ↵Alexander Barkov2014-11-036-5/+18
| | | | | | | | | | | | | | | | data formats
* | | | MDEV-6649 Different warnings for TIME and TIME(N) when ↵Alexander Barkov2014-11-032-11/+23
| | | | | | | | | | | | | | | | | | | | | | | | @@old_mode=zero_date_time_cast Merging from 10.0 (pre-requisite for MDEV-5528)
* | | | MDEV-12 OpenGIS: create required tables: GeometryColumns, related views.Alexey Botchkov2014-10-213-1/+139
| | | | | | | | | | | | | | | | GEOMETRY_COLUMNS and SPATIAL_REF_SYS tables added to the INFORMATION_SCHEMA.
* | | | Correction for the fix of the bug mdev-6874.Igor Babaev2014-10-194-7/+5
| | | |
* | | | Merge branch '10.1' of ../10.1-mdev334 into 10.1Igor Babaev2014-10-173-2/+8
|\ \ \ \
| * | | | Fixed bug mdev-6874.Igor Babaev2014-10-173-2/+8
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | The method subselect_union_engine::no_rows() must take into account the fact that now unit->fake_select_lex is NULL for for select_union_direct objects.
* | | | | MDEV-6388: ANALYZE $stmt output in the slow query logSergei Petrunia2014-10-176-16/+19
| | | | | | | | | | | | | | | | | | | | | | | | | Make log_slow_verbosity=explain actually print ANALYZE (that is, EXPLAIN otuput with two extra columns).
* | | | | Merge branch '10.1' of github.com:MariaDB/server into 10.1Sergei Petrunia2014-10-17106-2086/+4361
|\ \ \ \ \
| * \ \ \ \ Merge branch 'bb-10.1-merge' into 10.1mariadb-10.1.1Sergei Golubchik2014-10-16104-1860/+3761
| |\ \ \ \ \ | | |/ / / / | |/| | | |
| | * | | | Merge 10.0.14 into 10.1Sergei Golubchik2014-10-15104-1860/+3761
| | |\ \ \ \ | | | |_|_|/ | | |/| | |
| | | * | | MDEV-6743 crash in GROUP_CONCAT(IF () ORDER BY 1)mariadb-10.0.14Sergei Golubchik2014-09-241-1/+1
| | | | | | | | | | | | | | | | | | | | | | | | new fix
| | | * | | remove the bug fix for MDEV-6743 "crash in GROUP_CONCAT(IF () ORDER BY 1)"Sergei Golubchik2014-09-241-12/+0
| | | | | | | | | | | | | | | | | | | | | | | | but keep the test case - it succeeds in 10.0 without the fix
| | | * | | 5.5 mergeSergei Golubchik2014-09-232-16/+20
| | | |\ \ \
| | | | * \ \ mergeSergei Golubchik2014-09-231-8/+2
| | | | |\ \ \
| | | | | * | | remove unused (obsolete) declarations from slave.hSergei Golubchik2014-09-191-8/+2
| | | | | | | |
| | | | * | | | MDEV-6743 crash in GROUP_CONCAT(IF () ORDER BY 1)Michael Widenius2014-09-231-8/+18
| | | | |/ / / | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | mysql-test/r/func_group.result: Test case mysql-test/t/func_group.test: Test case sql/item_sum.cc: Restore ORDER for prepared statements
View Lorry Controller Status