PREPARE a AS
SELECT
        sum(l_extendedprice* (1 - l_discount)) AS revenue
FROM
        lineitem,
        part
WHERE
        (
                p_partkey = l_partkey
                AND p_brand = 'Brand#12'
                AND p_container IN ('SM CASE', 'SM BOX', 'SM PACK', 'SM PKG')
                AND l_quantity >= $1::INT8 AND l_quantity <= $2::INT8 + $3::INT8
                AND p_size BETWEEN $4::INT8 AND $5::INT8
                AND l_shipmode IN ('AIR', 'AIR REG')
                AND l_shipinstruct = 'DELIVER IN PERSON'
        )
        OR
        (
                p_partkey = l_partkey
                AND p_brand = 'Brand#23'
                AND p_container IN ('MED BAG', 'MED BOX', 'MED PKG', 'MED PACK')
                AND l_quantity >= $6::INT8 AND l_quantity <= $7::INT8 + $8::INT8
                AND p_size BETWEEN $9::INT8 AND $10::INT8
                AND l_shipmode IN ('AIR', 'AIR REG')
                AND l_shipinstruct = 'DELIVER IN PERSON'
        )
        OR
        (
                p_partkey = l_partkey
                AND p_brand = 'Brand#34'
                AND p_container IN ('LG CASE', 'LG BOX', 'LG PACK', 'LG PKG')
                AND l_quantity >= $11::INT8 AND l_quantity <= $12::INT8 + $13::INT8
                AND p_size BETWEEN $14::INT8 AND $15::INT8
                AND l_shipmode IN ('AIR', 'AIR REG')
                AND l_shipinstruct = 'DELIVER IN PERSON'
        );

EXECUTE a (1673233313264295902, -4186914802014225748, -7803608356647854650, -5768974227681701054, 6147046892692608078, 4509856040659122238,
-4890422720946384205, 3010902388656962727, -4573648270356357913, -1, -72244564248780116, 6200919156443866755, -5477045100534121521, 9198064680970225660, 2534917103370126968);

set vectorize=experimental_on;

EXECUTE a (1673233313264295902, -4186914802014225748, -7803608356647854650, -5768974227681701054, 6147046892692608078, 4509856040659122238,
-4890422720946384205, 3010902388656962727, -4573648270356357913, -1, -72244564248780116, 6200919156443866755, -5477045100534121521, 9198064680970225660, 2534917103370126968);

  revenue  
+---------+
  NULL     
(1 row)

Time: 8.61737499s

SET

Time: 190.527µs

pq: integer out of range