summaryrefslogtreecommitdiff
path: root/mysql-test/include
Commit message (Collapse)AuthorAgeFilesLines
...
* | Merge MDEV-7975 into 10.0Kristian Nielsen2015-04-141-0/+6
|\ \
| * | MDEV-7975: sporadic failure in test case rpl.rpl_gtid_startposKristian Nielsen2015-04-141-0/+6
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Add some suppressions that were missing. They are for if a STOP SLAVE is executed early during IO thread startup, when it is negotiating with the master. The master connection may be killed in the middle of a mysql_real_query(), which is not a test failure if it is a network error. This also caught one real code error, fixed with this commit: The I/O thread would fail to automatically reconnect if a network error happened while fetching the value of @@GLOBAL.gtid_domain_id.
* | | MDEV-7107 Sporadic test failure in multi_source.multisourceElena Stepanova2015-03-091-7/+45
|/ / | | | | | | | | | | Extend show_slave_status.inc to run SHOW ALL SLAVES STATUS and SHOW SLAVE 'name' STATUS on demand, and make the test use the include file instead of direct SHOW statements
* | fix include/not_embedded.inc to be independent from the environmentSergei Golubchik2014-12-021-4/+3
| | | | | | | | in particular, not fail with --vertical_results
* | tests that require server restart cannot be run with --embeddedSergei Golubchik2014-12-011-0/+1
| |
* | MDEV-7149 Constant propagation erroneously applied for LIKEAlexander Barkov2014-11-282-0/+55
| | | | | | | | | | | | | | Simply disallowing equality propagation into LIKE. A more delicate fix is be possible, but it would need too many changes, which is not desirable in 10.0 at this point.
* | MDEV-6880 Can't define CURRENT_TIMESTAMP as default value for added columnSergei Golubchik2014-11-181-5/+4
| | | | | | | | | | | | | | ALTER TABLE: don't fill default values per row, do it once. And do it in two places - for copy_data_between_tables() and for online ALTER. Also, run function_defaults test both for MyISAM and for InnoDB.
* | MDEV-6849 ON UPDATE CURRENT_TIMESTAMP doesn't always workSergei Golubchik2014-11-131-2/+15
| | | | | | | | | | | | | | | | | | reset default fields not for every modified row, but only once, at the beginning, as the set of modified fields doesn't change. exception: INSERT ... ON DUPLICATE KEY UPDATE - the set of fields does change per row and in that case we reset default fields per row.
* | Fix a confusing error message in the testsuiteKristian Nielsen2014-11-131-1/+1
| |
* | MDEV-4396: Fix innodb.innodb_bug14676111 test.Jan Lindström2014-11-031-0/+59
| |
* | BUG#13627921 - MISSING FLAGS IN SQL_COMMAND_FLAGS MAY LEAD TO REPLICATION ↵Sergei Golubchik2014-09-301-0/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | PROBLEMS merge from MySQL-5.6, revision: revno: 3677.2.1 committer: Alfranio Correia <alfranio.correia@oracle.com> timestamp: Tue 2012-02-28 16:26:37 +0000 message: BUG#13627921 - MISSING FLAGS IN SQL_COMMAND_FLAGS MAY LEAD TO REPLICATION PROBLEMS Flags in sql_command_flags[command] are not correctly set for the following commands: . SQLCOM_SET_OPTION is missing CF_CAN_GENERATE_ROW_EVENTS; . SQLCOM_BINLOG_BASE64_EVENT is missing CF_CAN_GENERATE_ROW_EVENTS; . SQLCOM_REVOKE_ALL is missing CF_CHANGES_DATA; . SQLCOM_CREATE_FUNCTION is missing CF_AUTO_COMMIT_TRANS; This may lead to a wrong sequence of events in the binary log. To fix the problem, we correctly set the flags in sql_command_flags[command].
* | Adding tests for handling 0x5C as the second byte in a multi-byte sequence,Alexander Barkov2014-09-231-0/+17
| | | | | | | | | | | | | | and as a escape character when SET NAMES xxx, character_set_connection=binary; for cp932,big5,gbk,sjis
* | mergeSergei Golubchik2014-09-161-1/+1
|\ \
| * \ 5.5 mergeSergei Golubchik2014-09-161-1/+1
| |\ \ | | |/
| | * for mysql-test: fix mysqlhotcopy script to return a predictable exit codeSergei Golubchik2014-09-161-1/+1
| | |
| | * Change a couple of permissions that cause lintian warnings in .deb packaging ↵Kristian Nielsen2014-08-132-0/+0
| | | | | | | | | | | | and don't really hurt to fix.
* | | - Adding big5, cp932, gbk, sjis tests covering characters that canAlexander Barkov2014-09-131-0/+94
|/ / | | | | | | | | | | | | have 0x5C as the second byte in a multi-byte character. - Adding big5 tests covering an unassigned character 0xC840 being stored into char/varchar/text/enum columns.
* | Adding thorough tests covering what happens with escaped sequencesAlexander Barkov2014-09-123-0/+357
| | | | | | | | | | | | | | | | | | | | | | | | | | | | in the SQL parser. Various backslash escapes and quote-quote escaped sequences are covered in combination with single and multi-byte characters. This is especially important for the character sets that can have 0x5C as the second byte in a multi-byte character (big5, cp932, gbk, sjis). swe7 is also a special character set, because in swe7 0x5C is used for both escape character and for "LATIN CAPITAL LETTER O WITH DIAERESIS".
* | 5.5.39 mergeSergei Golubchik2014-08-074-2/+54
|\ \ | |/
| * mysql-5.5.39 mergeSergei Golubchik2014-08-023-2/+39
| |\ | | | | | | | | | | | | | | | | | | ~40% bugfixed(*) applied ~40$ bugfixed reverted (incorrect or we're not buggy) ~20% bugfixed applied, despite us being not buggy (*) only changes in the server code, e.g. not cmakefiles
| | * Bug#17638477 UNINSTALL AND INSTALL SEMI-SYNC PLUGIN CAUSES SLAVES TO BREAKVenkatesh Duggirala2014-05-052-0/+37
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Problem: Uninstallation of semi sync plugin causes replication to break. Analysis: A semisync enabled replication is mutual agreement between Master and Slave when the connection (I/O thread) is established. Once I/O thread is started and if semisync is enabled on both master and slave, master appends special magic header to events using semisync plugin functions and sends it to slave. And slave expects that each event will have that special magic header format and reads those bytes using semisync plugin functions. When semi sync replication is in use if users execute uninstallation of the plugin on master, slave gets confused while interpreting that event's content because it expects special magic header at the beginning of the event. Slave SQL thread will be stopped with "Missing magic number in the header" error. Similar problem will happen if uninstallation of the plugin happens on slave when semi sync replication is in in use. Master sends the events with magic header and slave does not know about the added magic header and thinks that it received a corrupted event. Hence slave SQL thread stops with "Found corrupted event" error. Fix: Uninstallation of semisync plugin will be blocked when semisync replication is in use and will throw 'ER_UNKNOWN_ERROR' error. To detect that semisync replication is in use, this patch uses semisync status variable values. > On Master, it checks for 'Rpl_semi_sync_master_status' to be OFF before allowing the uninstallation of rpl_semi_sync_master plugin. >> Rpl_semi_sync_master_status is OFF when >>> there is no dump thread running >>> there are no semisync slaves > On Slave, it checks for 'Rpl_semi_sync_slave_status' to be OFF before allowing the uninstallation of rpl_semi_sync_slave plugin. >> Rpl_semi_sync_slave_status is OFF when >>> there is no I/O thread running >>> replication is asynchronous replication.
| * | Fix too agressive long semaphore wait output and add guard against introducingJan Lindström2014-07-241-0/+1
| | | | | | | | | | | | | | | compression failures on insert buffer.
* | | cleanup: remove have_mysql_upgrade.incSergei Golubchik2014-08-062-11/+0
| | |
* | | MDEV-6469 - rpl.rpl_gtid_basic, rpl.rpl_gtid_stop_start,Sergey Vojtovich2014-08-061-1/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | rpl.rpl_gtid_crash fail on PPC64 This is an addition to the original patch. Restored show binlog events output and adjusted filters to replace [\d-\d-\d,\d-\d-\d,\d-\d-\d] with [#-#-#].
* | | Merge InnoDB fixes from 5.5 revisions 4229, 4230, 4233, 4237 and 4238 i.e.Jan Lindström2014-07-251-0/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 4229: MDEV-5670: Assertion failure in file buf0lru.c line 2355 Add more status information if repeatable. 4230: MDEV-5673: Crash while parallel dropping multiple tables under heavy load Improve long semaphore wait output to include all semaphore waits and try to find out if there is a sequence of waiters. 4233: Fix compiler errors on product build. 4237: Fix too agressive long semaphore wait output and add guard against introducing compression failures on insert buffer. 4238: Fix test failure caused by simulated compression failure on IBUF_DUMMY table.
* | | MDEV-6073 Merge gis test cases form 5.6.Alexey Botchkov2014-07-012-0/+174
| | | | | | | | | | | | | | | | | | | | | Tests were merged. As the implementation is different, the 'internal debugging' part was not merged, only a stub for it created.
* | | Fix test failures in rpl.rpl_checksum and rpl.rpl_gtid_errorlog.Kristian Nielsen2014-06-301-1/+16
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | These tests use search_pattern_in_file.inc to search the error log for expected output. However, search_pattern_in_file.inc by default searched only the first 50000 bytes, so if the error log grew too big the tests would fail. This patch extends search_pattern_in_file.inc with an option to specify how much of the file to search, and whether to search from the start of the file or from the end. Then the rpl.rpl_checksum and rpl.rpl_gtid_errorlog test cases are fixed to search the last 50000 bytes of the error log, which will work no matter how large prior tests have made it.
* | | MDEV-6153 Trivial Lintian errors in MariaDB sources: spelling errors and ↵Sergei Golubchik2014-05-131-1/+1
| | | | | | | | | | | | wrong executable bits
* | | 5.5 mergeSergei Golubchik2014-05-094-0/+21
|\ \ \ | |/ /
| * | MDEV-5702 Incorrect results are returned with NULLIF()Alexander Barkov2014-04-281-0/+11
| | |
| * | Merge from 5.3.Alexander Barkov2014-04-211-0/+8
| |\ \
| | * | MDEV-6134 SUBSTRING_INDEX returns wrong result for 8bit character sets when ↵Alexander Barkov2014-04-211-0/+8
| | | | | | | | | | | | | | | | delimiter is not found
| | * | 5.2 mergeSergei Golubchik2014-03-166-5/+85
| | |\ \
| | | * \ 5.1 mergeSergei Golubchik2014-03-166-5/+85
| | | |\ \
| | | | * \ mysql-5.1.73 mergeSergei Golubchik2014-03-156-5/+85
| | | | |\ \
| * | | | \ \ mysql-5.5.37 selective mergeSergei Golubchik2014-03-272-0/+2
| |\ \ \ \ \ \ | | | |_|_|_|/ | | |/| | | |
| | * | | | | Updated/added copyright header. Added line "use is subject to license terms" Murthy Narkedimilli2014-02-172-0/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | to copyright header.
* | | | | | | after merge test case fixesSergei Golubchik2014-05-081-0/+3
| | | | | | |
* | | | | | | MDEV-6170 Incorrect ordering with utf8_bin and utf8mb4_bin collationsAlexander Barkov2014-04-251-0/+22
| | | | | | |
* | | | | | | 5.5 mergeSergei Golubchik2014-03-261-0/+13
|\ \ \ \ \ \ \ | |/ / / / / /
| * | | | | | 5.3-mergeSergei Golubchik2014-03-161-0/+13
| |\ \ \ \ \ \ | | | |/ / / / | | |/| | | |
| | * | | | | 5.2 mergeSergei Golubchik2014-03-161-0/+3
| | |\ \ \ \ \ | | | | |/ / / | | | |/| | |
| | | * | | | don't run unix_socket tests when $USER is already present in mysql.userSergei Golubchik2014-03-131-0/+3
| | | | | | | | | | | | | | | | | | | | | | | | | | | | (as it's done in 10.0)
| | * | | | | 5.2 mergeSergei Golubchik2014-03-131-0/+10
| | |\ \ \ \ \ | | | |/ / / /
| | | * | | | mtr: move if(unix_socket) test to include/have_unix_socket.incSergei Golubchik2014-03-131-0/+10
| | | | | | |
* | | | | | | MDEV-9095: Executing triggers on slave in row-based replicationunknown2014-03-191-0/+5
| | | | | | |
* | | | | | | XtraDB made the defaultSergei Golubchik2014-03-071-1/+1
| | | | | | |
* | | | | | | MDEV-5372 Make "CAST(time_expr AS DATETIME)" compatible with MySQL-5.6 (and ↵Alexander Barkov2014-03-071-0/+3
| | | | | | | | | | | | | | | | | | | | | | | | | | | | the SQL Standard)
* | | | | | | 10.0-base mergeSergei Golubchik2014-02-263-3/+24
|\ \ \ \ \ \ \
| * \ \ \ \ \ \ 5.5 mergeSergei Golubchik2014-02-252-3/+21
| |\ \ \ \ \ \ \ | | |/ / / / / /