src/test/regress/expected/gp_log_mem_dispatch.out

-- Test that gp_log_backend_memory_contexts dispatches and
-- handles responses correctly
-- show expected number of successful responses to logging a
-- known-good session with no target contentID
WITH sessionCTE AS (
    SELECT sess_id
    FROM pg_stat_activity
    WHERE application_name = 'pg_regress/gp_log_mem_dispatch'
)
SELECT gp_log_backend_memory_contexts(sess_id) FROM sessionCTE;
 gp_log_backend_memory_contexts 
--------------------------------
                              3
(1 row)

-- show warnings and 0 successful responses to logging a
-- known-bad session
WITH noSessionCTE AS (
    SELECT MIN(sess_id) + 1 as no_sess_id
    FROM pg_stat_activity
    WHERE sess_id + 1 NOT IN (SELECT sess_id FROM pg_stat_activity)
)
SELECT gp_log_backend_memory_contexts(no_sess_id) FROM noSessionCTE;
WARNING:  unable to log memory contexts for session: "0", on contentID: "0"
WARNING:  unable to log memory contexts for session: "0", on contentID: "1"
WARNING:  unable to log memory contexts for session: "0", on contentID: "2"
 gp_log_backend_memory_contexts 
--------------------------------
                              0
(1 row)

-- show expected number of successful responses to logging a
-- known-good session with a target contentID
WITH sessionCTE AS (
    SELECT sess_id
    FROM pg_stat_activity
    WHERE application_name = 'pg_regress/gp_log_mem_dispatch'
)
SELECT gp_log_backend_memory_contexts(sess_id, 0) FROM sessionCTE;
 gp_log_backend_memory_contexts 
--------------------------------
                              1
(1 row)

-- show warnings and 0 successful responses to logging a
-- known-bad contentID
WITH sessionCTE AS (
    SELECT sess_id
    FROM pg_stat_activity
    WHERE application_name = 'pg_regress/gp_log_mem_dispatch'
)
SELECT gp_log_backend_memory_contexts(sess_id, -3) FROM sessionCTE;
WARNING:  "-3" is not a valid content ID
 gp_log_backend_memory_contexts 
--------------------------------
                              0
(1 row)