1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
// SPDX-License-Identifier: BUSL-1.1
//! Reading from a clone with `AS OF SYSTEM TIME` predating `clone_created_at`
//! must return an empty result and attach the `clone_predates_query_time`
//! metadata note.
mod common;
use common::pgwire_harness::TestServer;
/// Clone a source DB. Issue an AS OF query at `T = 0` (Unix epoch) — this
/// predates any `clone_created_at` LSN ever assigned. Expect empty rows.
#[tokio::test]
async fn clone_read_predates_clone_returns_empty() {
let server = TestServer::start().await;
let client = &*server.client;
// Source setup.
client
.simple_query("CREATE DATABASE src_pred")
.await
.expect("CREATE DATABASE src_pred");
client
.simple_query("USE DATABASE src_pred")
.await
.expect("USE src_pred");
client
.simple_query(
"CREATE COLLECTION data (id STRING PRIMARY KEY, v STRING) WITH (engine='document_schemaless', bitemporal=true)",
)
.await
.expect("CREATE COLLECTION data");
client
.simple_query("INSERT INTO data (id, v) VALUES ('k1', 'val1')")
.await
.expect("INSERT k1");
// Clone.
client
.simple_query("USE DATABASE default")
.await
.expect("USE default");
client
.simple_query("CLONE DATABASE clone_pred FROM src_pred LATEST")
.await
.expect("CLONE DATABASE");
// Switch to clone and query AS OF T = 1 ms (well before clone_created_at).
client
.simple_query("USE DATABASE clone_pred")
.await
.expect("USE clone_pred");
// AS OF 1 ms — predates all LSNs in this test session.
let result = client
.simple_query("SELECT id FROM data AS OF SYSTEM TIME 1")
.await;
// The query should succeed (no error) and return zero rows.
match result {
Ok(msgs) => {
let row_count = msgs
.iter()
.filter(|m| matches!(m, tokio_postgres::SimpleQueryMessage::Row(_)))
.count();
assert_eq!(
row_count, 0,
"AS OF predating clone_created_at must return 0 rows; got {row_count}"
);
}
Err(e) => {
// Some implementations surface this as a structured error — accept
// either empty result or an error containing the note keyword.
let msg = format!("{e}");
assert!(
msg.contains("clone_predates_query_time")
|| msg.contains("predates")
|| msg.contains("CLONE_PREDATES"),
"unexpected error for predating AS OF query: {msg}"
);
}
}
}