Commit621ce28

committed

add tests for 'pathman_cache_stats' view

1 parent4d9d52a commit621ce28Copy full SHA for 621ce28

File tree

+49

-3

lines changed

+49

-3

lines changed

Lines changed: 28 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -670,6 +670,34 @@ NOTICE: drop cascades to table calamity.test_range_oid_1`
`670`	`670`	`DROP SCHEMA calamity CASCADE;`
`671`	`671`	`NOTICE: drop cascades to 18 other objects`
`672`	`672`	`DROP EXTENSION pg_pathman;`
	`673`	`+/*`
	`674`	`+ * -------------------------------------`
	`675`	`+ * Special tests (pathman_cache_stats)`
	`676`	`+ * -------------------------------------`
	`677`	`+ */`
	`678`	`+CREATE SCHEMA calamity;`
	`679`	`+CREATE EXTENSION pg_pathman;`
	`680`	`+/* check view pathman_cache_stats */`
	`681`	`+CREATE TABLE calamity.test_pathman_cache_stats(val NUMERIC NOT NULL);`
	`682`	`+SELECT create_range_partitions('calamity.test_pathman_cache_stats', 'val', 1, 10, 10);`
	`683`	`+NOTICE: sequence "test_pathman_cache_stats_seq" does not exist, skipping`
	`684`	`+ create_range_partitions`
	`685`	`+-------------------------`
	`686`	`+ 10`
	`687`	`+(1 row)`
	`688`	`+`
	`689`	`+SELECT context, entries FROM pathman_cache_stats ORDER BY context;/* OK */`
	`690`	`+ context \| entries`
	`691`	`+-------------------------+---------`
	`692`	`+ maintenance \| 0`
	`693`	`+ partition bounds cache \| 10`
	`694`	`+ partition parents cache \| 10`
	`695`	`+ partition pruning cache \| 1`
	`696`	`+(4 rows)`
	`697`	`+`
	`698`	`+DROP SCHEMA calamity CASCADE;`
	`699`	`+NOTICE: drop cascades to 12 other objects`
	`700`	`+DROP EXTENSION pg_pathman;`
`673`	`701`	`/*`
`674`	`702`	`* ------------------------------------------`
`675`	`703`	`* Special tests (uninitialized pg_pathman)`

Lines changed: 18 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -260,6 +260,24 @@ SELECT get_part_range('calamity.test_range_oid_1', NULL::INT4);/* OK */`
`260`	`260`
`261`	`261`	`DROPTABLEcalamity.test_range_oid CASCADE;`
`262`	`262`
	`263`	`+DROPSCHEMA calamity CASCADE;`
	`264`	`+DROP EXTENSION pg_pathman;`
	`265`	`+`
	`266`	`+`
	`267`	`+`
	`268`	`+/*`
	`269`	`+ * -------------------------------------`
	`270`	`+ * Special tests (pathman_cache_stats)`
	`271`	`+ * -------------------------------------`
	`272`	`+*/`
	`273`	`+`
	`274`	`+CREATESCHEMAcalamity;`
	`275`	`+CREATE EXTENSION pg_pathman;`
	`276`	`+`
	`277`	`+/* check view pathman_cache_stats*/`
	`278`	`+CREATETABLEcalamity.test_pathman_cache_stats(valNUMERICNOT NULL);`
	`279`	`+SELECT create_range_partitions('calamity.test_pathman_cache_stats','val',1,10,10);`
	`280`	`+SELECT context, entriesFROM pathman_cache_statsORDER BY context;/* OK*/`
`263`	`281`
`264`	`282`	`DROPSCHEMA calamity CASCADE;`
`265`	`283`	`DROP EXTENSION pg_pathman;`

Lines changed: 3 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -67,9 +67,9 @@ static inline const char *`
`67`	`67`	`simpify_mcxt_name(MemoryContextmcxt)`
`68`	`68`	`{`
`69`	`69`	`staticconstchar*top_mcxt="maintenance",`
`70`		`-*bound_mcxt="partitioninfo cache",`
`71`		`-*parent_mcxt="parent mapping cache",`
`72`		`-*constr_mcxt="bounds cache";`
	`70`	`+*bound_mcxt="partitionpruning cache",`
	`71`	`+*parent_mcxt="partition parents cache",`
	`72`	`+*constr_mcxt="partitionbounds cache";`
`73`	`73`
`74`	`74`	`if (mcxt==TopPathmanContext)`
`75`	`75`	`returntop_mcxt;`

Comments

(0)