mirror/mariadb
1
0
Fork 0
mirror of https://github.com/MariaDB/server.git synced 2025-10-27 17:08:14 +01:00
Code Issues Projects Releases Packages Wiki Activity
mariadb/mysql-test/suite/parts/t
History
Exact
Dmitry Shulga eeb00ceffd MDEV-35617: DROP USER should leave no active session for that user 
Follow-up patch with adjustments of test files and updates of result
files for tests.

Some of tests were rewritten slighlty. Everywhere where common
pattern used:
-----
  CREATE USER userA;
  --connect con1 ... userA ...
   <sql statements...>
  --disconnect con1
  DROP USER userA;
-----
the DROP USER statement has been eclosed into the directive
--disable_warnings
--enable_warnings

This change is caused by the race conddition between --disconnect
and DROP USER since a number of currently running sessions
established on behalf the user being dropped is counted by
holding the rw_lock THD_list_iterator::lock that is not acquired on
execution the DROP USER statement but the lock is taken as the last
step on handling disconnection (when the client is already sending
the next statement). Therefore, for the cases where the command
 --disconnect precedes the DROP USER statement
we hide the possible warnings about presence of active sessions
for the user being deleted to make tests deterministic.
2025-06-09 18:24:28 +07:00
..
alter_data_directory_innodb.test MDEV-26870 --skip-symbolic-links does not disallow .isl file creation 2022-01-21 14:43:59 +02:00
alter_table.combinations MDEV-22166 CONVERT PARTITION: move out partition into a table 2021-10-26 17:07:46 +02:00
alter_table.test MDEV-35617: DROP USER should leave no active session for that user 2025-06-09 18:24:28 +07:00
backup_log.test Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
backup_log_rocksdb.opt MDEV-18465 Logging of DDL statements during backup 2021-05-19 22:54:13 +02:00
backup_log_rocksdb.test Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
cache.test MDEV Assertion `partition_id == m_extra_cache_part_id' failed in ha_partition::late_extra_no_cache 2017-12-12 15:10:53 +02:00
debug_innodb_crash-master.opt MDEV-29983 Deprecate innodb_file_per_table 2023-01-11 17:55:56 +02:00
debug_innodb_crash.test MDEV-22189: Change error messages inside code to have mariadb instead of 2021-05-24 11:38:13 +05:30
debug_innodb_fail-master.opt Fixed test failure in parts.partition_debug_innodb/myisam 2020-05-09 12:46:33 +03:00
debug_innodb_fail.test MDEV-22189: Change error messages inside code to have mariadb instead of 2021-05-24 11:38:13 +05:30
debug_myisam_crash-master.opt mtr: aix - stack-trace is optional 2021-07-22 15:22:47 +10:00
debug_myisam_crash.test Fixed test failure in parts.partition_debug_innodb/myisam 2020-05-09 12:46:33 +03:00
debug_myisam_fail-master.opt Fixed test failure in parts.partition_debug_innodb/myisam 2020-05-09 12:46:33 +03:00
debug_myisam_fail.test Fixed test failure in parts.partition_debug_innodb/myisam 2020-05-09 12:46:33 +03:00
engine_defined_part_attributes.test Merge 10.6 into 10.8 2023-03-16 18:11:37 +02:00
fulltext.test MDEV-17627 Assertion `inited==RND' failed in handler::ha_rnd_end() upon actions on partitioned table with FTS 2019-07-12 19:38:10 +02:00
insert_ignore-5421.test MDEV-5421 Assertion `! is_set()' fails on INSERT IGNORE when a table has no partition for a value 2014-01-23 00:03:05 +01:00
longname.test MDEV-22817 Assertion idlen <= MAX_TABLE_NAME_LEN in create_table_info_t::create_foreign_keys() 2020-06-07 12:21:32 +03:00
mdev_21007.test MDEV-21007 Do not assert auto_increment_value unless all parts open 2024-04-08 16:35:21 +10:00
mdev_24610.test MDEV-24610 MEMORY SE: check overflow in info calls with HA_STATUS_AUTO 2024-05-22 09:18:09 +10:00
optimizer.test MDEV-31003: Second execution for ps-protocol 2023-07-26 17:15:00 +07:00
part_blocked_sql_func_innodb.test Fixes for the bugs 2007-11-20 16:04:07 +01:00
part_blocked_sql_func_myisam.test Fixes for the bugs 2007-11-20 16:04:07 +01:00
part_ctype_tis620.test Merge 10.4 into 10.5 2022-11-30 13:10:52 +02:00
part_ctype_utf32.test Bug#52121 partition by key on utf32 enum field cause debug assertion: (length % 4) == 0 2010-08-23 13:56:21 +04:00
part_supported_sql_func_innodb.test Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
part_supported_sql_func_myisam.test Fixes for the bugs 2007-11-20 16:04:07 +01:00
partition_alter1_1_2_innodb.test 5.5-merge 2011-07-02 22:08:51 +02:00
partition_alter1_1_2_myisam.test Fix many test failures in parts test suite with --embedded-server. 2009-10-09 15:08:09 +02:00
partition_alter1_1_innodb.test MDEV-4786 - merge 10.0-monty - 10.0 2013-07-30 17:50:48 +04:00
partition_alter1_1_myisam.test Fix many test failures in parts test suite with --embedded-server. 2009-10-09 15:08:09 +02:00
partition_alter1_2_innodb.test MDEV-4750 follow-up: Reduce disabling innodb_stats_persistent 2021-08-31 13:55:02 +03:00
partition_alter1_2_myisam.test Fix many test failures in parts test suite with --embedded-server. 2009-10-09 15:08:09 +02:00
partition_alter2_1_1_innodb.test 5.5-merge 2011-07-02 22:08:51 +02:00
partition_alter2_1_2_innodb.test Bug#56659: Mismatch of CAPITAL vs small letters in "unified filelist" partitioning output 2010-09-15 10:22:12 +02:00
partition_alter2_1_maria.test rename maria to aria 2010-09-12 18:40:01 +02:00
partition_alter2_1_myisam.test Speed up mtr --parallel=<lots> by scheduling some slow tests earlier. 2011-01-03 15:33:39 +01:00
partition_alter2_2_1_innodb.test merge. 2010-11-25 18:17:28 +01:00
partition_alter2_2_2_innodb.test Bug#56659: Mismatch of CAPITAL vs small letters in "unified filelist" partitioning output 2010-09-15 10:22:12 +02:00
partition_alter2_2_maria.test rename maria to aria 2010-09-12 18:40:01 +02:00
partition_alter2_2_myisam.test Speed up mtr --parallel=<lots> by scheduling some slow tests earlier. 2011-01-03 15:33:39 +01:00
partition_alter3_innodb.test MDEV-4750 follow-up: Reduce disabling innodb_stats_persistent 2021-08-31 13:55:02 +03:00
partition_alter3_myisam.test Fix many test failures in parts test suite with --embedded-server. 2009-10-09 15:08:09 +02:00
partition_alter4_innodb.test Marked some very slow mtr tests with not_valgrind 2021-06-14 17:03:19 +03:00
partition_alter4_myisam.test Added missing 'source' command. 2009-10-28 10:08:54 +02:00
partition_alter_innodb.test MDEV-32050 fixup: Stabilize tests 2023-11-21 12:42:00 +02:00
partition_alter_instant.test MDEV-33655 Remove alter_algorithm 2024-05-27 12:39:03 +02:00
partition_alter_maria.test MDEV-13982 Server crashes in in ha_partition::engine_name 2018-02-14 19:12:23 +01:00
partition_alter_myisam.test Merge branch '10.6' into 10.11 2024-05-10 20:02:18 +02:00
partition_auto_increment_archive.test Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
partition_auto_increment_blackhole.test Bug#45823 Assertion failure in file row/row0mysql.c line 1386 2009-09-04 09:27:11 +05:30
partition_auto_increment_innodb.test Bug#38804: Query deadlock causes all tables to be inaccessible. 2008-09-08 15:30:01 +02:00
partition_auto_increment_maria.test rename maria to aria 2010-09-12 18:40:01 +02:00
partition_auto_increment_max.test MDEV-9519: Data corruption will happen on the Galera cluster size change 2019-02-26 08:09:04 +02:00
partition_auto_increment_memory.test Bug#38804: Query deadlock causes all tables to be inaccessible. 2008-09-08 15:30:01 +02:00
partition_auto_increment_myisam.test Bug#38804: Query deadlock causes all tables to be inaccessible. 2008-09-08 15:30:01 +02:00
partition_basic_innodb.test Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
partition_basic_myisam.test Fix many test failures in parts test suite with --embedded-server. 2009-10-09 15:08:09 +02:00
partition_basic_symlink_innodb.test MDEV-36050 DATA/INDEX DIRECTORY handling is inconsistent 2025-04-18 09:41:23 +02:00
partition_basic_symlink_myisam.test Fix many test failures in parts test suite with --embedded-server. 2009-10-09 15:08:09 +02:00
partition_bigint_innodb.test MDEV-10621 parts.partition_float_myisam failed with timeout in buildbot 2017-02-18 20:42:46 +02:00
partition_bigint_myisam.test MDEV-10621 parts.partition_float_myisam failed with timeout in buildbot 2017-02-18 20:42:46 +02:00
partition_bit_innodb.test Fixes for the bugs 2007-11-20 16:04:07 +01:00
partition_bit_myisam.test Fixes for the bugs 2007-11-20 16:04:07 +01:00
partition_char_innodb.test Fixes for the bugs 2007-11-20 16:04:07 +01:00
partition_char_myisam.test MDEV-19123 Change default charset from latin1 to utf8mb4 2024-07-11 10:21:07 +04:00
partition_datetime_innodb.test Fixes for the bugs 2007-11-20 16:04:07 +01:00
partition_datetime_myisam.test Fixes for the bugs 2007-11-20 16:04:07 +01:00
partition_debug.test MDEV-22165 CONVERT TABLE: move in partition from existing table 2021-10-26 17:07:46 +02:00
partition_debug_innodb-master.opt mtr: aix - stack-trace is optional 2021-07-22 15:22:47 +10:00
partition_debug_innodb.test MDEV-22189: Change error messages inside code to have mariadb instead of 2021-05-24 11:38:13 +05:30
partition_debug_sync_innodb.test MDEV-4750 follow-up: Reduce disabling innodb_stats_persistent 2021-08-31 13:55:02 +03:00
partition_decimal_innodb.test Increase version number 2011-02-28 19:47:19 +02:00
partition_decimal_myisam.test Increase version number 2011-02-28 19:47:19 +02:00
partition_double_innodb.test MDEV-10621 parts.partition_float_myisam failed with timeout in buildbot 2017-02-18 20:42:46 +02:00
partition_double_myisam.test MDEV-10621 parts.partition_float_myisam failed with timeout in buildbot 2017-02-18 20:42:46 +02:00
partition_engine_innodb.test Fix many test failures in parts test suite with --embedded-server. 2009-10-09 15:08:09 +02:00
partition_engine_myisam.test Fix many test failures in parts test suite with --embedded-server. 2009-10-09 15:08:09 +02:00
partition_exch_innodb.test MDEV-4864 - Merge tests for EXCHANGE PARTITION feature 2013-09-27 16:58:49 +04:00
partition_exch_myisam.test MDEV-4864 - Merge tests for EXCHANGE PARTITION feature 2013-09-27 16:58:49 +04:00
partition_exch_myisam_innodb.test cleanup parts.partition_exch_* tests 2017-09-18 10:40:26 +02:00
partition_exch_qa.test MDEV-4864 - Merge tests for EXCHANGE PARTITION feature 2013-09-27 16:58:49 +04:00
partition_exch_qa_1_innodb.test MDEV-4864 - Merge tests for EXCHANGE PARTITION feature 2013-09-27 16:58:49 +04:00
partition_exch_qa_1_myisam.test MDEV-4864 - Merge tests for EXCHANGE PARTITION feature 2013-09-27 16:58:49 +04:00
partition_exch_qa_2.test cleanup parts.partition_exch_* tests 2017-09-18 10:40:26 +02:00
partition_exch_qa_3.test cleanup parts.partition_exch_* tests 2017-09-18 10:40:26 +02:00
partition_exch_qa_4_innodb.test MDEV-19123 Change default charset from latin1 to utf8mb4 2024-07-11 10:21:07 +04:00
partition_exch_qa_4_myisam.test MDEV-4864 - Merge tests for EXCHANGE PARTITION feature 2013-09-27 16:58:49 +04:00
partition_exch_qa_5_innodb.test MDEV-4864 - Merge tests for EXCHANGE PARTITION feature 2013-09-27 16:58:49 +04:00
partition_exch_qa_5_myisam.test MDEV-4864 - Merge tests for EXCHANGE PARTITION feature 2013-09-27 16:58:49 +04:00
partition_exch_qa_6.test Merge branch '10.1' into 10.2 2017-09-19 12:43:02 +03:00
partition_exch_qa_7_innodb.test MDEV-4864 - Merge tests for EXCHANGE PARTITION feature 2013-09-27 16:58:49 +04:00
partition_exch_qa_7_myisam.test MDEV-4864 - Merge tests for EXCHANGE PARTITION feature 2013-09-27 16:58:49 +04:00
partition_exch_qa_8_innodb.test MDEV-4864 - Merge tests for EXCHANGE PARTITION feature 2013-09-27 16:58:49 +04:00
partition_exch_qa_8_myisam.test MDEV-4864 - Merge tests for EXCHANGE PARTITION feature 2013-09-27 16:58:49 +04:00
partition_exch_qa_10.test MDEV-6247: Merge 10.0-galera to 10.1. 2014-08-26 15:43:46 +03:00
partition_exch_qa_11.test MDEV-4864 - Merge tests for EXCHANGE PARTITION feature 2013-09-27 16:58:49 +04:00
partition_exch_qa_12.test (Part#2) MDEV-13049 Querying INFORMATION_SCHEMA becomes slow in MariaDB 10.1 2017-10-31 13:00:20 +04:00
partition_exch_qa_13.test MDEV-4864 - Merge tests for EXCHANGE PARTITION feature 2013-09-27 16:58:49 +04:00
partition_exch_qa_14.test MDEV-13157 Specifying DATA DIRECTORY in tables leads to failing EXCHANGE PARTITION 2017-09-18 10:40:26 +02:00
partition_exch_qa_15.test cleanup parts.partition_exch_* tests 2017-09-18 10:40:26 +02:00
partition_exchange_archive.test MDEV-4864 - Merge tests for EXCHANGE PARTITION feature 2013-09-27 16:58:49 +04:00
partition_exchange_blackhole.test MDEV-4864 - Merge tests for EXCHANGE PARTITION feature 2013-09-27 16:58:49 +04:00
partition_exchange_innodb.test Add --source include/long_test.inc to some tests 2025-03-15 11:15:54 +01:00
partition_exchange_memory.test Add --source include/long_test.inc to some tests 2025-03-15 11:15:54 +01:00
partition_exchange_myisam.test Add --source include/long_test.inc to some tests 2025-03-15 11:15:54 +01:00
partition_float_innodb.test MDEV-10621 parts.partition_float_myisam failed with timeout in buildbot 2017-02-18 20:42:46 +02:00
partition_float_myisam.test MDEV-10621 parts.partition_float_myisam failed with timeout in buildbot 2017-02-18 20:42:46 +02:00
partition_innodb_status_file-master.opt merge with 5.3 2011-10-19 21:45:18 +02:00
partition_innodb_status_file.test MDEV-6720 - enable connection log in mysqltest by default 2016-03-31 10:11:16 +04:00
partition_int_innodb.test MDEV-10621 parts.partition_float_myisam failed with timeout in buildbot 2017-02-18 20:42:46 +02:00
partition_int_myisam.test MDEV-10621 parts.partition_float_myisam failed with timeout in buildbot 2017-02-18 20:42:46 +02:00
partition_mdev6067.test MDEV-6067: Partitioned table DML sometimes binlogged without XID event 2014-04-11 09:03:53 +02:00
partition_mediumint_innodb.test MDEV-10621 parts.partition_float_myisam failed with timeout in buildbot 2017-02-18 20:42:46 +02:00
partition_mediumint_myisam.test MDEV-10621 parts.partition_float_myisam failed with timeout in buildbot 2017-02-18 20:42:46 +02:00
partition_mgm_lc0_archive.test WL#4444 Added TRUNCATE partition support, fixes bug#19405 and bug #35111 2009-09-10 11:15:39 +02:00
partition_mgm_lc0_innodb.test Bug#37402: Mysql cant read partitioned table with capital letter in the name 2008-07-11 01:14:13 +02:00
partition_mgm_lc0_memory.test Bug#37402: Mysql cant read partitioned table with capital letter in the name 2008-07-11 01:14:13 +02:00
partition_mgm_lc0_myisam.test Bug#37402: Mysql cant read partitioned table with capital letter in the name 2008-07-11 01:14:13 +02:00
partition_mgm_lc1_archive-master.opt Bug#37402: Mysql cant read partitioned table with capital letter in the name 2008-07-11 01:14:13 +02:00
partition_mgm_lc1_archive.test WL#4444 Added TRUNCATE partition support, fixes bug#19405 and bug #35111 2009-09-10 11:15:39 +02:00
partition_mgm_lc1_innodb-master.opt Bug#37402: Mysql cant read partitioned table with capital letter in the name 2008-07-11 01:14:13 +02:00
partition_mgm_lc1_innodb.test Bug#37402: Mysql cant read partitioned table with capital letter in the name 2008-07-11 01:14:13 +02:00
partition_mgm_lc1_memory-master.opt Bug#37402: Mysql cant read partitioned table with capital letter in the name 2008-07-11 01:14:13 +02:00
partition_mgm_lc1_memory.test Bug#37402: Mysql cant read partitioned table with capital letter in the name 2008-07-11 01:14:13 +02:00
partition_mgm_lc1_myisam-master.opt Bug#37402: Mysql cant read partitioned table with capital letter in the name 2008-07-11 01:14:13 +02:00
partition_mgm_lc1_myisam.test Bug#37402: Mysql cant read partitioned table with capital letter in the name 2008-07-11 01:14:13 +02:00
partition_mgm_lc2_archive-master.opt Bug#37402: Mysql cant read partitioned table with capital letter in the name 2008-07-11 01:14:13 +02:00
partition_mgm_lc2_archive.test WL#4444 Added TRUNCATE partition support, fixes bug#19405 and bug #35111 2009-09-10 11:15:39 +02:00
partition_mgm_lc2_innodb-master.opt Bug#37402: Mysql cant read partitioned table with capital letter in the name 2008-07-11 01:14:13 +02:00
partition_mgm_lc2_innodb.test Bug#37402: Mysql cant read partitioned table with capital letter in the name 2008-07-11 01:14:13 +02:00
partition_mgm_lc2_memory-master.opt Bug#37402: Mysql cant read partitioned table with capital letter in the name 2008-07-11 01:14:13 +02:00
partition_mgm_lc2_memory.test Bug#37402: Mysql cant read partitioned table with capital letter in the name 2008-07-11 01:14:13 +02:00
partition_mgm_lc2_myisam-master.opt Bug#37402: Mysql cant read partitioned table with capital letter in the name 2008-07-11 01:14:13 +02:00
partition_mgm_lc2_myisam.test Bug#37402: Mysql cant read partitioned table with capital letter in the name 2008-07-11 01:14:13 +02:00
partition_open.test Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
partition_purge.opt MDEV-31264 Purge trying to access freed secondary index page 2023-05-31 19:07:41 +05:30
partition_purge.test MDEV-32050 fixup: Stabilize tests 2023-11-21 12:42:00 +02:00
partition_recover_myisam.opt cleanup 2024-05-05 21:37:08 +02:00
partition_recover_myisam.test cleanup 2024-05-05 21:37:08 +02:00
partition_repair_myisam-master.opt --getopt-prefix-matching command-line option 2015-02-10 10:21:15 +01:00
partition_repair_myisam.test MDEV-19123 Change default charset from latin1 to utf8mb4 2024-07-11 10:21:07 +04:00
partition_smallint_innodb.test MDEV-10621 parts.partition_float_myisam failed with timeout in buildbot 2017-02-18 20:42:46 +02:00
partition_smallint_myisam.test MDEV-10621 parts.partition_float_myisam failed with timeout in buildbot 2017-02-18 20:42:46 +02:00
partition_special_innodb.test MDEV-32050: Look up tables in the purge coordinator 2023-10-25 10:08:20 +03:00
partition_special_myisam.test MDEV-19123 Change default charset from latin1 to utf8mb4 2024-07-11 10:21:07 +04:00
partition_syntax_innodb.test Fix many test failures in parts test suite with --embedded-server. 2009-10-09 15:08:09 +02:00
partition_syntax_myisam.test Fix many test failures in parts test suite with --embedded-server. 2009-10-09 15:08:09 +02:00
partition_tinyint_innodb.test MDEV-10621 parts.partition_float_myisam failed with timeout in buildbot 2017-02-18 20:42:46 +02:00
partition_tinyint_myisam.test MDEV-10621 parts.partition_float_myisam failed with timeout in buildbot 2017-02-18 20:42:46 +02:00
partition_value_innodb.test Fix for Bug#40904 20 tests in 5.1 are disabled in a bad manner 2008-12-08 15:36:42 +01:00
partition_value_myisam.test Fix for Bug#40904 20 tests in 5.1 are disabled in a bad manner 2008-12-08 15:36:42 +01:00
percona_nonflushing_analyze_debug.test MDEV-15101: Stop ANALYZE TABLE from flushing table definition cache 2020-06-12 20:29:05 +03:00
print_error.test fixes for test failures 2018-02-24 12:29:07 +01:00
reorganize.test MDEV-23730 s3.replication_partition 'innodb,mix' segv 2020-10-21 03:09:29 +03:00
reorganize_partition_innodb.test MDEV-36050 DATA/INDEX DIRECTORY handling is inconsistent 2025-04-18 09:41:23 +02:00
rpl_partition.test fix big tests for -ps 2021-06-19 00:12:11 +02:00
show_create.test MDEV-13089 identifier quoting in partitioning 2018-09-21 20:22:14 +02:00
truncate_locked.test MDEV-15551 Server hangs or assertion `strcmp(share->unique_file_name,filename) || share->last_version' fails in test_if_reopen or unexpected ER_LOCK_DEADLOCK 2018-07-19 11:35:39 +02:00
update_and_cache.test MDEV-16741 Assertion `m_extra_cache' failed in ha_partition::late_extra_cache 2018-09-10 19:30:06 +02:00