src/test/singlenode_isolation2/expected/runaway_query.out

CREATE EXTENSION IF NOT EXISTS gp_inject_fault;
CREATE
CREATE OR REPLACE LANGUAGE plpgsql;
CREATE

CREATE TABLE runaway_query_test_table(a bigint NOT NULL);
CREATE

-- Use error fault to simulate vmem protect error and force cancel query.
SELECT gp_inject_fault_infinite('gpdbwrappers_get_comparison_operator', 'error', 1);
 gp_inject_fault_infinite 
--------------------------
 Success:                 
(1 row)

-- Following query will trip the fault during ORCA optimization
EXPLAIN (COSTS OFF) SELECT a FROM runaway_query_test_table WHERE (a = ANY ((ARRAY[42])));
 QUERY PLAN                              
-----------------------------------------
 Seq Scan on runaway_query_test_table    
   Filter: (a = ANY ('{42}'::integer[])) 
 Optimizer: Postgres query optimizer     
(3 rows)

SELECT gp_inject_fault('all', 'reset', 1);
 gp_inject_fault 
-----------------
 Success:        
(1 row)