use super::*;
fn lengths(connection: &Connection) -> Vec<(Vec<u8>, Vec<u8>, Option<i64>)> {
connection
.prepare("SELECT key, sequence, payload_length FROM _uqa_mvcc_version_metadata ORDER BY key, sequence")
.unwrap()
.query_map([], |row| Ok((row.get(0)?, row.get(1)?, row.get(2)?)))
.unwrap()
.collect::<rusqlite::Result<_>>()
.unwrap()
}
#[test]
fn metadata_tracks_revisions_tombstones_rekeys_and_rollback() {
let connection = Connection::open_in_memory().unwrap();
schema::initialize(&connection).unwrap();
let _permit = schema::WritePermit::acquire(&connection).unwrap();
let transaction = schema::begin(&connection).unwrap();
transaction
.execute_batch(
"INSERT INTO _uqa_mvcc_versions VALUES
(x'61', x'0000000000000001', x''),
(x'61', x'0000000000000002', x'010203'),
(x'61', x'0000000000000003', NULL);",
)
.unwrap();
let expected = [(1, Some(0)), (2, Some(3)), (3, None)]
.map(|(sequence, size)| (vec![b'a'], u64::to_be_bytes(sequence).to_vec(), size));
assert_eq!(lengths(&transaction), expected);
transaction.execute_batch(
"SAVEPOINT preserved;
UPDATE _uqa_mvcc_versions SET key = x'62', sequence = x'0000000000000004', value = x'ff' WHERE sequence = x'0000000000000002';
DELETE FROM _uqa_mvcc_versions WHERE key = x'61';")
.unwrap();
assert_eq!(
lengths(&transaction),
[(vec![b'b'], 4_u64.to_be_bytes().to_vec(), Some(1))]
);
transaction
.execute_batch("ROLLBACK TO preserved; RELEASE preserved")
.unwrap();
assert_eq!(lengths(&transaction), expected);
transaction.rollback().unwrap();
assert!(lengths(&connection).is_empty());
}
#[test]
fn version_metadata_failure_rolls_back_the_source_statement() {
let connection = Connection::open_in_memory().unwrap();
schema::initialize(&connection).unwrap();
let _permit = schema::WritePermit::acquire(&connection).unwrap();
connection.execute_batch("CREATE TRIGGER fail_metadata BEFORE INSERT ON _uqa_mvcc_version_metadata BEGIN SELECT RAISE(ABORT, 'metadata write failed'); END").unwrap();
assert!(connection
.execute_batch("INSERT INTO _uqa_mvcc_versions VALUES (x'61', x'0000000000000001', x'ff')")
.is_err());
assert_eq!(
connection
.query_row("SELECT count(*) FROM _uqa_mvcc_versions", [], |row| row
.get::<_, i64>(0))
.unwrap(),
0
);
assert!(lengths(&connection).is_empty());
}