diff options
Diffstat (limited to 'src/services/chart/core.ts')
| -rw-r--r-- | src/services/chart/core.ts | 11 |
1 files changed, 6 insertions, 5 deletions
diff --git a/src/services/chart/core.ts b/src/services/chart/core.ts index 14cbd92802..8e301e8309 100644 --- a/src/services/chart/core.ts +++ b/src/services/chart/core.ts @@ -201,11 +201,12 @@ export default abstract class Chart<T extends Record<string, any>> { ...Chart.convertSchemaToFlatColumnDefinitions(schema) }, indices: [{ - columns: ['date'] - }, { - columns: ['group'] - }, { - columns: ['date', 'group'] + columns: ['date', 'group'], + unique: true, + }, { // groupにnullが含まれると↑のuniqeuは機能しないので↓の部分インデックスでカバー + columns: ['date'], + unique: true, + where: '"group" IS NULL' }] }); } |