mariadb/mysql-test/suite/gcol/t
Marko Mäkelä cffbb17480 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().

innobase_get_foreign_key_info(): Let my_error() refer to erroneous
anonymous constraints as "(null)".

row_delete_constraint(): Try to drop all 3 constraint name variants.

Reviewed by: Thirunarayanan Balathandayuthapani
Tested by: Matthias Leich
2025-07-08 12:30:27 +03:00
..
gcol_archive.test
gcol_blackhole.test
gcol_blocked_sql_funcs_innodb.test
gcol_blocked_sql_funcs_myisam.test
gcol_bug20746926.test
gcol_bugfixes.test MDEV-33281 Optimizer hints Cleanup: fix formatting, rename objects 2025-05-05 12:02:47 +07:00
gcol_column_def_options_innodb.test
gcol_column_def_options_myisam.test
gcol_handler_innodb.test
gcol_handler_myisam.test
gcol_ins_upd_innodb.test MDEV-17890 Server crash on DELETE with YEAR field with truncated expr 2021-07-12 22:00:39 +03:00
gcol_ins_upd_myisam.test
gcol_keys_innodb.test
gcol_keys_myisam.test
gcol_memory.test
gcol_merge.test
gcol_non_stored_columns_innodb.test
gcol_non_stored_columns_myisam.test
gcol_partition_innodb.test MDEV-32050 fixup: Stabilize tests 2023-11-21 12:42:00 +02:00
gcol_partition_myisam.test
gcol_purge.test MDEV-32050 fixup: Stabilize tests 2023-11-21 12:42:00 +02:00
gcol_rejected_innodb.test
gcol_rollback.test MDEV-30597 Assertion `flag == 1' failed in row_build_index_entry_low 2023-02-14 14:28:27 +05:30
gcol_select_innodb.test
gcol_select_myisam.test
gcol_supported_sql_funcs_innodb.test
gcol_supported_sql_funcs_myisam.test
gcol_trigger_sp_innodb.test
gcol_trigger_sp_myisam.test
gcol_update.test MDEV-32050 fixup: Stabilize tests 2023-11-21 12:42:00 +02:00
gcol_view_innodb.test
gcol_view_myisam.test
innodb_partition.test
innodb_prefix_index_check.test MDEV-13626 Merge InnoDB test cases from MySQL 5.7 2023-11-08 12:17:14 +02:00
innodb_virtual_basic.test MDEV-28933: Per-table unique FOREIGN KEY constraint names 2025-07-08 12:30:27 +03:00
innodb_virtual_blob.test MDEV-23497 Make ROW_FORMAT=COMPRESSED read-only by default 2020-11-11 11:15:11 +02:00
innodb_virtual_debug.test Merge 11.1 into 11.2 2023-11-28 11:19:06 +02:00
innodb_virtual_debug_purge.opt Merge 10.2 into 10.3 2019-09-23 10:25:34 +03:00
innodb_virtual_debug_purge.test Merge 10.5 into 10.6 2024-10-03 09:31:39 +03:00
innodb_virtual_fk.test MDEV-26866 FOREIGN KEY…SET NULL corrupts an index on a virtual column 2021-10-28 07:32:27 +03:00
innodb_virtual_fk_restart.test
innodb_virtual_index.opt MDEV-25872 InnoDB: Assertion failure in row_merge_read_clustered_index upon ALTER on table with indexed virtual columns 2021-06-15 13:15:32 +05:30
innodb_virtual_index.test Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
innodb_virtual_purge.test MDEV-32050 fixup: Stabilize tests 2023-11-21 12:42:00 +02:00
innodb_virtual_rebuild.test support 'alter online table t1 page_checksum=0' 2023-08-15 10:16:11 +02:00
innodb_virtual_stats.test MDEV-24564 Statistics are lost after ALTER TABLE 2021-01-28 14:15:01 +02:00
innodb_wl8114.test
main_alter_table.test MDEV-16678: Fix a problem with duplicate #sql2 table names 2019-12-10 16:18:30 +02:00
main_mysqldump.test
rpl_gcol.test
virtual_index_drop.test Fix build without either ENABLED_DEBUG_SYNC or DBUG_OFF 2022-09-23 17:37:52 +03:00