1. test/sql/join/asof/test_asof_join.test:92
================================================================================
Query unexpectedly failed! (test/sql/join/asof/test_asof_join.test:92)!
================================================================================
WITH trades AS (
    SELECT
        'AAPL' AS symbol,
        TIMESTAMP '2024-01-01 10:00:00' + idx * INTERVAL 10 SECONDS AS trade_time,
        100 AS quantity
    FROM range(64) AS trade_rows(idx)   -- hangs; change to 63 to succeed
),
quotes AS (
    SELECT
        'AAPL' AS symbol,
        TIMESTAMP '2024-01-01 09:59:50' + idx * INTERVAL 10 SECONDS AS quote_time,
        150.0 AS price
    FROM range(64) AS quote_rows(idx)
)
SELECT
    t.symbol,
    t.trade_time,
    t.quantity,
    q.quote_time,
    q.price,
    t.quantity * q.price AS notional
FROM trades AS t
ASOF LEFT JOIN quotes AS q
    ON t.symbol = q.symbol
   AND t.trade_time >= q.quote_time
LIMIT 5;
================================================================================
Invalid Error: Unoptimized statement differs from original result!
Original Result:
symbol	trade_time	quantity	quote_time	price	notional	
VARCHAR	TIMESTAMP	INTEGER	TIMESTAMP	DECIMAL(4,1)	DECIMAL(14,1)	
[ Rows: 5]
AAPL	2024-01-01 10:00:00	100	2024-01-01 10:00:00	150.0	15000.0
AAPL	2024-01-01 10:00:10	100	2024-01-01 10:00:10	150.0	15000.0
AAPL	2024-01-01 10:00:20	100	2024-01-01 10:00:20	150.0	15000.0
AAPL	2024-01-01 10:00:30	100	2024-01-01 10:00:30	150.0	15000.0
AAPL	2024-01-01 10:00:40	100	2024-01-01 10:00:40	150.0	15000.0

Unoptimized:
symbol	trade_time	quantity	quote_time	price	notional	
VARCHAR	TIMESTAMP	INTEGER	TIMESTAMP	DECIMAL(4,1)	DECIMAL(14,1)	
[ Rows: 5]
AAPL	2024-01-01 10:00:10	100	2024-01-01 10:00:10	150.0	15000.0
AAPL	2024-01-01 10:01:30	100	2024-01-01 10:01:30	150.0	15000.0
AAPL	2024-01-01 10:02:50	100	2024-01-01 10:02:50	150.0	15000.0
AAPL	2024-01-01 10:04:30	100	2024-01-01 10:04:30	150.0	15000.0
AAPL	2024-01-01 10:04:40	100	2024-01-01 10:04:40	150.0	15000.0