text: -- start_ignore
  SET gp_create_table_random_default_distribution=off;
  -- end_ignore
  
  -- create select uao table with BLOCKSIZE=8K 
  DROP TABLE IF EXISTS uao_tab_blocksize_8k cascade;
  
  CREATE TABLE uao_tab_blocksize_8k  with (appendonly=true , BLOCKSIZE=8192 )  AS (
  SELECT GENERATE_SERIES::numeric sno
       , (random() * 10000000)::numeric + 10000000 val1
       , timeofday()::varchar(50) val2
       , (random() * 5000)::bigint + 10000000 val3
       , (random() * 10000000)::numeric + 10000000 val4
       , (random() * 10000000)::numeric + 10000000 val5	
    FROM GENERATE_SERIES(10000, 19999)
  ) ;
  CREATE index val3_bmp_idxblocksize_8k on uao_tab_blocksize_8k using bitmap (val3);
  \d+ uao_tab_blocksize_8k 
  SELECT count(*) from uao_tab_blocksize_8k;
  SELECT 1 AS VisimapPresent  FROM pg_appendonly WHERE visimapidxid is not NULL AND visimapidxid is not NULL AND relid=(SELECT oid FROM pg_class WHERE relname='uao_tab_blocksize_8k');
  
  select 1 as block8k_present from pg_appendonly WHERE   blocksize=8192 AND relid=(SELECT oid  FROM pg_class WHERE relname='uao_tab_blocksize_8k');
  
  -- create select uao table with BLOCKSIZE=2048K 
  
  DROP TABLE IF EXISTS uao_tab_blocksize_2048k cascade;
  CREATE TABLE uao_tab_blocksize_2048k  with (appendonly=true , BLOCKSIZE=2097152 )  AS (
  SELECT GENERATE_SERIES::numeric sno
       , (random() * 10000000)::numeric + 10000000 val1
       , timeofday()::varchar(50) val2
       , (random() * 5000)::bigint + 10000000 val3
       , (random() * 10000000)::numeric + 10000000 val4
       , (random() * 10000000)::numeric + 10000000 val5	
    FROM GENERATE_SERIES(10000, 19999)
  ) ;
  CREATE index val3_bmp_idxblocksize_2048k on uao_tab_blocksize_2048k using bitmap (val3);
  
  \d+ uao_tab_blocksize_2048k 
  
  SELECT count(*) from uao_tab_blocksize_2048k;
  SELECT 1 AS VisimapPresent  FROM pg_appendonly WHERE visimapidxid is not NULL AND visimapidxid is not NULL AND relid=(SELECT oid FROM pg_class WHERE relname='uao_tab_blocksize_2048k');
  
  select 1 as block2048k_present from pg_appendonly WHERE   blocksize=2097152 AND relid=(SELECT oid  FROM pg_class WHERE relname='uao_tab_blocksize_2048k');
  
  -- create select uao table with BLOCKSIZE=default
  
  DROP TABLE IF EXISTS uao_tab_blocksize_default cascade;
  
  CREATE TABLE uao_tab_blocksize_default with (appendonly=true)  AS (
  SELECT GENERATE_SERIES::numeric sno
       , (random() * 10000000)::numeric + 10000000 val1
       , timeofday()::varchar(50) val2
       , (random() * 5000)::bigint + 10000000 val3
       , (random() * 10000000)::numeric + 10000000 val4
       , (random() * 10000000)::numeric + 10000000 val5	
    FROM GENERATE_SERIES(10000, 19999)
  ) ;
  CREATE index val3_bmp_idxblocksize_default on uao_tab_blocksize_default using bitmap (val3);
  \d+ uao_tab_blocksize_default 
  SELECT count(*) from uao_tab_blocksize_default;
  SELECT 1 AS VisimapPresent  FROM pg_appendonly WHERE visimapidxid is not NULL AND visimapidxid is not NULL AND relid=(SELECT oid FROM pg_class WHERE relname='uao_tab_blocksize_default');
  
  select 1 as blockdefault_present from pg_appendonly WHERE   blocksize=32768 AND relid=(SELECT oid  FROM pg_class WHERE relname='uao_tab_blocksize_default');
  
  