Commit0916eba

committed

Fix commit_ts test suite for systems with coarse timestamp granularity.

Noticed on a couple of Windows configurations.Petr Jelinek, reviewed by Michael Paquier.

1 parent733a264 commit0916ebaCopy full SHA for 0916eba

File tree

-6

lines changed

-6

lines changed

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -13,7 +13,7 @@ INSERT INTO committs_test DEFAULT VALUES;`
`13`	`13`	`INSERT INTO committs_test DEFAULT VALUES;`
`14`	`14`	`SELECT id,`
`15`	`15`	`pg_xact_commit_timestamp(xmin) >= ts,`
`16`		`- pg_xact_commit_timestamp(xmin) < now(),`
	`16`	`+ pg_xact_commit_timestamp(xmin) <= now(),`
`17`	`17`	`pg_xact_commit_timestamp(xmin) - ts < '60s' -- 60s should give a lot of reserve`
`18`	`18`	`FROM committs_test`
`19`	`19`	`ORDER BY id;`
`@@ -31,7 +31,7 @@ SELECT pg_xact_commit_timestamp('1'::xid);`
`31`	`31`	`ERROR: cannot retrieve commit timestamp for transaction 1`
`32`	`32`	`SELECT pg_xact_commit_timestamp('2'::xid);`
`33`	`33`	`ERROR: cannot retrieve commit timestamp for transaction 2`
`34`		`-SELECT x.xid::text::bigint > 0, x.timestamp > '-infinity'::timestamptz, x.timestamp < now() FROM pg_last_committed_xact() x;`
	`34`	`+SELECT x.xid::text::bigint > 0, x.timestamp > '-infinity'::timestamptz, x.timestamp <= now() FROM pg_last_committed_xact() x;`
`35`	`35`	`?column? \| ?column? \| ?column?`
`36`	`36`	`----------+----------+----------`
`37`	`37`	`t \| t \| t`

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -13,7 +13,7 @@ INSERT INTO committs_test DEFAULT VALUES;`
`13`	`13`	`INSERT INTO committs_test DEFAULT VALUES;`
`14`	`14`	`SELECT id,`
`15`	`15`	`pg_xact_commit_timestamp(xmin) >= ts,`
`16`		`- pg_xact_commit_timestamp(xmin) < now(),`
	`16`	`+ pg_xact_commit_timestamp(xmin) <= now(),`
`17`	`17`	`pg_xact_commit_timestamp(xmin) - ts < '60s' -- 60s should give a lot of reserve`
`18`	`18`	`FROM committs_test`
`19`	`19`	`ORDER BY id;`
`@@ -29,6 +29,6 @@ HINT: Make sure the configuration parameter "track_commit_timestamp" is set.`
`29`	`29`	`SELECT pg_xact_commit_timestamp('2'::xid);`
`30`	`30`	`ERROR: could not get commit timestamp data`
`31`	`31`	`HINT: Make sure the configuration parameter "track_commit_timestamp" is set.`
`32`		`-SELECT x.xid::text::bigint > 0, x.timestamp > '-infinity'::timestamptz, x.timestamp < now() FROM pg_last_committed_xact() x;`
	`32`	`+SELECT x.xid::text::bigint > 0, x.timestamp > '-infinity'::timestamptz, x.timestamp <= now() FROM pg_last_committed_xact() x;`
`33`	`33`	`ERROR: could not get commit timestamp data`
`34`	`34`	`HINT: Make sure the configuration parameter "track_commit_timestamp" is set.`

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -10,7 +10,7 @@ INSERT INTO committs_test DEFAULT VALUES;`
`10`	`10`
`11`	`11`	`SELECT id,`
`12`	`12`	`pg_xact_commit_timestamp(xmin)>= ts,`
`13`		`- pg_xact_commit_timestamp(xmin)< now(),`
	`13`	`+ pg_xact_commit_timestamp(xmin)<= now(),`
`14`	`14`	`pg_xact_commit_timestamp(xmin)- ts<'60s'-- 60s should give a lot of reserve`
`15`	`15`	`FROM committs_test`
`16`	`16`	`ORDER BY id;`
`@@ -21,4 +21,4 @@ SELECT pg_xact_commit_timestamp('0'::xid);`
`21`	`21`	`SELECT pg_xact_commit_timestamp('1'::xid);`
`22`	`22`	`SELECT pg_xact_commit_timestamp('2'::xid);`
`23`	`23`
`24`		`-SELECTx.xid::text::bigint>0,x.timestamp>'-infinity'::timestamptz,x.timestamp< now()FROM pg_last_committed_xact() x;`
	`24`	`+SELECTx.xid::text::bigint>0,x.timestamp>'-infinity'::timestamptz,x.timestamp<= now()FROM pg_last_committed_xact() x;`

Comments

(0)