summaryrefslogtreecommitdiff
path: root/mysql-test/suite
Commit message (Collapse)AuthorAgeFilesLines
* 11.0 branchSergei Golubchik2022-12-202-2/+2
|
* Merge 10.10 into 10.11Marko Mäkelä2022-12-163-1/+13
|\
| * Merge 10.9 into 10.10Marko Mäkelä2022-12-163-1/+13
| |\
| | * MDEV-30172: Disable galera_sr.MDEV-25718Marko Mäkelä2022-12-161-0/+2
| | |
| | * Merge 10.8 into 10.9Marko Mäkelä2022-12-163-1/+11
| | |\
| | | * Merge 10.7 into 10.8Marko Mäkelä2022-12-163-1/+11
| | | |\
| | | | * MDEV-30172: Disable galera.galera_parallel_simpleMarko Mäkelä2022-12-161-0/+1
| | | | |
| | | | * Merge 10.6 into 10.7Marko Mäkelä2022-12-163-1/+10
| | | | |\
| | | | | * MDEV-30172: galera mtr disablesDaniel Black2022-12-152-0/+7
| | | | | |
| | | | | * Merge branch '10.5' into 10.6Daniel Black2022-12-153-1/+3
| | | | | |\
| | | | | | * mtr: more galera disables - linked in MDEV-30172Daniel Black2022-12-153-1/+3
| | | | | | |
* | | | | | | Merge branch '10.10' into 10.11Daniel Black2022-12-152-0/+4
|\ \ \ \ \ \ \ | |/ / / / / /
| * | | | | | Merge branch '10.9' into 10.10Daniel Black2022-12-152-0/+4
| |\ \ \ \ \ \ | | |/ / / / /
| | * | | | | Merge branch '10.8' into 10.9Daniel Black2022-12-152-0/+4
| | |\ \ \ \ \ | | | |/ / / /
| | | * | | | Add missing error suppressionMarko Mäkelä2022-12-142-0/+4
| | | | | | |
* | | | | | | Merge 10.10 into 10.11Marko Mäkelä2022-12-14105-4002/+937
|\ \ \ \ \ \ \ | |/ / / / / /
| * | | | | | Merge 10.9 into 10.10Marko Mäkelä2022-12-14105-4002/+937
| |\ \ \ \ \ \ | | |/ / / / /
| | * | | | | Merge 10.8 into 10.9Marko Mäkelä2022-12-143-0/+5
| | |\ \ \ \ \ | | | |/ / / /
| | | * | | | Merge 10.7 into 10.8Marko Mäkelä2022-12-143-0/+5
| | | |\ \ \ \ | | | | |/ / /
| | | | * | | Merge 10.6 into 10.7Marko Mäkelä2022-12-143-0/+5
| | | | |\ \ \ | | | | | |/ /
| | | | | * | Merge branch '10.5' into 10.6Daniel Black2022-12-143-0/+5
| | | | | |\ \ | | | | | | |/
| | | | | | * MDEV-30172 re-disable galera testsDaniel Black2022-12-143-1/+5
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | galera_sr.GCF-1060 'innodb' w2 [ fail ] timeout after 900 seconds galera_3nodes.galera_ssl_reload At line 50: mysql_shutdown failed galera_3nodes.galera_ssl_reload : MDEV-30172 At line 50: mysql_shutdown failed galera_3nodes.GCF-354 : mysqltest: At line 39: query 'DROP TABLE test.t1' failed: 1047: WSREP has not yet prepared node for application use galera_3nodes.GCF-354 : mysqltest: At line 30: query 'INSERT INTO test.t1 values (1)' failed: 1180: Got error 6 "No such device or address" galera_wan : [ERROR] WSREP: /home/buildbot/buildbot/build/gcs/src/gcs_state_msg.cpp:gcs_state_msg_get_quorum():947: Failed to establish quorum.
| | * | | | | Merge 10.8 into 10.9Marko Mäkelä2022-12-13105-4003/+933
| | |\ \ \ \ \ | | | |/ / / /
| | | * | | | Merge 10.7 into 10.8Marko Mäkelä2022-12-13105-4003/+933
| | | |\ \ \ \ | | | | |/ / /
| | | | * | | Merge 10.6 into 10.7Marko Mäkelä2022-12-13105-4003/+933
| | | | |\ \ \ | | | | | |/ /
| | | | | * | Merge 10.5 into 10.6Marko Mäkelä2022-12-1365-98/+692
| | | | | |\ \ | | | | | | |/
| | | | | | * Merge 10.4 into 10.5Marko Mäkelä2022-12-1365-100/+692
| | | | | | |\
| | | | | | | * Merge 10.3 into 10.4Marko Mäkelä2022-12-1358-91/+675
| | | | | | | |\
| | | | | | | | * MDEV-29814: galera_var_notify_ssl_ipv6 causes testing system to hangJulius Goryavsky2022-12-094-5/+70
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | This commit fixes the test system hanging due to the galera_var_notify_ssl_ipv6 test and also brings the wsrep_notify[_ssl].sh files in line with each other between the user template and the mtr suite. Quotes are also added here to avoid problems if the user specifies the value of one of the variables at the beginning of the file containing shell-specific characters, for example, if the password or username specified in the PSWD and USER variables will contain the "$" character. Also fixed an issue with automatic --ssl-verify-server-cert option substitution when the corresponding value is set by the user to "1" or "on". Also fixed some tests here to avoid joining one of the nodes to another cluster when the nodes are restarted from the mtr side, which can lead to random failures when testing with buildbot.
| | | | | | | | * MDEV-29144 ER_TABLE_SCHEMA_MISMATCH or crash on DISCARD/IMPORTMarko Mäkelä2022-12-093-1/+80
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | mysql_discard_or_import_tablespace(): On successful ALTER TABLE...DISCARD TABLESPACE, evict the table handle from the table definition cache, so that ha_innobase::close() will be invoked, like InnoDB expects to be the case. This will avoid an assertion failure ut_a(table->get_ref_count() == 0) during IMPORT TABLESPACE. ha_innobase::open(): Do not issue any ER_TABLESPACE_DISCARDED warning. Member functions for DML will do that. ha_innobase::truncate(), ha_innobase::check_if_supported_inplace_alter(): Issue ER_TABLESPACE_DISCARDED warnings, to compensate for the removal of the warning in ha_innobase::open(). row_quiesce_write_indexes(): Only write information about committed indexes. The ALTER TABLE t NOWAIT ADD INDEX(c) in the nondeterministic test case will most of the time fail due to a metadata lock (MDL) timeout and leave behind an uncommitted index. Reviewed by: Sergei Golubchik
| | | | | | | | * MDEV-29636 Assertion `part_share->auto_inc_initialized || ↵Nayuta Yanagisawa2022-12-076-0/+73
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | !can_use_for_auto_inc_init()' failed in ha_partition::set_auto_increment_if_higher upon REPLACE with partition pruning The bug is caused by a similar mechanism as MDEV-21027. The function, check_insert_or_replace_autoincrement, failed to open all the partitions on REPLACE SELECT statements and it results in the assertion error.
| | | | | | | | * try harder to reject not strictly deterministic vcols in indexes/storedSergei Golubchik2022-12-022-0/+28
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | detect non-determinism in vcol of vcol, like: create table t1 (a int, b real as (rand()), c real as (b) stored);
| | | | | | | | * MDEV-30016 Virtual columns do not support autoincrement columnsSergei Golubchik2022-12-024-6/+49
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | change vcol_upgrade test to use stored gcols
| | | | | | | | * cleanup: VCOL_NOT_VIRTUAL->VCOL_NEXTVALSergei Golubchik2022-12-023-0/+10
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | rename to stress that is a specific hack for Item_func_nextval and should not be used for other items. If a vcol uses Item_func_nextval, a corresponding table for the sequence should be added to the prelocking list (in that sense NEXTVAL is not simply a function, but more like a subquery), see add_internal_tables() in DML_prelocking_strategy::handle_table(). At the moment it is only implemented for DEFAULT, not for GENERATED ALWAYS AS, thus the VCOL_NEXTVAL hack.
| | | | | | | | * MDEV-30056 Impossible to export column grantsSergei Golubchik2022-12-0214-63/+63
| | | | | | | | |
| | | | | | | | * Add a global suppression for O_DIRECT failuresMarko Mäkelä2022-11-291-6/+0
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Fixes up commit b8ad6fbd95830b61d282abc1167300fff261be7e
| | | | | | | | * Fixed warning from innodb.create_isl_with_direct if have_symlink is disabledbb-10.3-montyMonty2022-11-291-6/+5
| | | | | | | | |
| | | | | | | | * Enable valgrind for replication testMonty2022-11-292-0/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | The following tests are disabled when running --valgrding without --big: - rpl.rpl_ssl - rpl.rpl_semi_sync_event - All encryption test (which includes have_file_key_management.inc)
| | | | | | | | * MDEV-29169 Using MATCH returns NULL for Virtual ColumnNikita Malyavin2022-11-232-0/+33
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Virtual column values are updated in handler in reading commands, like ha_index_next, etc. This was missing for ha_ft_read. handler::ha_ft_read: add table->update_virtual_fields() call
| | | | | | | | * MDEV-29977 Memory leak in row_log_table_apply_updateThirunarayanan Balathandayuthapani2022-11-152-4/+37
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | - InnoDB fails to free the persistent cursor for the clustered index when InnoDB replays the update operation on the table that is being rebuilt.
| | | | | | | | * Clean up file load.in in a testMarko Mäkelä2022-11-141-0/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | This fixes the following test invocation: ./mtr --no-reorder parts.partition_special_myisam parts.partition_debug This was broken ever since afd4b25d8a0ab1447d37033a377ee05a03314d44 a.k.a. mysql/mysql-server@bde21e58108a1f311d15088c50414bb43ab45d62
| | | | | | | | * MDEV-27882 Innodb - recognise MySQL-8.0 innodb flags and give a specific ↵Daniel Black2022-11-118-13/+127
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | error message Per fsp0types.h, SDI is on tablespace flags position 14 where MariaDB stores its pagesize. Flag at position 13, also in MariaDB pagesize flags, is a MySQL encryption flag. These are checked only if fsp_flags_is_valid fails, so valid MariaDB pages sizes don't become errors. The error message "Cannot reset LSNs in table" was rather specific and not always true to replaced with more generic error. ALTER TABLE tbl IMPORT TABLESPACE now reports Unsupported on MySQL tablespace (rather than index corrupted) along with a server error message. MySQL innodb Errors are with with UNSUPPORTED rather than CORRUPTED to avoid user anxiety. Reviewer: Marko Mäkelä
| | | | | | | | * MDEV-10087 mysqld_update()/mysql_delete() continues execution even after ↵Vlad Lesin2022-11-092-0/+131
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | subquery with JOIN gets error from storage engine The issue is that record_should_be_deleted() returns true in mysql_delete() even if sub-select with join gets error from storage engine when DELETE FROM ... WHERE ... IN (SELECT ...) statement is executed. The same is true for mysql_update() where select->skip_record() returns true even if sub-select with join gets error from storage engine. In the test case if sub-select is chosen as deadlock victim the whole transaction is rolled back during sub-select execution, but mysql_delete()/mysql_update() continues transaction execution and invokes table->delete_row() as record_should_be_deleted() wrongly returns true in mysql_delete() and table->update_row() as select->skip_record(thd) wrongly returns 1 for mysql_update(). record_should_be_deleted() wrogly returns true because thd->is_error() returns false SQL_SELECT::skip_record() invoked from record_should_be_deleted(). It's supposed that THD error should be set in rr_handle_error() called from rr_sequential() during sub-select JOIN::exec_inner() execution. But rr_handle_error() does not set THD error because READ_RECORD::print_error is not set in JOIN_TAB::read_record. READ_RECORD::print_error should be initialized in init_read_record()/init_read_record_idx(). But make_join_readinfo() does not invoke init_read_record()/init_read_record_idx() for JOIN_TAB::read_record. The fix is to set JOIN_TAB::read_record.print_error in make_join_readinfo(), i.e. in the same place where JOIN_TAB::read_record.table is set. Reviewed by Sergey Petrunya.
| | | | | | | | * MDEV 28970: Add RESET MASTER to clear possible remaining binlog from ↵asklavou2022-11-098-4/+8
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | previous test
| | | | | * | | | Merge branch '10.5' into 10.6Daniel Black2022-12-134-21/+22
| | | | | |\ \ \ \ | | | | | | |/ / / | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Merge Jan's bb-10.6-merge-jan branch: MDEV-30172 Galera test case cleanup * Delete tests that are not supported and not going to be supported any time soon * Fix result set on tests that are not run on bb * Fix tests that fail because of auto increment offset * Make sure that disabled tests have open bug report
| | | | | | * | | MDEV-30172 galera 10.5 test cleanupJan Lindström2022-12-134-13/+22
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | galera.galera_bf_abort_at_after_statement disabled by Daniel Black
| | | | | | * | | mtr: galera/galera_3node disable failed testsDaniel Black2022-12-132-2/+9
| | | | | | | | |
| | | | | * | | | Merge branch '10.5' into 10.6Daniel Black2022-12-1340-3890/+225
| | | | | |\ \ \ \ | | | | | | |/ / / | | | | | | | | | | | | | | | | | | Adjust galera/galera_3nodes disabled tests.
| | | | | | * | | Merge branch 10.4 into 10.5Daniel Black2022-12-1340-3891/+223
| | | | | | |\ \ \ | | | | | | | |/ /
| | | | | | | * | MDEV-29814: galera_var_notify_ssl_ipv6 causes testing system to hangJulius Goryavsky2022-12-104-5/+70
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | This commit fixes the test system hanging due to the galera_var_notify_ssl_ipv6 test and also brings the wsrep_notify[_ssl].sh files in line with each other between the user template and the mtr suite. Quotes are also added here to avoid problems if the user specifies the value of one of the variables at the beginning of the file containing shell-specific characters, for example, if the password or username specified in the PSWD and USER variables will contain the "$" character. Also fixed an issue with automatic --ssl-verify-server-cert option substitution when the corresponding value is set by the user to "1" or "on". Also fixed some tests here to avoid joining one of the nodes to another cluster when the nodes are restarted from the mtr side, which can lead to random failures when testing with buildbot.