-- Unlogged relations exercise ambuildempty (init fork) and the
-- SET LOGGED / REINDEX rebuild path.
\set VERBOSITY terse
SET client_min_messages = warning;
CREATE EXTENSION IF NOT EXISTS pg_lion;
CREATE UNLOGGED TABLE lion_unlogged AS
SELECT i, (i % 137)::int4 AS k, 'v' || (i % 137) AS t
  FROM generate_series(1, 50000) i;
CREATE INDEX lion_unlogged_k ON lion_unlogged USING lion (k);
CREATE INDEX lion_unlogged_t ON lion_unlogged USING lion (t)
	WITH (inline_limit = 128);
ANALYZE lion_unlogged;
SET enable_seqscan = off;
EXPLAIN (COSTS OFF) SELECT count(*) FROM lion_unlogged WHERE k = 42;
                QUERY PLAN                
------------------------------------------
 Custom Scan (LionCount)
   Lion Indexes: lion_unlogged_k (k = 42)
(2 rows)

SELECT count(*), sum(i) FROM lion_unlogged WHERE k = 42;
 count |   sum   
-------+---------
   365 | 9116240
(1 row)

SELECT count(*), sum(i) FROM lion_unlogged WHERE t = 'v42';
 count |   sum   
-------+---------
   365 | 9116240
(1 row)

SET enable_bitmapscan = off; RESET enable_seqscan;
SELECT count(*), sum(i) FROM lion_unlogged WHERE k = 42;
 count |   sum   
-------+---------
   365 | 9116240
(1 row)

SELECT count(*), sum(i) FROM lion_unlogged WHERE t = 'v42';
 count |   sum   
-------+---------
   365 | 9116240
(1 row)

RESET enable_bitmapscan;
-- The init fork is written by ambuildempty; make the relation logged and
-- rebuild, then check the answers again.
ALTER TABLE lion_unlogged SET LOGGED;
REINDEX TABLE lion_unlogged;
SET enable_seqscan = off;
SELECT count(*), sum(i) FROM lion_unlogged WHERE k = 42;
 count |   sum   
-------+---------
   365 | 9116240
(1 row)

SELECT count(*), sum(i) FROM lion_unlogged WHERE t = 'v42';
 count |   sum   
-------+---------
   365 | 9116240
(1 row)

SET enable_bitmapscan = off; RESET enable_seqscan;
SELECT count(*), sum(i) FROM lion_unlogged WHERE k = 42;
 count |   sum   
-------+---------
   365 | 9116240
(1 row)

SELECT count(*), sum(i) FROM lion_unlogged WHERE t = 'v42';
 count |   sum   
-------+---------
   365 | 9116240
(1 row)

RESET enable_bitmapscan;
-- ... and back to unlogged, which runs ambuildempty again
ALTER TABLE lion_unlogged SET UNLOGGED;
SET enable_seqscan = off;
SELECT count(*), sum(i) FROM lion_unlogged WHERE k = 42;
 count |   sum   
-------+---------
   365 | 9116240
(1 row)

RESET enable_seqscan;
DROP TABLE lion_unlogged;