Fix new test case to not be endian-dependent.

tglsfdc · tglsfdc · commit 18869e202b74 · 2018-01-04T16:00:21.000-05:00
Per buildfarm. Discussion: https://postgr.es/m/ec295792-a69f-350f-6287-25a20e8f31d5@gmail.com
diff --git a/contrib/pageinspect/expected/page.out b/contrib/pageinspect/expected/page.out
@@ -94,18 +94,18 @@ ERROR:  block number 0 is out of range for relation "test_part1"
 drop table test_partitioned;
 -- check null bitmap alignment for table whose number of attributes is multiple of 8
 create table test8 (f1 int, f2 int, f3 int, f4 int, f5 int, f6 int, f7 int, f8 int);
-insert into test8(f1, f8) values (x'f1'::int, 0);
+insert into test8(f1, f8) values (x'7f00007f'::int, 0);
 select t_bits, t_data from heap_page_items(get_raw_page('test8', 0));
   t_bits  |       t_data       
 ----------+--------------------
- 10000001 | \xf100000000000000
+ 10000001 | \x7f00007f00000000
 (1 row)
 
 select tuple_data_split('test8'::regclass, t_data, t_infomask, t_infomask2, t_bits)
     from heap_page_items(get_raw_page('test8', 0));
                       tuple_data_split                       
 -------------------------------------------------------------
- {"\\xf1000000",NULL,NULL,NULL,NULL,NULL,NULL,"\\x00000000"}
+ {"\\x7f00007f",NULL,NULL,NULL,NULL,NULL,NULL,"\\x00000000"}
 (1 row)
 
 drop table test8;
diff --git a/contrib/pageinspect/sql/page.sql b/contrib/pageinspect/sql/page.sql
@@ -44,7 +44,7 @@ drop table test_partitioned;
 
 -- check null bitmap alignment for table whose number of attributes is multiple of 8
 create table test8 (f1 int, f2 int, f3 int, f4 int, f5 int, f6 int, f7 int, f8 int);
-insert into test8(f1, f8) values (x'f1'::int, 0);
+insert into test8(f1, f8) values (x'7f00007f'::int, 0);
 select t_bits, t_data from heap_page_items(get_raw_page('test8', 0));
 select tuple_data_split('test8'::regclass, t_data, t_infomask, t_infomask2, t_bits)
     from heap_page_items(get_raw_page('test8', 0));
