Re: Improving isolationtester's data output

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andres Freund <andres(at)anarazel(dot)de>
Cc: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Improving isolationtester's data output
Date: 2021-06-16 19:37:16
Message-ID: 795039.1623872236@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Andres Freund <andres(at)anarazel(dot)de> writes:
> On 2021-06-15 22:44:29 -0400, Tom Lane wrote:
>> + memset(&popt, 0, sizeof(popt));
>> + popt.header = true;
>> + popt.align = true;
>> + popt.fieldSep = "|";
>> + PQprint(stdout, res, &popt);

> Is there an argument for not aligning because that can make diffs larger
> than the actual data changes? E.g. one row being longer will cause all
> rows in the result set to be shown as differing because of the added
> padding? This has been a problem in the normal regression tests, where
> we solved it by locally disabling alignment. It might be unproblematic
> for isolationtester, because we don't often have large result sets...

I tried it that way first, and didn't much like the look of it.

I think the result sets in the isolation tests don't have a big
problem here: as you say, they aren't very large, and in most of them
the column widths are fairly uniform anyway.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2021-06-16 19:42:57 Re: Improving isolationtester's data output
Previous Message Tom Lane 2021-06-16 19:33:29 Re: Improving isolationtester's data output