diff options
Diffstat (limited to 'src/test/modules/commit_ts/sql/commit_timestamp.sql')
-rw-r--r-- | src/test/modules/commit_ts/sql/commit_timestamp.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/test/modules/commit_ts/sql/commit_timestamp.sql b/src/test/modules/commit_ts/sql/commit_timestamp.sql index 9beb78a91d2..4e041a53473 100644 --- a/src/test/modules/commit_ts/sql/commit_timestamp.sql +++ b/src/test/modules/commit_ts/sql/commit_timestamp.sql @@ -10,7 +10,7 @@ INSERT INTO committs_test DEFAULT VALUES; SELECT id, pg_xact_commit_timestamp(xmin) >= ts, - pg_xact_commit_timestamp(xmin) < now(), + pg_xact_commit_timestamp(xmin) <= now(), pg_xact_commit_timestamp(xmin) - ts < '60s' -- 60s should give a lot of reserve FROM committs_test ORDER BY id; @@ -21,4 +21,4 @@ SELECT pg_xact_commit_timestamp('0'::xid); SELECT pg_xact_commit_timestamp('1'::xid); SELECT pg_xact_commit_timestamp('2'::xid); -SELECT x.xid::text::bigint > 0, x.timestamp > '-infinity'::timestamptz, x.timestamp < now() FROM pg_last_committed_xact() x; +SELECT x.xid::text::bigint > 0, x.timestamp > '-infinity'::timestamptz, x.timestamp <= now() FROM pg_last_committed_xact() x; |