-- ## 79: Bugs silently producing wrong answers (by priority) ## --

-- This is a list of bugs that produce answers that are incorrect without warning the user.
-- 
-- In order to get on this list someone needs to fill in the Stopgaps field on the ticket, linking to other tickets that warn the user about the problem.  See #12691.

SELECT id AS ticket, status, p.value as __color__, 
       t.time as created,
(CASE WHEN EXTRACT(EPOCH FROM CURRENT_TIMESTAMP) - changetime/1000000 > 2 * 86400
         THEN round(CAST((EXTRACT(EPOCH FROM CURRENT_TIMESTAMP) - changetime/1000000) / 86400 AS numeric), 0) || ' days'
         WHEN EXTRACT(EPOCH FROM CURRENT_TIMESTAMP) - changetime/1000000 > 3600
         THEN round(CAST((EXTRACT(EPOCH FROM CURRENT_TIMESTAMP) - changetime/1000000) / 3600 AS numeric), 0) || ' hours'
         WHEN EXTRACT(EPOCH FROM CURRENT_TIMESTAMP) - changetime/1000000 > 60
         THEN round(CAST((EXTRACT(EPOCH FROM CURRENT_TIMESTAMP) - changetime/1000000) / 60 AS numeric), 0) || ' mins'
         ELSE round(CAST(EXTRACT(EPOCH FROM CURRENT_TIMESTAMP) - changetime/1000000 AS numeric), 0) || ' secs'
   END) AS Lasmod, component,
t.summary, t.owner 
  FROM ticket t, ticket_custom, enum p
  WHERE t.status <> 'closed' AND t.type = 'defect' AND 
        ticket_custom.ticket = t.id AND ticket_custom.name = 'stopgaps' AND ticket_custom.value != ''
        AND p.name=t.priority AND p.type='priority'
  ORDER BY __color__, t.time