-- 1. Create a ReplacingMergeTree table with event_created_at as version column
CREATE OR REPLACE TABLE prewhere_bug_events ON CLUSTER '{cluster}'
(
    id UInt64,
    project_id UInt64,
    event_created_at DateTime64(3),
    value String,
    is_deleted UInt8 DEFAULT 0
) ENGINE = ReplacingMergeTree(event_created_at, is_deleted)
ORDER BY (project_id, id);

-- 2. Create a simple dimension table for the JOIN
CREATE OR REPLACE TABLE prewhere_bug_dim ON CLUSTER '{cluster}'
(
    project_id UInt64,
    name String
) ENGINE = MergeTree()
ORDER BY project_id;

-- 3. Insert test data
INSERT INTO prewhere_bug_events VALUES (1, 100, now(), 'hello', 0);
INSERT INTO prewhere_bug_dim VALUES (100, 'project_a');

-- 4. Direct query: PREWHERE on version column with FINAL works fine
SELECT count()
FROM prewhere_bug_events FINAL
PREWHERE event_created_at <= now();
-- ✅ Works

-- 5. Parameterized view with a JOIN and PREWHERE on version column
CREATE OR REPLACE VIEW prewhere_bug_view ON CLUSTER '{cluster}' AS
SELECT t.*, d.name
FROM (
    SELECT *
    FROM prewhere_bug_events FINAL
    PREWHERE project_id IN ({project_ids:Array(UInt64)})
        AND event_created_at <= toDateTime64({cutoff:String}, 3)
) AS t
ANY LEFT JOIN prewhere_bug_dim AS d
    ON t.project_id = d.project_id;

-- 6. Query the view referencing the PREWHERE column in the SELECT: WORKS
SELECT count(event_created_at)
FROM prewhere_bug_view(project_ids=[100], cutoff='2099-01-01 00:00:00');
-- ✅ Works

-- 7. Query the view WITHOUT referencing the PREWHERE column: FAILS
SELECT count()
FROM prewhere_bug_view(project_ids=[100], cutoff='2099-01-01 00:00:00');
-- ❌ DB::Exception: Not found column event_created_at in block.