-- Test that ISOK_RESULTS rows go away when they are no longer returned
-- (absent a Keep_Until value)
BEGIN;
-- Run once to populate ISOK_RESULTS
SELECT irid, iqname, qr_id, qr_message, qr_extra
  FROM run_isok_queries($$VALUES ('query1');$$);
 irid | iqname | qr_id |   qr_message    | qr_extra 
------+--------+-------+-----------------+----------
   44 | query1 | R1    | Result number 1 | 
   45 | query1 | R2    | Result number 2 | 
   46 | query1 | R3    | Result number 3 | 
(3 rows)

-- Update the query to change the list of results
UPDATE isok_queries
  SET query = $$VALUES ('R2', 'Result number 2', NULL);$$;
-- Run again to update ISOK_RESULTS
-- See that only R2 is left
SELECT irid, iqname, qr_id, qr_message, qr_extra
  FROM run_isok_queries($$VALUES ('query1');$$);
 irid | iqname | qr_id |   qr_message    | qr_extra 
------+--------+-------+-----------------+----------
   45 | query1 | R2    | Result number 2 | 
(1 row)

ROLLBACK;