query-simple.txt

text/plain

Filename: query-simple.txt

Type: text/plain

Part: 2

Message: Parallel Bitmap Heap Scans segfaults due to (tbm->dsa==NULL) on PostgreSQL 10

-- increase cpu_tuple_cost to force parallel query
set cpu_tuple_cost = 1;

select
    *
from
    part
where
    (
        p_container in ('SM CASE', 'SM BOX', 'SM PACK', 'SM PKG')
        and p_size between 1 and 5
    )
    or
    (
        p_container in ('MED BAG', 'MED BOX', 'MED PKG', 'MED PACK')
        and p_size between 1 and 10
    );