summaryrefslogtreecommitdiff
path: root/mysql-test/t/analyze_format_json.test
Commit message (Collapse)AuthorAgeFilesLines
* Updated mtr files to support different compiled in optionsMonty2019-09-011-0/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | This allows one to run the test suite even if any of the following options are changed: - character-set-server - collation-server - join-cache-level - log-basename - max-allowed-packet - optimizer-switch - query-cache-size and query-cache-type - skip-name-resolve - table-definition-cache - table-open-cache - Some innodb options etc Changes: - Don't print out the value of system variables as one can't depend on them to being constants. - Don't set global variables to 'default' as the default may not be the same as the test was started with if there was an additional option file. Instead save original value and reset it at end of test. - Test that depends on the latin1 character set should include default_charset.inc or set the character set to latin1 - Test that depends on the original optimizer switch, should include default_optimizer_switch.inc - Test that depends on the value of a specific system variable should set it in the test (like optimizer_use_condition_selectivity) - Split subselect3.test into subselect3.test and subselect3.inc to make it easier to set and reset system variables. - Added .opt files for test that required specfic options that could be changed by external configuration files. - Fixed result files in rockdsb & tokudb that had not been updated for a while.
* MDEV-13826: Floating point exception in ↵Varun Gupta2017-07-121-0/+12
| | | | | | | Filesort_tracker::print_json_members(Json_writer*) Whenever Filesort_tracker has r_loops=0, r_ouptut_rows would be 0, so we should add the value zero to the member "r_output_rows" explicitly
* MDEV-11866: ANALYZE FORMAT=JSON not predicatable for ↵Daniel Black2017-01-231-19/+19
| | | | | | | | | | | | | 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>
* Combined fix for MDEV-7267 and MDEV-8864Sergei Petrunia2015-10-061-0/+36
| | | | | | | | | | | The problem was that GROUP BY code created Item_field objects that referred to fields in the temp. tables used for GROUP BY. Item_ref and set_items_ref_array() call caused pointers to temp. table fields to occur in many places. This patch introduces Item_temptable_field, which can handle item->print() calls made after the underlying table is freed.
* fix for 32bit system. Not meaninful for this test but volatile parameters ↵Oleksandr Byelkin2015-09-211-4/+4
| | | | replaced.
* MDEV-7970: EXPLAIN FORMAT=JSON does not print HAVINGOleksandr Byelkin2015-09-181-0/+26
| | | | Printing non-trivial HAVING added.
* MDEV-7916: main.analyze_format_json fails in buildbot on labradorSergei Petrunia2015-04-061-1/+1
| | | | Make the test work on case insensitive FS
* MDEV-7904: ANALYZE FORMAT=JSON doesn't print r_rows for union outputSergei Petrunia2015-04-041-0/+16
| | | | Print r_rows. There is no table tracking for reading from tmp table, yet.
* MDEV-7833:ANALYZE FORMAT=JSON and Range checked for each recordOleksandr Byelkin2015-04-031-0/+30
|
* MDEV-7812: ANALYZE FORMAT=JSON UPDATE/DELETE doesnt print the r_total_time_msOleksandr Byelkin2015-03-291-0/+29
| | | | | | Tracking total time added in UPDATE/DELETE Fixed selectivity calculation in UPDATE/DELETE Macro definitions of time tracting fixed.
* MDEV-7648: Extra data in ANALYZE FORMAT=JSON $stmtSergei Petrunia2015-03-071-0/+8
| | | | | | | | | Show total execution time (r_total_time_ms) for various parts of the query: 1. time spent in SELECTs 2. time spent reading rows from storage engines #2 currently gets the data from P_S.
* MDEV-7679: ANALYZE crashes when printing WHERE when no default dbSergei Petrunia2015-03-071-0/+16
| | | | Fix Item_ident::print() to work when there is no current database
* MDEV-7674: ANALYZE shows r_rows=0Sergei Petrunia2015-03-071-0/+15
| | | | Change r_rows to be double
* Make analyze_format_json.test work on case-insensitive FS.Sergei Petrunia2014-12-021-3/+3
|
* ANALYZE FORMAT=JSON: better output and testsSergei Petrunia2014-11-291-0/+38
- Print r_loops - Always print r_* members. Print NULL values if no scans took place - Added testcases.