Bug #30807
closedbulk search api fails with "PG::SyntaxError: ERROR: syntax error at or near
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
Updated by The Foreman Bot about 4 years ago
- Status changed from New to Ready For Testing
- Pull request https://github.com/theforeman/foreman-tasks/pull/586 added
Updated by The Foreman Bot about 4 years ago
- Fixed in Releases foreman-tasks-3.0.1 added
Updated by John Mitsch about 4 years ago
- Has duplicate Bug #30923: Content view tasks page returns 500 ISE added
Updated by Justin Sherrill about 4 years ago
- Status changed from Ready For Testing to Closed
Applied in changeset a4f7c28574c1977abde0995eb1cdd779ebd2ca61.