Commit66d21c2

committed

Fix tests for 9.6

1 parentb2309a7 commit66d21c2Copy full SHA for 66d21c2

File tree

+15

-7

lines changed

+15

-7

lines changed

Lines changed: 6 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,17 +1,20 @@`
`1`	`1`	`CREATE EXTENSION pg_wait_sampling;`
`2`		`-SELECT SUM(0) FROM pg_wait_sampling_current;`
	`2`	`+WITH t as (SELECT sum(0) FROM pg_wait_sampling_current)`
	`3`	`+SELECT sum(0) FROM generate_series(1, 2), t;`
`3`	`4`	`sum`
`4`	`5`	`-----`
`5`	`6`	`0`
`6`	`7`	`(1 row)`
`7`	`8`
`8`		`-SELECT SUM(0) FROM pg_wait_sampling_history;`
	`9`	`+WITH t as (SELECT sum(0) FROM pg_wait_sampling_history)`
	`10`	`+SELECT sum(0) FROM generate_series(1, 2), t;`
`9`	`11`	`sum`
`10`	`12`	`-----`
`11`	`13`	`0`
`12`	`14`	`(1 row)`
`13`	`15`
`14`		`-SELECT SUM(0) FROM pg_wait_sampling_profile;`
	`16`	`+WITH t as (SELECT sum(0) FROM pg_wait_sampling_profile)`
	`17`	`+SELECT sum(0) FROM generate_series(1, 2), t;`
`15`	`18`	`sum`
`16`	`19`	`-----`
`17`	`20`	`0`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -418,7 +418,7 @@ pg_wait_sampling_get_current(PG_FUNCTION_ARGS)`
`418`	`418`	`{`
`419`	`419`	`PGPROC*proc=&ProcGlobal->allProcs[i];`
`420`	`420`
`421`		`-if (proc!=NULL&&proc->pid!=0)`
	`421`	`+if (proc!=NULL&&proc->pid!=0&&proc->wait_event_info)`
`422`	`422`	`{`
`423`	`423`	`params->items[j].pid=proc->pid;`
`424`	`424`	`params->items[j].wait_event_info=proc->wait_event_info;`

Lines changed: 8 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,8 +1,13 @@`
`1`	`1`	`CREATE EXTENSION pg_wait_sampling;`
`2`	`2`
`3`		`-SELECTSUM(0)FROM pg_wait_sampling_current;`
`4`		`-SELECTSUM(0)FROM pg_wait_sampling_history;`
`5`		`-SELECTSUM(0)FROM pg_wait_sampling_profile;`
	`3`	`+WITH tas (SELECTsum(0)FROM pg_wait_sampling_current)`
	`4`	`+SELECTsum(0)FROM generate_series(1,2), t;`
	`5`	`+`
	`6`	`+WITH tas (SELECTsum(0)FROM pg_wait_sampling_history)`
	`7`	`+SELECTsum(0)FROM generate_series(1,2), t;`
	`8`	`+`
	`9`	`+WITH tas (SELECTsum(0)FROM pg_wait_sampling_profile)`
	`10`	`+SELECTsum(0)FROM generate_series(1,2), t;`
`6`	`11`
`7`	`12`	`SELECT pg_wait_sampling_reset_profile();`
`8`	`13`

Comments

(0)