Duplicate Index Names

[pborissow]

Consider this example:

    MediaMatch: {
        fields: [
            {name: 'mediaItem',         type: 'MediaItem',  required: true},
            {name: 'matchingItem',      type: 'MediaItem',  required: true},
            {name: 'matchInfo',         type: 'json',       required: true}, //(e.g. hamming distance)
            {name: 'ignoreMatch',       type: 'boolean',    required: true, value: false}
        ],
        indexes: [
            {name: 'idx_media_match',   type: 'unique',     field: ['mediaItem','matchingItem']}
        ]
    }

This will generate a duplicate index name:

CREATE INDEX IDX_MEDIA_MATCH_MEDIA_ITEM ON MEDIA_MATCH(MEDIA_ITEM_ID);
CREATE INDEX IDX_MEDIA_MATCH_MEDIA_ITEM ON MEDIA_MATCH(MATCHING_ITEM_ID);

We need to ensure that index names are unique. A simple increment should suffice:

CREATE INDEX IDX_MEDIA_MATCH_MEDIA_ITEM ON MEDIA_MATCH(MEDIA_ITEM_ID);
CREATE INDEX IDX_MEDIA_MATCH_MEDIA_ITEM2 ON MEDIA_MATCH(MATCHING_ITEM_ID);