mariadb/mysql-test/suite/parts/inc
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
..
engines.combinations MDEV-22166 CONVERT PARTITION: move out partition into a table 2021-10-26 17:07:46 +02:00
engines.inc MDEV-22166 CONVERT PARTITION: move out partition into a table 2021-10-26 17:07:46 +02:00
methods1.inc
part_alter_values.inc MDEV-26127 Assertion `err != DB_DUPLICATE_KEY' failed or InnoDB: Failing assertion: id != 0 on ALTER ... REBUILD PARTITION 2022-06-13 23:44:59 +09:00
part_blocked_sql_funcs_main.inc
part_exch_drop_tabs.inc cleanup parts.partition_exch_* tests 2017-09-18 10:40:26 +02:00
part_exch_qa.inc MDEV-4864 - Merge tests for EXCHANGE PARTITION feature 2013-09-27 16:58:49 +04:00
part_exch_qa_1.inc MDEV-4864 - Merge tests for EXCHANGE PARTITION feature 2013-09-27 16:58:49 +04:00
part_exch_qa_4.inc Updated mtr files to support different compiled in options 2019-09-01 19:17:35 +03:00
part_exch_qa_5.inc MDEV-6720 - enable connection log in mysqltest by default 2016-03-31 10:11:16 +04:00
part_exch_qa_7.inc MDEV-5215 prerequisite: remove test and test_* database hacks in the test suite 2022-11-01 16:33:00 +01:00
part_exch_qa_8.inc MDEV-35617: DROP USER should leave no active session for that user 2025-06-09 18:24:28 +07:00
part_exch_qa_13.inc MDEV-4864 - Merge tests for EXCHANGE PARTITION feature 2013-09-27 16:58:49 +04:00
part_exch_tabs.inc cleanup parts.partition_exch_* tests 2017-09-18 10:40:26 +02:00
part_supported_sql_funcs_delete.inc Adding support for Dynamic columns (WL#34): 2011-05-08 13:24:06 +03:00
part_supported_sql_funcs_main.inc Merge with 5.1-microseconds 2011-05-28 05:11:32 +03:00
partition.pre Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
partition_10.inc
partition_11.inc
partition_12.inc
partition_20.inc
partition_alter1_1.inc
partition_alter1_1_2.inc
partition_alter1_2.inc
partition_alter2_1.inc
partition_alter2_2.inc
partition_alter3.inc MDEV-31005: Make working cursor-protocol 2024-09-18 18:39:26 +07:00
partition_alter4.inc
partition_alter_1.inc Vanilla cleanups and refactorings 2021-10-26 17:07:46 +02:00
partition_alter_11.inc
partition_alter_13.inc
partition_alter_41.inc
partition_auto_increment.inc Merge 10.5 into 10.6 2022-12-13 16:58:58 +02:00
partition_basic.inc
partition_basic_symlink.inc
partition_bigint.inc
partition_binary.inc after-merge fix partitioning tests 2015-12-15 20:25:04 +01:00
partition_bit.inc
partition_blob.inc
partition_blocked_sql_funcs.inc
partition_char.inc after-merge fix partitioning tests 2015-12-15 20:25:04 +01:00
partition_check.inc MDEV-31005: Make working cursor-protocol 2024-09-18 18:39:26 +07:00
partition_check_drop.inc merge with 5.3 2011-10-19 21:45:18 +02:00
partition_check_read.inc MDEV-31005: Make working cursor-protocol 2024-09-18 18:39:26 +07:00
partition_check_read1.inc MDEV-31005: Make working cursor-protocol 2024-09-18 18:39:26 +07:00
partition_check_read2.inc MDEV-31005: Make working cursor-protocol 2024-09-18 18:39:26 +07:00
partition_cleanup.inc
partition_crash.inc Merge 10.5 into 10.6 2024-04-18 07:14:56 +03:00
partition_crash_add.inc MDEV-19455: Avoid SET DEBUG_DBUG='-d,...' construct 2019-10-11 14:02:35 +03:00
partition_crash_change.inc MDEV-19455: Avoid SET DEBUG_DBUG='-d,...' construct 2019-10-11 14:02:35 +03:00
partition_crash_drop.inc MDEV-19455: Avoid SET DEBUG_DBUG='-d,...' construct 2019-10-11 14:02:35 +03:00
partition_crash_exchange.inc Merge 5.5 into 10.1 2019-10-11 15:19:55 +03:00
partition_crash_t2.inc parts suite merged 2013-07-14 13:48:06 +02:00
partition_date.inc
partition_datetime.inc
partition_decimal.inc Added test cases for preceding test 2023-02-03 00:00:35 +03:00
partition_directory.inc
partition_double.inc Added test cases for preceding test 2023-02-03 00:00:35 +03:00
partition_engine.inc Fix various spelling errors still found in code 2021-03-22 18:10:39 +11:00
partition_enum.inc MDEV-7635: Update tests to adapt to the new default sql_mode 2017-02-10 06:30:42 -05:00
partition_exchange.inc MDEV-6720 - enable connection log in mysqltest by default 2016-03-31 10:11:16 +04:00
partition_fail.inc Vanilla cleanups and refactorings 2021-10-26 17:07:46 +02:00
partition_fail_add.inc MDEV-19455: Avoid SET DEBUG_DBUG='-d,...' construct 2019-10-11 14:02:35 +03:00
partition_fail_change.inc MDEV-19455: Avoid SET DEBUG_DBUG='-d,...' construct 2019-10-11 14:02:35 +03:00
partition_fail_drop.inc MDEV-19455: Avoid SET DEBUG_DBUG='-d,...' construct 2019-10-11 14:02:35 +03:00
partition_fail_exchange.inc Merge 5.5 into 10.1 2019-10-11 15:19:55 +03:00
partition_fail_t2.inc MDEV-22165 CONVERT TABLE: move in partition from existing table 2021-10-26 17:07:46 +02:00
partition_float.inc 5.5-merge 2011-07-02 22:08:51 +02:00
partition_int.inc
partition_key_4col.inc Added test cases for preceding test 2023-02-03 00:00:35 +03:00
partition_key_8col.inc Added test cases for preceding test 2023-02-03 00:00:35 +03:00
partition_key_16col.inc Added test cases for preceding test 2023-02-03 00:00:35 +03:00
partition_key_32col.inc Added test cases for preceding test 2023-02-03 00:00:35 +03:00
partition_layout.inc Fix various spelling errors still found in code 2021-03-22 18:10:39 +11:00
partition_layout_check1.inc merge 2011-04-26 11:35:17 +02:00
partition_layout_check2.inc MDEV-31005: Make working cursor-protocol 2024-09-18 18:39:26 +07:00
partition_mediumint.inc
partition_methods1.inc
partition_methods2.inc
partition_mgm.inc Updated mtr files to support different compiled in options 2019-09-01 19:17:35 +03:00
partition_mgm_crash.inc Fixed test failure in parts.partition_debug_innodb/myisam 2020-05-09 12:46:33 +03:00
partition_set.inc
partition_smallint.inc
partition_supported_sql_funcs.inc MDEV-34 delete storage/ndb and sql/*ndb* (and collateral changes) 2014-10-11 18:53:06 +02:00
partition_syntax.inc
partition_syntax_1.inc
partition_syntax_2.inc MDEV-34 delete storage/ndb and sql/*ndb* (and collateral changes) 2014-10-11 18:53:06 +02:00
partition_text.inc
partition_time.inc Added test cases for preceding test 2023-02-03 00:00:35 +03:00
partition_timestamp.inc Added test cases for preceding test 2023-02-03 00:00:35 +03:00
partition_tinyint.inc
partition_trigg1.inc MDEV-31005: Make working cursor-protocol 2024-09-18 18:39:26 +07:00
partition_trigg2.inc
partition_trigg3.inc MDEV-31005: Make working cursor-protocol 2024-09-18 18:39:26 +07:00
partition_value.inc MDEV-34 delete storage/ndb and sql/*ndb* (and collateral changes) 2014-10-11 18:53:06 +02:00
partition_varbinary.inc after-merge fix partitioning tests 2015-12-15 20:25:04 +01:00
partition_varchar.inc after-merge fix partitioning tests 2015-12-15 20:25:04 +01:00
partition_year.inc MDEV-7635: Update tests to adapt to the new default sql_mode 2017-02-10 06:30:42 -05:00