-- Generate queries with wal write
/*dddbs='postgres.db',traceparent='00-00000000000000000000000000000001-0000000000000001-01'*/ INSERT INTO pg_tracing_test VALUES(generate_series(1, 10), 'aaa');
/*dddbs='postgres.db',traceparent='00-00000000000000000000000000000002-0000000000000002-01'*/ UPDATE pg_tracing_test SET b = 'bbb' WHERE a = 7;
/*dddbs='postgres.db',traceparent='00-00000000000000000000000000000003-0000000000000003-01'*/ DELETE FROM pg_tracing_test WHERE a = 9;

-- Check WAL is generated for the above statements
SELECT trace_id, span_type, span_operation,
       wal_records > 0 as wal_records,
       wal_bytes > 0 as wal_bytes
FROM peek_ordered_spans;
CALL clean_spans();

-- Cleanup
CALL clean_spans();