Commit3e527ae

committed

pg_stat_statements: Add test coverage for pg_stat_statements_reset_1_7

Run pg_stat_statements_reset() once while the appropriate extensionversion is installed.Reviewed-by: Michael Paquier <michael@paquier.xyz>Discussion:https://www.postgresql.org/message-id/flat/40d1e4f2-835f-448f-a541-8ff5db75bf3d@eisentraut.org

1 parent3727b8d commit3e527aeCopy full SHA for 3e527ae

File tree

+14

-0

lines changed

contrib/pg_stat_statements
- expected
  - oldextversions.out
- sql
  - oldextversions.sql

+14

-0

lines changed

Lines changed: 12 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -52,6 +52,12 @@ SELECT pg_get_functiondef('pg_stat_statements_reset'::regproc);`
`52`	`52`
`53`	`53`	`(1 row)`
`54`	`54`
	`55`	`+SELECT pg_stat_statements_reset();`
	`56`	`+ pg_stat_statements_reset`
	`57`	`+--------------------------`
	`58`	`+`
	`59`	`+(1 row)`
	`60`	`+`
`55`	`61`	`\d pg_stat_statements`
`56`	`62`	`View "public.pg_stat_statements"`
`57`	`63`	`Column \| Type \| Collation \| Nullable \| Default`
`@@ -330,4 +336,10 @@ SELECT pg_get_functiondef('pg_stat_statements_reset'::regproc);`
`330`	`336`
`331`	`337`	`(1 row)`
`332`	`338`
	`339`	`+SELECT pg_stat_statements_reset() IS NOT NULL AS t;`
	`340`	`+ t`
	`341`	`+---`
	`342`	`+ t`
	`343`	`+(1 row)`
	`344`	`+`
`333`	`345`	`DROP EXTENSION pg_stat_statements;`

Lines changed: 2 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -28,6 +28,7 @@ SET SESSION AUTHORIZATION pg_read_all_stats;`
`28`	`28`	`SELECT pg_stat_statements_reset();`
`29`	`29`	`RESET SESSION AUTHORIZATION;`
`30`	`30`	`SELECT pg_get_functiondef('pg_stat_statements_reset'::regproc);`
	`31`	`+SELECT pg_stat_statements_reset();`
`31`	`32`	`\d pg_stat_statements`
`32`	`33`	`SELECTcount(*)>0AS has_dataFROM pg_stat_statements;`
`33`	`34`
`@@ -55,5 +56,6 @@ AlTER EXTENSION pg_stat_statements UPDATE TO '1.11';`
`55`	`56`	`SELECTcount(*)>0AS has_dataFROM pg_stat_statements;`
`56`	`57`	`-- New parameter minmax_only of pg_stat_statements_reset function`
`57`	`58`	`SELECT pg_get_functiondef('pg_stat_statements_reset'::regproc);`
	`59`	`+SELECT pg_stat_statements_reset()IS NOT NULLAS t;`
`58`	`60`
`59`	`61`	`DROP EXTENSION pg_stat_statements;`

Comments

(0)