[CONJ-765] Allow MariaDbDatabaseMetaData#getExportedKeys to return the exported keys for all tables Created: 2020-03-02 Updated: 2020-03-18 Resolved: 2020-03-04 |
|
| Status: | Closed |
| Project: | MariaDB Connector/J |
| Component/s: | metadata |
| Affects Version/s: | 2.5.4 |
| Fix Version/s: | 2.6.0 |
| Type: | Task | Priority: | Major |
| Reporter: | Guillaume Grossetie | Assignee: | Diego Dupin |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | metadata | ||
| Description |
|
Currently the table parameter is mandatory: I think it would be useful to return the exported keys for all tables if the parameter is null. We could also allow a search pattern (using LIKE):
As a workaround it's possible to send N queries to retrieve the exported keys for N tables but it's detrimental (performance wise). We might need to do the same for MariaDbDatabaseMetaData#getImportedKeys to be consistent. Interestingly, it's already possible to retrieve the primary keys for all tables using MariaDbDatabaseMetaData#getPrimaryKeys. |
| Comments |
| Comment by Diego Dupin [ 2020-03-04 ] |
|
This restriction has no reason, particulary since other methods implements this possibility. |