Actions
Bug #30807
closedbulk search api fails with "PG::SyntaxError: ERROR: syntax error at or near
Status:
Closed
Priority:
Normal
Assignee:
Category:
Foreman plugin
Target version:
Difficulty:
Triaged:
No
Pull request:
Description
"error": {"message":"PG::SyntaxError: ERROR: syntax error at or near \"DISTINCT\"\nLINE 1: ...ed_at, ended_at), current_timestamp) as duration, DISTINCT f...\n ^\n"}
The query getting generated:
SELECT DISTINCT foreman_tasks_tasks.*, coalesce(ended_at, current_timestamp) - coalesce(coalesce(started_at, ended_at), current_timestamp) as duration, DISTINCT foreman_tasks_tasks.*, foreman_tasks_tasks.*, coalesce(ended_at, current_timestamp) - coalesce(coalesce(started_at, ended_at), current_timestamp) as duration FROM "foreman_tasks_tasks" WHERE "foreman_tasks_tasks"."id" = '67b8d1dc-f0b2-4abb-8d20-dba2022a99c4' ORDER BY foreman_tasks_tasks.started_at DESC LIMIT 10 OFFSET 0
Actions