-- Running run_isok_queries() saves results in ISOK_RESULTS
BEGIN;
-- Omit the role, search_path, and (non-NULL) timestamps from the
-- column list, they change and cause the test to fail.
SELECT irid, iqname, deferred_to, category
     , keep_until, qr_id, qr_message, qr_extra, notes
  FROM run_isok_queries() AS riq
  ORDER BY riq.irid;
 irid |   iqname    | deferred_to | category | keep_until | qr_id |   qr_message    | qr_extra | notes 
------+-------------+-------------+----------+------------+-------+-----------------+----------+-------
    1 | errorquery2 |             |          |            | R4    | Result number 4 |          | 
    2 | errorquery2 |             |          |            | R5    | Result number 5 |          | 
    3 | errorquery2 |             |          |            | R6    | Result number 6 |          | 
    4 | query1      |             |          |            | R1    | Result number 1 |          | 
    5 | query1      |             |          |            | R2    | Result number 2 |          | 
    6 | query1      |             |          |            | R3    | Result number 3 |          | 
(6 rows)

  
-- This output should look just like the above output, only with
-- a "resolved" column
SELECT irid, iqname, resolved, deferred_to, category
     , keep_until, qr_id, qr_message, qr_extra, notes
  FROM isok_results
  ORDER BY isok_results.irid;
 irid |   iqname    | resolved | deferred_to | category | keep_until | qr_id |   qr_message    | qr_extra | notes 
------+-------------+----------+-------------+----------+------------+-------+-----------------+----------+-------
    1 | errorquery2 |          |             |          |            | R4    | Result number 4 |          | 
    2 | errorquery2 |          |             |          |            | R5    | Result number 5 |          | 
    3 | errorquery2 |          |             |          |            | R6    | Result number 6 |          | 
    4 | query1      |          |             |          |            | R1    | Result number 1 |          | 
    5 | query1      |          |             |          |            | R2    | Result number 2 |          | 
    6 | query1      |          |             |          |            | R3    | Result number 3 |          | 
(6 rows)

ROLLBACK;
-- Cleanup
-- Reset the sequence so what this test did is ignored.
SELECT setval('isok_results_irid_seq', 1, FALSE);
 setval 
--------
      1
(1 row)