Commit00a8685

committed

pageinspect: Make page test more portable

Choose test data that makes the output independent of endianness.

1 parent14ee357 commit00a8685Copy full SHA for 00a8685

File tree

-5

lines changed

-5

lines changed

Lines changed: 3 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,6 +1,6 @@`
`1`	`1`	`CREATE EXTENSION pageinspect;`
`2`		`-CREATE TABLE test1 (a int, btext);`
`3`		`-INSERT INTO test1 VALUES (1, 'one');`
	`2`	`+CREATE TABLE test1 (a int, bint);`
	`3`	`+INSERT INTO test1 VALUES (16777217, 131584);`
`4`	`4`	`VACUUM test1; -- set up FSM`
`5`	`5`	`-- The page contents can vary, so just test that it can be read`
`6`	`6`	`-- successfully, but don't keep the output.`
`@@ -47,7 +47,7 @@ SELECT tuple_data_split('test1'::regclass, t_data, t_infomask, t_infomask2, t_bi`
`47`	`47`	`FROM heap_page_items(get_raw_page('test1', 0));`
`48`	`48`	`tuple_data_split`
`49`	`49`	`-------------------------------`
`50`		`- {"\\x01000000","\\x096f6e65"}`
	`50`	`+ {"\\x01000001","\\x00020200"}`
`51`	`51`	`(1 row)`
`52`	`52`
`53`	`53`	`SELECT * FROM fsm_page_contents(get_raw_page('test1', 'fsm', 0));`

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,7 +1,7 @@`
`1`	`1`	`CREATE EXTENSION pageinspect;`
`2`	`2`
`3`		`-CREATETABLEtest1 (aint, btext);`
`4`		`-INSERT INTO test1VALUES (1,'one');`
	`3`	`+CREATETABLEtest1 (aint, bint);`
	`4`	`+INSERT INTO test1VALUES (16777217,131584);`
`5`	`5`
`6`	`6`	`VACUUM test1;-- set up FSM`
`7`	`7`

Comments

(0)