summaryrefslogtreecommitdiff
path: root/mysql-test
Commit message (Collapse)AuthorAgeFilesLines
* MDEV-7015: SET STATEMENT old_passwords has no effectMDEV-7015Oleksandr Byelkin2014-12-022-4/+53
| | | | | Decision about algorihtm moved on prepare phase. Made possible to add mpore password algorithms.
* MDEV-6996: SET STATEMENT default_week_format = .. has no effectOleksandr Byelkin2014-12-025-3/+48
| | | | Change constant with a system variable.
* Make analyze_format_json.test work on case-insensitive FS.Sergei Petrunia2014-12-022-17/+17
|
* Merge branch '10.1' of github.com:MariaDB/server into 10.1Sergei Petrunia2014-12-021-1/+1
|\
| * Update test results after fix for MDEV-7245Sergei Petrunia2014-12-021-1/+1
| |
* | Update test results.Sergei Petrunia2014-12-021-1/+2
| |
* | EXPLAIN FORMAT=JSONSergei Petrunia2014-12-022-0/+91
| | | | | | | | | | Add support for semi-join strategies: FirstMatch, DuplicateWeedout, LooseScan.
* | Merge ../10.1 into bb-10.1-explain-jsonSergei Petrunia2014-12-0235-477/+438
|\ \ | |/
| * MDEV-7245: Incorrect display of subquery cache in union.resultSergei Petrunia2014-12-021-1/+1
| | | | | | | | - Do set nest_level and nest_level_base for fake_select_lex objects.
| * update result filesSergei Golubchik2014-12-014-314/+6
| |
| * MDEV-4412 : SLOW QUERY LOG - add affected rows (UPDATE / DELETE) in slow ↵Nirbhay Choubey2014-11-308-27/+42
| | | | | | | | | | | | query log Added Rows_affected to slow query log & mysql.slow_log table.
| * Make test results stable.Sergei Golubchik2014-11-301-0/+1
| | | | | | | | (just like in the test below)
| * rdiff not needed anymoreSergei Golubchik2014-11-301-11/+0
| |
| * MDEV-4018 : Feature Request: microseconds in GET_LOCK()Nirbhay Choubey2014-11-302-0/+67
| | | | | | | | | | Updated MDL_context's lock methods to accept double precision lock_wait_timeout.
| * fixes for --embeddedSergei Golubchik2014-11-299-42/+197
| |
| * MDEV-4045 Missing OGC Spatial functions.Alexey Botchkov2014-11-282-80/+114
| | | | | | | | | | | | | | | | | | | | | | | | Missing GIS functions added: IsRing() PointOnSurface PointOnSurface Relate Distance Intersection ConvexHull Other old OpenGis standard inconsistencies fixed.
| * MDEV-7228: innodb.innodb-page_compression_tables, ↵Jan Lindström2014-11-277-2/+10
| | | | | | | | | | | | | | | | | | innodb.innodb-page_compression_zip, innodb.innodb_stats_create_on_corrupted fail with embedded server Problem is that tests restart the server and "shutdown_server" looks for pid file # which is not there with embedded mode. Fix tests so that they are not run with embedded mode.
* | EXPLAIN FORMAT=JSON: support SJ-MaterializationSergei Petrunia2014-12-013-8/+63
| | | | | | | | | | | | | | | | - 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-2/+44
| |
* | ANALYZE FORMAT=JSON: better output and testsSergei Petrunia2014-11-292-0/+215
| | | | | | | | | | | | - 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-292-0/+48
| |
* | EXPLAIN FORMAT=JSON: support derived tablesSergei Petrunia2014-11-282-0/+84
| |
* | Make explain_json.test pass on case-insensitive FS.Sergei Petrunia2014-11-282-9/+9
| |
* | EXPLAIN FORMAT=JSON: Add support for single-table UPDATE/DELETE.Sergei Petrunia2014-11-282-4/+65
| |
* | EXPLAIN FORMAT=JSON: support join bufferingSergei Petrunia2014-11-272-0/+45
| | | | | | | | | | | | | | | | | | - 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-272-0/+154
| | | | | | | | | | | | | | | | | | | | 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-272-0/+220
|\ \ | |/ |/|
| * Make testsuite to passSergei Petrunia2014-11-212-2/+2
| | | | | | | | | | | | | | | | - 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.
| * Merge ../10.1 into bb-10.1-explain-jsonSergei Petrunia2014-10-15581-6101/+25153
| |\
| * | EXPLAIN FORMAT=JSON: produce used_key_parts, JSON-ish output for index_merge.Sergei Petrunia2014-08-142-7/+127
| | |
| * | EXPLAIN FORMAT=JSON: produce the 'ref' column.Sergei Petrunia2014-08-121-0/+1
| | |
| * | MDEV-6109: EXPLAIN JSONSergei Petrunia2014-08-122-9/+40
| | | | | | | | | | | | Add pretty-printing of possible_keys column.
| * | MDEV-6109: EXPLAIN JSONSergei Petrunia2014-08-092-0/+68
| | | | | | | | | | | | | | | | | | - Add first testcases - Don't overquote when printing conditions - Other small output fixes
* | | MDEV-7162 main.mysqld--help fails in buildbot on Windows:Alexander Barkov2014-11-261-23/+23
| | |
* | | MDEV-7181: innodb.innodb_defrag_concurrent fails in buildbotJan Lindström2014-11-252-74/+1
| | | | | | | | | | | | | | | | | | Problem was that test tried to calculate number of pages on buffer pool and operations done to them. This is not realible way on buildbot.
* | | MDEV-7169: innodb.innodb_bug14147491 fails in buildbot on WindowsJan Lindström2014-11-241-0/+3
| | | | | | | | | | | | | | | | | | Problem is that test could open Microsoft C++ Client Debugger windows with abort exceptin. Lets not try to test this on windows.
* | | MDEV-7168: Tests innodb.innodb_stats_create_tableJan Lindström2014-11-242-0/+24
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | innodb.innodb_stats_drop_locked fail and innodb.innodb_stats_fetch_nonexistent fails in buildbot on Windows Analysis: Problem is that innodb_stats_create_on_corrupted test renames mysql.innodb.index_stats and all the rest are dependend on this table. Fix: After rename back to original, restart mysqld to make sure that table is correct.
* | | MDEV-7164: innodb.innodb-alter-table-disk-full fails in buildbot on WindowsJan Lindström2014-11-241-0/+3
| | | | | | | | | | | | | | | | | | | | | Analysis: Test case uses Linux specific error codes. Fix: Can't run test case with Windows currently because requires to inject error to system.
* | | MDEV-7171 funcs_1.is_tables_is and main.information_schema-big fail in buildbot.Alexey Botchkov2014-11-242-0/+96
| | | | | | | | | | | | test results updated with the new GIS-related IS tables.
* | | MDEV-7053: WSREP_STATUS & WSREP_MEMBERSHIP I_S tablesNirbhay Choubey2014-11-226-0/+0
| | | | | | | | | | | | | | | wsrep_info INFORMATION_SCHEMA plugin to provide WSREP_STATUS and WSREP_MEMBERSHIP tables.
* | | MDEV-7005 NULLIF does not work as documentedAlexander Barkov2014-11-207-6/+1509
| | | | | | | | | | | | MDEV-7146 NULLIF returns unexpected result with a YEAR field
* | | MDEV-7133: InnoDB: Assertion failure in dict_tf_is_validJan Lindström2014-11-192-0/+223
| | | | | | | | | | | | | | | | | | | | | Problem is that page compressed tables currently require atomic_blobs and that feature is not availabe currently for row_format=redundant. Fix: Disallow page compressed create option if table row_format=redundant.
* | | MDEV-7108: Make long semaphore wait timeout configurableJan Lindström2014-11-176-0/+202
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Merge Facebook commit https://github.com/facebook/mysql-5.6/commit/cd063ab930f05efdba39d504543998512d1bd71f authored by Peng Tian from https://github.com/facebook/mysql-5.6 Introduced a new configuration variable innodb_fatal_semaphore_wait_threshold, it makes the fatal semaphore timeout configurable. Modified original commit so that no MariaDB server files are changed, instead introduced a new InnoDB/XtraDB configuration variable. Its default/min/max vlaues are 600/1/2^32-1 in seconds (it was hardcoded as 600, now its default value is 600, so the default behavior of this diff should be no change).
* | | MDEV-7088: Query stats for compression based on TRIM sizeJan Lindström2014-11-124-0/+4
| | | | | | | | | | | | | | | | | | | | | Analysis: Status variables were missing from innodb_status_variables array. Fix: Add missing status variables to the array.
* | | MDEV-5231: Per query variables from Percona Server (rewritten)Oleksandr Byelkin2014-11-1113-12/+2450
| | |
* | | MDEV-6936: Buffer pool list scan optimizationJan Lindström2014-11-064-16/+24
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Merged Facebook commit 617aef9f911d825e9053f3d611d0389e02031225 authored by Inaam Rana to InnoDB storage engine (not XtraDB) from https://github.com/facebook/mysql-5.6 WL#7047 - Optimize buffer pool list scans and related batch processing Reduce excessive scanning of pages when doing flush list batches. The fix is to introduce the concept of "Hazard Pointer", this reduces the time complexity of the scan from O(n*n) to O. The concept of hazard pointer is reversed in this work. Academically hazard pointer is a pointer that the thread working on it will declar such and as long as that thread is not done no other thread is allowe do anything with it. In this WL we declare the pointer as a hazard pointer and then if any thread attempts to work on it, it is allowed to do so but it has to a the hazard pointer to the next valid value. We use hazard pointer sol reverse traversal of lists within a buffer pool instance. Add an event to control the background flush thread. The background f thread wait has been converted to an os event timed wait so that it c signalled by threads that want to kick start a background flush when buffer pool is running low on free/dirty pages.
* | | A follow up fix for MDEV-5528Alexander Barkov2014-11-041-1/+1
| | | | | | | | | | | | (forgot to do "git add" for two files in the previous commit for MDEV-5528)
* | | MDEV-5528 Command line variable to choose MariaDB-5.3 vs MySQL-5.6 temporal ↵Alexander Barkov2014-11-0345-581/+1618
| | | | | | | | | | | | data formats
* | | MDEV-6649 Different warnings for TIME and TIME(N) when ↵Alexander Barkov2014-11-032-0/+22
| | | | | | | | | | | | | | | | | | @@old_mode=zero_date_time_cast Merging from 10.0 (pre-requisite for MDEV-5528)
* | | MDEV-6929: Port Facebook Prefix Index Queries OptimizationJan Lindström2014-11-039-0/+472
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Merge Facebook commit 154c579b828a60722a7d9477fc61868c07453d08 and e8f0052f9b112dc786bf9b957ed5b16a5749f7fd authored by Steaphan Greene from https://github.com/facebook/mysql-5.6 Optimize prefix index queries to skip cluster index lookup when possible. Currently InnoDB will always fetch the clustered index (primary key index) for all prefix columns in an index, even when the value of a particular record is smaller than the prefix length. This change optimizes that case to use the record from the secondary index and avoid the extra lookup. Also adds two status vars that track how effective this is: innodb_secondary_index_triggered_cluster_reads: Times secondary index lookup triggered cluster lookup. innodb_secondary_index_triggered_cluster_reads_avoided: Times prefix optimization avoided triggering cluster lookup.
View Lorry Controller Status