odd-platform
odd-platform copied to clipboard
Wrong data entity task run bulk update
Currently we are generating the next query for updating task runs:
update "public"."data_entity_task_run" set "start_time" = "v"."start_time", "oddrn" = "v"."oddrn", "end_time" = "v"."end_time", "task_oddrn" = "v"."task_oddrn", "type" = "v"."type", "status" = "v"."status", "status_reason" = "v"."status_reason", "name" = "v"."name" from (values (null, '123123', timestamp '2000-10-31 06:30:00.0', timestamp '2000-10-31 07:30:00.0', '111222323', 'FAILED', 'DATA_QUALITY_TEST_RUN', 'oddrn', 'qa run1')) as "v" ("id", "oddrn", "start_time", "end_time", "status_reason", "status", "type", "task_oddrn", "name") where "public"."data_entity_task_run"."id" = "v"."id" returning "public"."data_entity_task_run"."id", "public"."data_entity_task_run"."oddrn", "public"."data_entity_task_run"."start_time", "public"."data_entity_task_run"."end_time", "public"."data_entity_task_run"."status_reason", "public"."data_entity_task_run"."status", "public"."data_entity_task_run"."type", "public"."data_entity_task_run"."task_oddrn", "public"."data_entity_task_run"."name"
Since id is null we actually don't update anything. Need to update task runs by ODDRN