Details
- 
    Task 
- 
    Status: Closed (View Workflow)
- 
    Blocker 
- 
    Resolution: Won't Fix
- 
    None
Description
In 12.1 (MDEV-28933), FK names a now stored internally inside InnoDB as <schema><table><fkname>, not <schema><fkname>, new implementation is renaming user visible names, and I don't think it was strictly required, and may that be reverted ? 
The problem is that doing a quick check, that affect :
- mariadb java connector
- mariadb odbc connector
- mariadb c++ connector
- community .net connector
- and the equivalent mysql connectors
example of issue in connectors: new FK have now a name defaulting to '1' where is was like '<table>_ibfk_1'.
Joins on I_S.KEY_COLUMN_USAGE and I_S.REFERENTIAL_CONSTRAINTS are actually done on CONSTRAINT_CATALOG, CONSTRAINT_SCHEMA, and CONSTRAINT_NAME ( not using TABLE_NAME). The problem is that with a default value of a simple integer, the joins will now retrieve lots of value that corresponds to other tables, making not corrected connectors completly wrong.
So i wonder if default fk name can still be named like '<table>_ibfk_1' in place of '1'
Attachments
Issue Links
- causes
- 
                    CONCPP-143 Possible issues in getImportedKeys, getExportedKeys and getCrossReference with 12.1 server -         
- Closed
 
-         
- 
                    CONJ-1279 metadata table name addition for 12.1 -         
- Closed
 
-         
- is caused by
- 
                    MDEV-28933 Per-table unique FOREIGN KEY constraint names -         
- Closed
 
-