mariadb/mysql-test/suite
Marko Mäkelä 08bf62213c MDEV-28933: Per-table unique FOREIGN KEY constraint names
Before MySQL 4.0.18, user-specified constraint names were ignored.
Starting with MySQL 4.0.18, the specified constraint name was
prepended with the schema name and '/'.  Now we are transforming
into a format where the constraint name is prepended with the
dict_table_t::name and the impossible UTF-8 sequence 0xff.
Generated constraint names will be ASCII decimal numbers.

On upgrade, old FOREIGN KEY constraint names will be displayed
without any schema name prefix. They will be updated to the new
format on DDL operations.

dict_foreign_t::sql_id(): Return the SQL constraint name
without any schemaname/tablename\377 or schemaname/ prefix.

row_rename_table_for_mysql(), dict_table_rename_in_cache():
Simplify the logic: Just rename constraints to the new format.

dict_table_get_foreign_id(): Replaces dict_table_get_highest_foreign_id().

row_delete_constraint(): Try to drop all 3 constraint name variants.
2025-06-18 12:35:53 +02:00
..
archive Merge branch '10.5' into 10.6 2024-12-17 11:06:09 +11:00
atomic MDEV-25292 Atomic CREATE OR REPLACE TABLE 2025-03-31 20:09:03 +03:00
binlog MDEV-28933: Per-table unique FOREIGN KEY constraint names 2025-06-18 12:35:53 +02:00
binlog_encryption MDEV-25292 Atomic CREATE OR REPLACE TABLE 2025-03-31 20:09:03 +03:00
client MDEV-14978 fix client.client-env-variable test 2024-10-19 16:53:16 +02:00
compat Merge 11.4 into 11.8 2025-03-05 20:39:47 +02:00
csv
encryption MDEV-9158 post-merge fixes 2025-02-11 20:31:36 +01:00
engines MDEV-36099 Ensure that creation and usage of temporary tables in replication is predictable 2025-03-28 16:18:21 +02:00
events MDEV-36425 Extend read_only to also block share locks and super user 2025-04-03 13:23:24 +03:00
federated Merge 11.4 into 11.8 2025-03-05 20:39:47 +02:00
funcs_1 MDEV-28933: Per-table unique FOREIGN KEY constraint names 2025-06-18 12:35:53 +02:00
funcs_2
galera MDEV-28933: Per-table unique FOREIGN KEY constraint names 2025-06-18 12:35:53 +02:00
galera_3nodes Merge branch '11.4' into 11.7 2025-02-06 16:46:36 +01:00
galera_3nodes_sr MDEV-35124 Set innodb_snapshot_isolation=ON by default 2024-10-11 15:02:31 +03:00
galera_sr Merge branch '11.4' into 11.7 2025-02-06 16:46:36 +01:00
gcol MDEV-28933: Per-table unique FOREIGN KEY constraint names 2025-06-18 12:35:53 +02:00
handler Merge 11.4 into 11.7 2025-01-09 09:41:38 +02:00
heap Merge branch '11.4' into 11.7 2025-02-06 16:46:36 +01:00
innodb MDEV-28933: Per-table unique FOREIGN KEY constraint names 2025-06-18 12:35:53 +02:00
innodb_fts MDEV-28933: Per-table unique FOREIGN KEY constraint names 2025-06-18 12:35:53 +02:00
innodb_gis Merge branch '11.4' into 11.7 2025-02-06 16:46:36 +01:00
innodb_i_s
innodb_zip Merge branch '11.4' into 11.7 2025-02-06 16:46:36 +01:00
jp
json MariaDB 11.4.4 release 2024-11-08 07:17:00 +01:00
large_tests
maria MDEV-25292 Atomic CREATE OR REPLACE TABLE 2025-03-31 20:09:03 +03:00
mariabackup MDEV-25292 Atomic CREATE OR REPLACE TABLE 2025-03-31 20:09:03 +03:00
merge MDEV-19123 Change default charset from latin1 to utf8mb4 2024-07-11 10:21:07 +04:00
mtr/t Remove dates from all rdiff files 2025-01-05 16:40:11 +02:00
mtr2
multi_source MDEV-35304: Add Connects_Tried and Master_Retry_Count to SSS 2025-02-26 20:37:53 -07:00
optimizer_unfixed_bugs
parts MDEV-25292 Atomic CREATE OR REPLACE TABLE 2025-03-31 20:09:03 +03:00
perfschema MDEV-36425 Extend read_only to also block share locks and super user 2025-04-03 13:23:24 +03:00
perfschema_stress
period MDEV-25292 Atomic CREATE OR REPLACE TABLE 2025-03-31 20:09:03 +03:00
plugins Merge 11.4 into 11.7 2025-01-09 09:41:38 +02:00
roles 12.0 branch 2025-02-12 12:37:38 +01:00
rpl MDEV-28933: Per-table unique FOREIGN KEY constraint names 2025-06-18 12:35:53 +02:00
s3 Merge branch '11.7' into 11.8 2025-02-11 20:29:43 +01:00
sql_sequence MDEV-36425 Extend read_only to also block share locks and super user 2025-04-03 13:23:24 +03:00
storage_engine MDEV-28933: Per-table unique FOREIGN KEY constraint names 2025-06-18 12:35:53 +02:00
stress MDEV-34453 Trying to read 16384 bytes at 70368744161280 outside the bounds of the file: ./ibdata1 2024-09-20 20:26:43 +05:30
sys_vars MDEV-36425 Extend read_only to also block share locks and super user 2025-04-03 13:23:24 +03:00
sysschema MDEV-31736: format_bytes implementation 2024-11-26 13:10:01 +04:00
unit Merge branch '11.4' into 11.5 2024-08-05 17:50:18 +02:00
vcol MDEV-28933: Per-table unique FOREIGN KEY constraint names 2025-06-18 12:35:53 +02:00
versioning MDEV-28933: Per-table unique FOREIGN KEY constraint names 2025-06-18 12:35:53 +02:00
wsrep Merge 11.4 into 11.8 2025-03-05 20:39:47 +02:00