mariadb/mysql-test/suite/gcol/t
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
..
gcol_archive.test
gcol_blackhole.test
gcol_blocked_sql_funcs_innodb.test
gcol_blocked_sql_funcs_myisam.test
gcol_bug20746926.test
gcol_bugfixes.test cleanup: select ... into tests 2025-02-11 20:31:25 +01: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-06-18 12:35:53 +02: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
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 MDEV-32050: Deprecate&ignore innodb_purge_rseg_truncate_frequency 2023-10-25 09:11:58 +03: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
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