Skip to content

drop operation_id from the flow_unique_scope index #51730

@blizzz

Description

@blizzz
                                      Table "public.oc_flow_operations_scope"
    Column    |         Type          | Collation | Nullable |                       Default                        
--------------+-----------------------+-----------+----------+------------------------------------------------------
 id           | bigint                |           | not null | nextval('oc_flow_operations_scope_id_seq'::regclass)
 operation_id | integer               |           | not null | 
 type         | integer               |           | not null | 
 value        | character varying(64) |           |          | NULL::character varying
Indexes:
    "oc_flow_operations_scope_pkey" PRIMARY KEY, btree (id)
    "flow_unique_scope" UNIQUE, btree (operation_id, type, value)

The operation_id shall be dropped from the flow_unique_scope index, as common queries only compare with type and value but not operation_id.

  • verify that operation_id is not used in where clauses

Metadata

Metadata

Assignees

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions