sqlite3_extended_result_codes(db, 1);
+ if (snapshot_scheme == NULL)
+ snapshot_scheme = "";
+
/* Insert this snapshot into the database, and determine the integer key
* which will be used to identify it. */
sqlite3_stmt *stmt = Prepare("insert into "
"values (?, ?, julianday('now'), ?)");
sqlite3_bind_text(stmt, 1, snapshot_name, strlen(snapshot_name),
SQLITE_TRANSIENT);
- if (snapshot_scheme == NULL)
- sqlite3_bind_null(stmt, 2);
- else
- sqlite3_bind_text(stmt, 2, snapshot_scheme, strlen(snapshot_scheme),
- SQLITE_TRANSIENT);
+ sqlite3_bind_text(stmt, 2, snapshot_scheme, strlen(snapshot_scheme),
+ SQLITE_TRANSIENT);
sqlite3_bind_double(stmt, 3, intent);
rc = sqlite3_step(stmt);
} else if (rc == SQLITE_ROW) {
ref = ObjectReference(IdToSegment(sqlite3_column_int64(stmt, 0)),
(const char *)sqlite3_column_text(stmt, 1));
- ref.set_range(0, size);
+ ref.set_range(0, size, true);
} else {
fprintf(stderr, "Could not execute SELECT statement!\n");
ReportError(rc);
sqlite3_stmt *stmt;
int found = false;
- stmt = Prepare("select algorithm, signatures from subblock_signatures "
+ stmt = Prepare("select signatures, algorithm from subblock_signatures "
"where blockid = (select blockid from block_index "
" where segmentid = ? and object = ?)");
sqlite3_bind_int64(stmt, 1, SegmentToId(ref.get_segment()));