apache/dolphinscheduler
[DSIP-43] Unify index name in Mysql/PG
Aberta
#16.048 aberto em 22 de mai. de 2024
DSIPhelp wanted
Métricas do repositório
- Stars
- (11.659 estrelas)
- Métricas de merge de PR
- (Métricas PR pendentes)
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
- I agree to follow this project's Code of Conduct