mariadb/mysql-test/suite
Daniele Sciascia 841763ecc0 MDEV-35018 MDL BF-BF conflict on DROP TABLE
DROP TABLE on child and UPDATE of parent table can cause an MDL BF-BF
conflict when applied concurrently.
DROP TABLE takes MDL locks on both child and its parent table, however
it only it did not add certification keys for the parent table.
This patch adds the following:
 * Append certification keys corresponding to all parent tables
   before DROP TABLE replication.
 * Fix wsrep_append_fk_parent_table() so that it works when it is
   given a table list containing temporary tables.
 * Make sure function wsrep_append_fk_parent_table() is only called
   for local transaction. That was not the case for ALTER TABLE.
 * Add a test case that verifies that UPDATE parent depends on
   preceeding DROP TABLE child.
 * Adapt galera_ddl_fk_conflict test to work with DROP TABLE as well.

Signed-off-by: Julius Goryavsky <julius.goryavsky@mariadb.com>
2024-12-18 12:11:02 +01:00
..
archive MDEV-22964: archive.archive and main.mysqlbinlog_{row,stmt}_compressed) 2024-12-16 10:04:07 +11:00
binlog MDEV-35350: Backport search_pattern_in_file.inc SEARCH_WAIT to 10.5 2024-11-12 05:54:50 -07:00
binlog_encryption MDEV-34318 mariadb-dump SQL syntax error with MAX_STATEMENT_TIME against Percona MySQL server 2024-07-17 21:25:40 +02:00
client
compat MDEV-31005: Make working cursor-protocol 2024-09-18 18:39:26 +07:00
csv Backporting bugs fixes fixed by MDEV-31340 from 11.5 2024-05-21 14:58:01 +04:00
encryption MDEV-31005: Make working cursor-protocol 2024-09-18 18:39:26 +07:00
engines MDEV-31005: Make working cursor-protocol 2024-09-18 18:39:26 +07:00
federated MDEV-31005: Make working cursor-protocol 2024-09-18 18:39:26 +07:00
funcs_1 MDEV-34716 Fix mysql.servers socket max length too short 2024-12-17 10:40:57 +11:00
funcs_2 MDEV-30233 DROP DATABASE test fails: Directory not empty 2022-12-15 11:14:23 +02:00
galera MDEV-35018 MDL BF-BF conflict on DROP TABLE 2024-12-18 12:11:02 +01:00
galera_3nodes MDEV-35473 : Sporadic failures in the galera_3nodes.galera_evs_suspect_timeout mtr test 2024-11-28 01:02:35 +01:00
galera_3nodes_sr galera mtr tests: correction of inaccuracies in warnings suppressions 2024-07-08 23:36:21 +02:00
galera_sr MDEV-35344: post-fix correction for other galera tests 2024-11-06 04:59:10 +01:00
gcol MDEV-31005: Make working cursor-protocol 2024-09-18 18:39:26 +07:00
handler MDEV-30263 Assertion failure in Protocol::end_statement upon HANDLER READ with invalid timestamp 2024-12-13 16:27:14 +01:00
heap Merge remote-tracking branch 'origin/10.4' into 10.5 2022-09-14 16:24:51 +04:00
innodb MDEV-35115 Inconsistent Replace behaviour when multiple unique index exist 2024-11-08 16:46:41 +05:30
innodb_fts Correct cursor protocol tests main.{loaddata,grant_plugin} & innodb_fts.fulltext 2024-11-21 21:43:44 +11:00
innodb_gis MDEV-35116 InnoDB fails to set error index for HA_ERR_NULL_IN_SPATIAL 2024-10-14 14:28:24 +05:30
innodb_i_s Merge remote-tracking branch '10.4' into 10.5 2023-03-31 21:32:41 +02:00
innodb_zip MDEV-16944 Fix file sharing issues on Windows in mysqltest 2024-04-17 16:52:37 +02:00
jp MDEV-29446 Change SHOW CREATE TABLE to display default collation 2022-09-12 22:10:39 +04:00
json MDEV-31005: Make working cursor-protocol 2024-09-18 18:39:26 +07:00
large_tests MDEV-16944 Fix file sharing issues on Windows in mysqltest 2024-04-17 16:52:37 +02:00
maria MDEV-22935 Erroneous Aria Index / Optimizer behaviour 2024-06-05 10:29:49 +03:00
mariabackup Skip mariabackup.slave_provision_nolock in --valgrind, it uses a lot of CPU 2024-08-26 14:39:24 +02:00
mtr/t
mtr2
multi_source Merge from 10.4 to 10.5 2024-04-15 17:46:49 +02:00
optimizer_unfixed_bugs MDEV-29710: Disable some slow tests on Valgrind 2022-10-06 08:42:26 +03:00
parts MDEV-35648 Update partition lc2 tests for mac 2024-12-17 15:28:33 +11:00
perfschema MDEV-31005: Make working cursor-protocol 2024-09-18 18:39:26 +07:00
perfschema_stress
period MDEV-31005: Make working cursor-protocol 2024-09-18 18:39:26 +07:00
plugins MDEV-35604: SIGSEGV in filter_query_type | log_statement_ex / auditing 2024-12-09 09:42:26 +01:00
roles MDEV-31005: Make working cursor-protocol 2024-09-18 18:39:26 +07:00
rpl MDEV-35098 rpl.rpl_mysqldump_gtid_slave_pos fails in buildbot 2024-12-16 19:43:41 +02:00
s3 also protect the /*!999999 sandbox comment 2024-07-17 21:25:40 +02:00
sql_sequence MDEV-35144 CREATE TABLE ... LIKE uses current innodb_compression_default instead of the create value 2024-10-17 16:28:39 +02:00
storage_engine
stress MDEV-29710: Skip some more tests on Valgrind 2022-10-05 20:37:54 +03:00
sys_vars Revert "MDEV-35019 Provide a way to enable "rollback XA on disconnect" behavior we had before 10.5.2" 2024-10-16 13:23:47 +02:00
unit
vcol MDEV-31005: Make working cursor-protocol 2024-09-18 18:39:26 +07:00
versioning MDEV-15330 Cleanup: load_data.test removed 2024-12-03 13:49:42 +03:00
wsrep wsrep mtr suite: update for galera library 26.4.21 2024-12-17 09:57:29 +01:00