apache/dolphinscheduler

[DSIP-43] Unify index name in Mysql/PG

Open

#16 048 ouverte le 22 mai 2024

Voir sur GitHub
 (0 commentaires) (0 réactions) (0 assignés)Java (4 324 forks)batch import
DSIPhelp wanted

Métriques du dépôt

Stars
 (11 659 stars)
Métriques de merge PR
 (Merge moyen 2j 21h) (22 PRs mergées en 30 j)

Description

Search before asking

  • I had searched in the DSIP and found no similar DSIP.

Motivation

Right now, the index name in Mysql/PG might be different, since in PG the index name should be unique in the whole database, but in mysql the index name can only unique in the table.

It's better to unify the index name, this means we need to make the index name unique in the whole database.

Design Detail

Index name template: idx_{table_name}_{index_name}

Compatibility, Deprecation, and Migration Plan

Compatibility with the latest version but need to execute DDL.

Test Plan

Test by IT.

Code of Conduct

Guide contributeur