[YSQL] Bitmap Scan Crash with no columns required from a NLJ relation

[timothy-e]

Jira Link: DB-10901

Description

explain /*+ NestLoop(c ns) SeqScan(c) BitmapScan(ns) */ 
select c.relname from pg_class c, pg_namespace ns
where ns.oid = c.relnamespace and c.relname > 'a';
                                        QUERY PLAN
-------------------------------------------------------------------------------------------
 Nested Loop  (cost=0.30..467.23 rows=100 width=64)
   ->  Seq Scan on pg_class c  (cost=0.00..102.50 rows=100 width=68)
         Storage Filter: (relname > 'a'::name)
   ->  YB Bitmap Table Scan on pg_namespace ns  (cost=0.30..4.31 rows=1 width=4)
         ->  Bitmap Index Scan on pg_namespace_oid_index  (cost=0.00..0.30 rows=1 width=0)
               Index Cond: (oid = c.relnamespace)
(6 rows)

Running the query results in a crash

explain analyze /*+ NestLoop(c ns) SeqScan(c) BitmapScan(ns) */  
select c.relname from pg_class c, pg_namespace ns
where ns.oid = c.relnamespace and c.relname > 'a';

because it expected a non-null tuple and got a null one.

The bitmap scan yielded a all-null tuple because it (correctly) determined that the actual value of its tuples wasn't relevant. Since all of its conditions were satisfied by the Bitmap Index Scan, there's no need to fetch from the main table.

Issue Type

kind/bug

Warning: Please confirm that this issue does not contain any sensitive information

• I confirm this issue does not contain any sensitive information.