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
part_exch_qa_1.inc
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
part_exch_tabs.inc cleanup parts.partition_exch_* tests 2017-09-18 10:40:26 +02:00
part_supported_sql_funcs_delete.inc
part_supported_sql_funcs_main.inc
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
partition_bit.inc
partition_blob.inc
partition_blocked_sql_funcs.inc
partition_char.inc
partition_check.inc MDEV-31005: Make working cursor-protocol 2024-09-18 18:39:26 +07:00
partition_check_drop.inc
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
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
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
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
partition_syntax.inc
partition_syntax_1.inc
partition_syntax_2.inc
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
partition_varbinary.inc
partition_varchar.inc
partition_year.inc MDEV-7635: Update tests to adapt to the new default sql_mode 2017-02-10 06:30:42 -05:00