mirror/mariadb
1
0
Fork 0
mirror of https://github.com/MariaDB/server.git synced 2025-08-03 09:01:34 +02:00
Code Issues Projects Releases Packages Wiki Activity
mariadb/mysql-test/suite/innodb_fts/r
History
Exact
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
..
basic.result MDEV-25004 Missing row in FTS_DOC_ID_INDEX during DELETE HISTORY 2022-12-27 00:02:02 +03:00
bug_32831765.result MDEV-27913 innodb_ft_cache_size max possible value (80000000) is too small for practical purposes 2022-02-24 22:41:23 +05:30
concurrent_insert.result MDEV-19123 Change default charset from latin1 to utf8mb4 2024-07-11 10:21:07 +04:00
crash_recovery.result cleanup: key algorithm vs key flags 2024-11-05 14:00:47 -08:00
create,orig.rdiff Merge 10.6 into 10.11 2024-02-14 16:12:53 +02:00
create.result MDEV-19123 Change default charset from latin1 to utf8mb4 2024-07-11 10:21:07 +04:00
foreign_key_check.result MDEV-13626 Merge InnoDB test cases from MySQL 5.7 2023-11-08 12:17:14 +02:00
foreign_key_update.result MDEV-28933: Per-table unique FOREIGN KEY constraint names 2025-07-08 12:30:27 +03:00
ft_result_cache_limit.result Remove deprication from mariadbd --debug 2023-11-28 16:33:22 +02:00
fts_kill_query.result Merge 10.1 into 10.2 2018-08-02 08:19:57 +03:00
fts_sync_commit_resiliency.result MDEV-34057 Inconsistent FTS state in concurrent scenarios 2024-06-06 19:09:13 +05:30
fulltext.result Merge 11.4 into 11.7 2024-12-02 17:51:17 +02:00
fulltext2.result Merge 10.3 into 10.4 2022-12-13 11:37:33 +02:00
fulltext3.result Merge 10.1 into 10.2 2019-03-06 15:15:59 +02:00
fulltext_cache.result
fulltext_distinct.result MDEV-7563 Support CHECK constraint as in (or close to) SQL Standard 2016-06-30 11:43:02 +02:00
fulltext_left_join.result
fulltext_misc.result MDEV-19123 Change default charset from latin1 to utf8mb4 2024-07-11 10:21:07 +04:00
fulltext_multi.result
fulltext_order_by.result MDEV-34679 ER_BAD_FIELD uses non-localizable substrings 2024-10-17 21:37:37 +02:00
fulltext_update.result MDEV-7563 Support CHECK constraint as in (or close to) SQL Standard 2016-06-30 11:43:02 +02:00
fulltext_var.result MDEV-16172: Enable skipped tests 2018-05-17 09:37:01 +03:00
index_table.result MDEV-36061 Incorrect error handling on DDL with FULLTEXT INDEX 2025-02-13 16:28:06 +01:00
innodb-fts-ddl,vers.rdiff Merge branch '11.1' into 11.2 2024-04-09 12:12:33 +02:00
innodb-fts-ddl,vers_trx.rdiff Merge branch '11.1' into 11.2 2024-04-09 12:12:33 +02:00
innodb-fts-ddl.result MDEV-19123 Change default charset from latin1 to utf8mb4 2024-07-11 10:21:07 +04:00
innodb-fts-fic,vers.rdiff MDEV-30528 CREATE FULLTEXT INDEX assertion failure WITH SYSTEM VERSIONING 2024-02-12 16:52:55 +01:00
innodb-fts-fic,vers_trx.rdiff MDEV-30528 CREATE FULLTEXT INDEX assertion failure WITH SYSTEM VERSIONING 2024-02-12 16:52:55 +01:00
innodb-fts-fic.result MDEV-15253: Default optimizer setting changes for MariaDB 10.4 2018-12-09 09:22:00 +05:30
innodb_ft_aux_table.result MDEV-36420 Assertion failure in SET GLOBAL innodb_ft_aux_table 2025-03-28 09:05:20 +02:00
innodb_fts_large_records.result
innodb_fts_misc.result MDEV-35082 HANDLER with FULLTEXT keys is not always rejected 2024-10-08 18:20:13 +02:00
innodb_fts_misc_1.result MDEV-28933: Per-table unique FOREIGN KEY constraint names 2025-07-08 12:30:27 +03:00
innodb_fts_multiple_index.result MDEV-19123 Change default charset from latin1 to utf8mb4 2024-07-11 10:21:07 +04:00
innodb_fts_plugin.result Merge 10.5 into 10.6 2022-08-30 13:01:16 +03:00
innodb_fts_proximity.result Merge branch '10.11' into 11.0 2023-12-19 15:53:18 +01:00
innodb_fts_result_cache_limit.result MDEV-13134 Introduce ALTER TABLE attributes ALGORITHM=NOCOPY and ALGORITHM=INSTANT 2018-05-07 14:58:11 +05:30
innodb_fts_stopword_charset.result Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
innodb_fts_transaction.result MDEV-21921 Make transaction_isolation and transaction_read_only into system variables 2023-04-12 11:04:29 +10:00
limit_union.result MDEV-13626 Merge InnoDB test cases from MySQL 5.7 2023-11-08 12:17:14 +02:00
misc.result MariaDB 11.4.4 release 2024-11-08 07:17:00 +01:00
misc_1.result MDEV-28933: Per-table unique FOREIGN KEY constraint names 2025-07-08 12:30:27 +03:00
misc_debug,vers.rdiff Merge 10.5 into 10.6 2024-02-13 20:42:59 +02:00
misc_debug,vers_trx.rdiff Merge 10.5 into 10.6 2024-02-13 20:42:59 +02:00
misc_debug.result MDEV-30346 Avoid block device required error in innodb_fts.misc_debug 2023-01-05 11:07:55 +05:30
misc_debug2.result Merge 10.5 into 10.6 2022-10-12 12:14:13 +03:00
multiple_index.result Merge branch '11.5' into 11.6 2024-08-21 15:13:47 +02:00
opt.result Merge branch '10.11' into 11.0 2023-12-19 15:53:18 +01:00
phrase.result MDEV-13626 Merge InnoDB test cases from MySQL 5.7 2023-11-08 12:17:14 +02:00
plugin_debug.result MDEV-14231 MATCH() AGAINST( IN BOOLEAN MODE), results mismatch 2024-08-13 15:22:09 +05:30
result_cache_limit.result MDEV-13626 Merge InnoDB test cases from MySQL 5.7 2023-11-08 12:17:14 +02:00
savepoint.result MDEV-24035 Failing assertion: UT_LIST_GET_LEN(lock.trx_locks) == 0 causing disruption and replication failure 2024-12-12 18:02:00 +02:00
stopword,vers.rdiff MDEV-19123 Change default charset from latin1 to utf8mb4 2024-07-11 10:21:07 +04:00
stopword.result MDEV-19123 Change default charset from latin1 to utf8mb4 2024-07-11 10:21:07 +04:00
subexpr.result MDEV-13626 Merge InnoDB test cases from MySQL 5.7 2023-11-08 12:17:14 +02:00
sync.result MDEV-30996 insert.. select in presence of full text index freezes all other commits at commit time 2023-04-24 11:06:56 +05:30
sync_block.result Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
sync_ddl.result MDEV-30528 CREATE FULLTEXT INDEX assertion failure WITH SYSTEM VERSIONING 2024-02-12 16:52:55 +01:00
versioning,prepare.result MDEV-25004 Missing row in FTS_DOC_ID_INDEX during DELETE HISTORY 2022-12-27 00:02:02 +03:00
versioning.result Merge 10.6 into 10.7 2023-01-04 14:52:25 +02:00