summaryrefslogtreecommitdiff
path: root/mysql-test/include
Commit message (Collapse)AuthorAgeFilesLines
* Merge 5.5 into 10.0bb-10.0-mergeMarko Mäkelä2019-03-261-1/+1
|\
| * Fix for MDEV-18276, typo in error message + all other occurrences of referingChris Calender2019-03-231-1/+1
| |
* | MDEV-12023 Assertion failure sym_node->table != NULL on startupMarko Mäkelä2018-10-302-0/+8
| | | | | | | | | | | | | | | | | | | | | | row_drop_table_for_mysql(): Avoid accessing non-existing dictionary tables. dict_create_or_check_foreign_constraint_tables(): Add debug instrumentation for creating and dropping a table before the creation of any non-core dictionary tables. trx_purge_add_update_undo_to_history(): Adjust a debug assertion, so that it will not fail due to the test instrumentation.
* | MDEV-12547: InnoDB FULLTEXT index has too strict ↵Thirunarayanan Balathandayuthapani2018-10-162-0/+18
| | | | | | | | | | | | | | | | | | | | | | innodb_ft_result_cache_limit max limit - Backported the MYSQL_SYSVAR_SIZE_T to 10.0 - The parameter innodb_ft_result_cache_limit was only 32 bits wide also on 64-bit systems. Make it size_t, so that it will be 64 bits on 64-bit systems. - Added a test case that show how innodb_ft_result_cache_limit variables behaves in 32bit and 64 bit system.
* | MDEV-13118 Wrong results with LOWER and UPPER and subqueryAlexander Barkov2018-07-191-0/+15
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | This problem is similar to MDEV-10306. 1. Fixing Item_str_conv::val_str(String *str) to return the result in "str", and to use tmp_value only as a temporary buffer for args[0]->val_str(). The new code version now guarantees that the result is always returned in "str". The trick with copy_if_not_alloced() is not used any more. 2. The change #1 revealed the same problem in SUBSTRING_INDEX(), so some tests with combinations of UPPER()/LOWER() and SUBSTRING_INDEX() started to fail. Fixing Item_func_substr_index::val_str() the same way, to return the result in "str" and use tmp_value as a temporary buffer for args[0]->val_str().
* | Merge 5.5 into 10.0Marko Mäkelä2018-01-021-8/+3
|\ \ | |/
| * MDEV-14309 MTR tests require perl-Env which is not always in the default ↵Sergei Golubchik2017-12-271-8/+3
| | | | | | | | | | | | | | | | | | | | | | installation * don't use Env module in tests, use $ENV{xxx} instead * collateral changes: ** $file in the error message was unset ** $file in the other error message was unset too :) ** source file arguments are conventionally upper-cased ** abort the test (die) on error, don't just echo/exit
* | remove redundant tests from mysql-test/include/*.inc filesSergei Golubchik2017-11-096-40/+6
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Some tests are skipped by checks in suite.pm. It is redundant to have an sql-level run-time check in the .inc file itself. In some cases it's not only redundant, but dangerous. After one bug in 10.2 innodb.create_isl_with_direct failed to start InnoDB, but the server started fine (just without InnoDB) and instead of failing, the test was skipped by run-time check in have_innodb.inc. # Conflicts: # mysql-test/include/not_embedded.inc # mysql-test/r/change_user_notembedded.result # mysql-test/suite.pm # mysql-test/t/change_user_notembedded.test
* | MDEV-14029 Server does not remove #sql*.frm files after crash during ALTER TABLEElena Stepanova2017-11-051-0/+5
| | | | | | | | Add a check for #sql* files in test and mysql subdirs to the testcase check
* | Make the SEARCH_ABORT logic actually workMarko Mäkelä2017-09-071-1/+2
| | | | | | | | | | The SEARCH_ABORT logic was not working as intended (tests were not being aborted).
* | MDEV-13437 InnoDB fails to return error for XA COMMIT or XA ROLLBACK in ↵Andrei Elkin2017-08-294-2/+114
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | read-only mode Assertions failed due to incorrect handling of the --tc-heuristic-recover option when InnoDB is in read-only mode either due to innodb_read_only=1 or innodb_force_recovery>3. InnoDB failed to refuse a XA COMMIT or XA ROLLBACK operation, and there were errors in the error handling in the upper layer. This was fixed by making InnoDB XA operations respect the high_level_read_only flag. The InnoDB part of the fix and parts of the test main.tc_heuristic_recover were provided by Marko Mäkelä. LOCK_log mutex lock/unlock had to be added to fix MDEV-13438. The measure is confirmed by mysql sources as well. For testing of the conflicting option combination, mysql-test-run is made to export a new $MYSQLD_LAST_CMD. It holds the very last value generated by mtr.mysqld_start(). Even though the options have been also always stored in $mysqld->{'started_opts'} there were no access to them beyond the automatic server restart by mtr through the expect file interface. Effectively therefore $MYSQLD_LAST_CMD represents a more general interface to $mysqld->{'started_opts'} which can be used in wider scopes including server launch with incompatible options. Notice another existing method to restart the server with incompatible options relying on $MYSQLD_CMD is is aware of $mysqld->{'started_opts'} (the actual options that the server is launched by mtr). In order to use this method they would have to be provided manually. NOTE: When merging to 10.2, the file search_pattern_in_file++.inc should be replaced with the pre-existing search_pattern_in_file.inc.
* | Merge remote-tracking branch 'origin/5.5' into 10.0Vicențiu Ciorbaru2017-07-251-0/+7
|\ \ | |/
| * MDEV-13065 rpl.rpl_mdev-11092 fails sporadically in buildbotSachin Setiya2017-07-191-0/+7
| | | | | | | | | | | | | | | | | | | | | | | | | | Problem rpl.rpl_mdev-11092 fails in buildbot because after starting slave in wait_for_slave_sql_error_and_skip.inc slave is started but there may be chances that we have not skipped the last error and Last_SQL_Errno is still not zero untill the end of rpl_end.inc , which will compare Last_SQL_Errno to 0. So in this this case rpl_mdev-11092 fails. Solution After starting slave in wait_for_slave_sql_error_and_skip.inc we will wait for Last_SQL_Errno to become 0.
| * MDEV-10524 Assertion `arg1_int >= 0' failed in ↵Alexander Barkov2016-12-191-1/+25
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Item_func_additive_op::result_precision() This change is a backport from 10.0 to 5.5 for: 1. The full patch for: MDEV-4841 Wrong character set of ADDTIME() and DATE_ADD() 9adb6e991ec87b65d04929f115d9d0c899e4ab19 2. A small fragment of: MDEV-5298 Illegal mix of collations on timestamp 03f6778d61a74bdd7d09103a16473a2a5624cf66 which overrides Item_temporal_hybrid_func::cmp_type(), and adds a new line into cache_temporal_4265.result.
* | Follow-up to MDEV-12042 (test innodb_page_size variants)Marko Mäkelä2017-06-062-0/+12
| | | | | | | | | | | | | | | | | | | | innodb_page_size_small: A new set of combinations, for innodb_page_size up to 16k. In MariaDB 10.0, this does not make a difference, but in 10.1 and later, innodb_page_size would cover 32k and 64k, for which ROW_FORMAT=COMPRESSED is not available. Enable these combinations in a few InnoDB tests.
* | MDEV-12042 Re-bootstrap the server if InnoDB options are incompatiblebb-10.0-elenst-mdev12042Elena Stepanova2017-06-022-0/+12
| |
* | Fix tokudb.gap_lock_error testVicențiu Ciorbaru2017-03-055-0/+232
| | | | | | | | | | TokuDB testsuite makes use of includes not found in our default 10.0. Cherry pick them from Percona Server's include directory.
* | innodb.innodb-get-fk: Actually test --innodb-read-only.Marko Mäkelä2017-02-031-1/+8
| |
* | Flush suppressions table to prevent corruption when server is killedElena Stepanova2017-02-011-0/+1
| |
* | MDEV-11814 Refuse innodb_read_only startup if crash recovery is neededMarko Mäkelä2017-01-264-16/+60
| | | | | | | | | | | | | | | | recv_scan_log_recs(): Remember if redo log apply is needed, even if starting up in innodb_read_only mode. recv_recovery_from_checkpoint_start_func(): Refuse innodb_read_only startup if redo log apply is needed.
* | Replication tests fail on valgrind due to waiting-related timeoutsElena Stepanova2017-01-063-0/+12
| | | | | | | | | | | | | | | | | | | | MTR raises default wait_for_pos_timeout from 300 to 1500 when tests are run with valgrind. The same needs to be done for other replication-related waits. The change should fix one of failures mentioned in MDEV-10653 (rpl.rpl_parallel fails in buildbot with timeout), the one on the valgrind builder; but not all of them
* | backport include/search_pattern_in_file.inc from 10.1Sergei Golubchik2016-10-261-6/+9
| |
* | MDEV-7142: main.index_merge_innodb fails sporadically in buildbotSergei Petrunia2016-09-051-0/+1
| | | | | | | | Attempt to stabilize the testcase.
* | Fixed "Packets out of order" warning message on stdout in clients,Monty2016-08-212-2/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | compiled for debugging, when the server goes down This happens in the following scenario: - Server gets a shutdown message - Servers sends error ER_CONNECTION_KILLED to the clients connection - The client sends a query to the server, before the server has time to close the connection to the client - Client reads the ER_CONNECTION_KILLED error message In the above case, the packet number for the reply is one less than what the client expected and the client prints "Packets out of order". Fixed the following way: - The client accepts now error packages with a packet number one less than expected. - To ensure that this issue can be detected early in my_real_read(), error messages sent to the client are not compressed, even when compressed protocol is used.
* | Merge branch '5.5' into 10.0Sergei Golubchik2016-08-101-12/+0
|\ \ | |/
| * MDEV-10350 "./mtr --report-features" doesn't workSergei Golubchik2016-08-031-12/+0
| | | | | | | | removed
* | Merge branch '5.5' into 10.0Sergei Golubchik2016-04-261-0/+6
|\ \ | |/
| * support SEARCH_RANGE in search_pattern_in_file.incSergei Golubchik2016-04-251-1/+16
| | | | | | | | | | | | | | | | | | | | Backport a part of commit 439f75f Author: Kristian Nielsen <knielsen@knielsen-hq.org> Date: Mon Jun 30 13:59:21 2014 +0200 Fix test failures in rpl.rpl_checksum and rpl.rpl_gtid_errorlog.
| * MDEV-9662 Assertion `precision || !scale' failed in ↵Alexander Barkov2016-04-201-0/+6
| | | | | | | | | | | | | | my_decimal_precision_to_length_no_truncation(uint, uint8, bool) The patch for MDEV-9745 earlier fixed the problem reported in MDEV-9662 as well. Only adding tests.
* | MDEV-8482 mysql-test - main.func_encrypt fails if FIPS=1Sergei Golubchik2016-04-241-0/+6
| | | | | | | | | | | | * check for openssl errors in DES_ENCRYPT/DES_DECRYPT * disable the test when DES doesn't work * also disable main.func_des_encrypt
* | MDEV-8481 mysql-test - main.func_crypt fails if FIPS=1Sergei Golubchik2016-04-241-4/+5
| | | | | | | | disable the test when crypt(3) doesn't work
* | Fix spelling: occurred, execute, which etcOtto Kekäläinen2016-03-041-1/+1
| |
* | Fixed problems found by buildbot:Monty2015-11-271-1/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | - Better error from check_slave_param - Better error message from TokuDB if it can't be compiled. - Marked rpl_mixed_drop_create_temp_table and rpl_stm_drop_create_temp_table as big tests to stop timeout failures on power8 - Added sync_slave_with_master to semisync_future-7591 to ensure that slave is up to date with master before calling rpl_end. - Disabled compiler warnings from connect and mroonga and on MacOSX. Mroonga: - Fixed bug when testing if file is a normal file that can be deleted - Marked a lot of date and datetime test to not run on macosx. This is because mktime() can't handle negative years and this restricts mroonga so that it can only store dates after the year 1900.
* | Merge branch '5.5' into 10.0Sergei Golubchik2015-11-181-0/+3
|\ \ | |/
| * feedback plugin debugSergei Golubchik2015-11-181-0/+3
| | | | | | | | | | | | | | | | make it possible to change feedback plugin wait intervals * only in debug builds * and force the feedback report to be ignored update the test to use this feature
* | Fixed buildbot failures on Solaris 64 bitMonty2015-11-181-1/+2
| | | | | | | | | | | | | | | | | | | | | | | | rpl/rpl_mdev382 ; Wrong replace in show_binlog_events2.inc binlog/database ; Different error on Solaris if file exists mroonga/repair_table_no_index_file ; Different system error on Solaris partition_not_blackhole ; Different error on Solaris partition_myisam ; Different error on Solaris Some other failures in mroonga was because have_32bit.inc didn't correctly detect 64 bits on Solaris. Fixed using DEFAULT_MACHINE instead of MACHINE_TYPE for Sys_version_compile_machine.
* | MDEV-8669 MTR client connections on Windows became much slower.Vladislav Vaintroub2015-11-031-1/+0
| | | | | | | | | | | | | | | | | | | | | | | | The regression is caused by change bind-address server parameter in MDEV-8083, so now server listens on IPv4 only by default. The problem however is that on Windows, connection to server on localhost appears to be much faster, if server listens on IPv6/dual stack. mysql_real_connect() would try to connect to IPv6 loopback first, and if this fails, the failing connect() call takes several seconds. To fix, use bind-address=* on Windows, and 127.0.0.1 elsewhere
* | Merge branch '5.5' into 10.0Sergei Golubchik2015-10-091-2/+18
|\ \ | |/
| * MDEV-7330 plugins.feedback_plugin_send fails sporadically in buildbotElena Stepanova2015-09-271-1/+16
| | | | | | | | | | | | | | | | | | The test restarts the server and expects that the feedback plugin will send a report on shutdown, and will write about it in the error log. But the server is only given 10 sec to shut down properly, which is not always enough. Added a parameter to restart_mysqld.inc, and set it to a bigger value in feedback_plugin_send
| * tests for MDEV-7937: Enforce SSL when --ssl client option is usedmariadb-5.5.44Sergei Golubchik2015-06-092-5/+0
| | | | | | | | | | | | | | * add a test when server certificate is verified successfully * one test with two combinations (instead of two tests) * verbose tets: make it print what it is doing * fix the test to work with yassl and no-ssl builds
| * disable ssl for ssl-disabled testsSergei Golubchik2015-06-091-0/+1
| | | | | | | | instead of running them only when ssl is not compiled in
| * Fix tests for 7937Vicențiu Ciorbaru2015-06-091-4/+4
| |
| * Added tests for MDEV-7937Vicențiu Ciorbaru2015-06-091-0/+4
| |
* | after-merge fixesSergei Golubchik2015-06-161-0/+8
| | | | | | | | | | in innobase: compilation error on windows other changes: perfschema merge followup
* | include the correct IPv6 check in perfschema testsSergei Golubchik2015-06-151-20/+0
| |
* | MDEV-8083 MTR is broken on systems with IPv6 disabledSergei Golubchik2015-06-151-0/+1
| | | | | | | | | | disable IPv6 globally in mysql-test, only use it in dedicated IPv6 tests (where it is enabled per-test)
* | Merge branch '5.5' into 10.0Sergei Golubchik2015-05-041-0/+114
|\ \ | |/
| * MDEV-7649 wrong result when comparing utf8 column with an invalid literalAlexander Barkov2015-04-241-0/+114
| |
| * MDEV-6528 review debian patches for mysqlSergei Golubchik2014-10-021-1/+1
| | | | | | | | and apply whatever was reasonable
* | Merge test for bug#72594 from upstreamNirbhay Choubey2015-04-302-0/+32
| |
View Lorry Controller Status