Consider adding ConstraintMetaData to metadata to support constraint segment merge logic

[strongduanmu]

Feature Request

To support handling of foreign key constraints in issue #16050, ConstraintMetaData needs to be added to the metadata.

Add Map<String, Constraint MetaData> constraints to TableMetaData:

/**
 * Table meta data.
 */
@Getter
@EqualsAndHashCode
@ToString
public final class TableMetaData {

    private final String name;

    private final Map<String, ColumnMetaData> columns;

    private final Map<String, IndexMetaData> indexes;

    private final Map<String, ConstraintMetaData> constrains;

    private final List<String> primaryKeyColumns = new ArrayList<>();
}

/**
 * Constraint meta data.
 */
@RequiredArgsConstructor
@Getter
@EqualsAndHashCode
@ToString
public final class ConstraintMetaData {

    private final String name;

    private final String referencedTableName;
}

Then add query logic for constraints in MySQLTableMetaDataLoader.

SELECT CONSTRAINT_NAME, TABLE_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE
       WHERE TABLE_NAME IN ('bmsql_district_0') AND REFERENCED_TABLE_SCHEMA IS NOT NULL;

• [x] Support MySQL constraint meta data load
• [x] Support Postgresql constraint meta data load
• [ ] Support openGauss constraint meta data load
• [ ] Support Oracle constraint meta data load
• [ ] Support SQLServer constraint meta data load

Is your feature request related to a problem?

issue #16050

Describe the feature you would like.

[TeslaCN]

Hi @strongduanmu Any update here? Could we finish this in 5.1.1?

[strongduanmu]

@TeslaCN Can not finish in 5.1.1, I will change the milestone.

[lhyundeadsoul]

@strongduanmu For this issue, do you mean we should continue to implement constraint segment merge logic in SQLServer/Oracle/openGauss/Postgresql metadataloader like mysql?

[strongduanmu]

@lhyundeadsoul Yes, are you interested in completing it?

[github-actions[bot]]

Hello , this issue has not received a reply for several days. This issue is supposed to be closed.

[github-actions[bot]]

There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.

[TherChenYang]

I will handle the Oracle-related part.