# name: test/temp.test
# group: [temp]

statement ok
ATTACH '__TEST_DIR__/wal_replay_if_not_exists.db';

statement ok
USE wal_replay_if_not_exists;

statement ok
PRAGMA disable_checkpoint_on_shutdown;

statement ok
SET wal_autocheckpoint='1TB'

statement ok
CREATE TABLE t AS SELECT range::INT AS id FROM range(10);

statement ok
ALTER TABLE t ADD COLUMN IF NOT EXISTS r DOUBLE DEFAULT RANDOM();

statement ok
CREATE TABLE original AS SELECT id, r FROM t;

statement ok
USE memory;

statement ok
DETACH wal_replay_if_not_exists;

statement ok
ATTACH '__TEST_DIR__/wal_replay_if_not_exists.db';

statement ok
USE wal_replay_if_not_exists;

query I
SELECT COUNT(r) != 0 FROM t;
----
true

query I sort r1
SELECT r FROM t;
----

query I sort r1
SELECT r FROM original;
----