[HACKERS] wrong t_bits alignment in pageinspect
Maksim Milyutin <milyutinma@gmail.com>
From: Maksim Milyutin <milyutinma@gmail.com>
To: PostgreSQL mailing lists <pgsql-hackers@postgresql.org>
Date: 2017-12-15T13:53:41Z
Lists: pgsql-hackers
Attachments
- pageinspect_tbits_alignment_fix.patch (text/x-patch) patch
Hi!
I found out the problem in exposing values of t_bits field from
heap_page_items function.
When the number of attributes in table is multiple of eight, t_bits
column shows double number of bits in which data fields are included.
For example:
# create table tbl(f1 int, f2 int, f3 int, f4 int, f5 int, f6 int, f7
int, f8 int);
# insert into tbl(f1, f8) values (x'f1'::int, 0);
# select t_bits, t_data from heap_page_items(get_raw_page('tbl', 0));
t_bits | t_data
------------------+--------------------
1000000110001111 | \xf100000000000000
I suppose the prefix 10000001 corresponds to real value of t_bits, the
rest part 10001111 - to the lower byte of f1 field of tbl.
Attached patch fixes this issue.
--
Regards,
Maksim Milyutin
Commits
-
Fix new test case to not be endian-dependent.
- 18869e202b74 11.0 landed
- 0dc5dfcd7a71 10.2 landed
-
Fix incorrect computations of length of null bitmap in pageinspect.
- ad592f4a6eed 9.6.7 landed
- 5ad1b1728767 10.2 landed
- 39cfe86195f0 11.0 landed