isolation test output format

From: Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: isolation test output format
Date: 2021-11-17 01:44:00
Message-ID: CAKU4AWrmVNxEntEyzYw6V2HwKUZfsEr0arVMLSkEk2BiW6FAnA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi:

I'm using the isolation test to write some tests, and then I found the
output is unclear some time.
for example:

a b c
1988-12-14 01:03:031988-12-13 22:03:03-011988-12-14

Actually what I want is there are some spaces among the fields. like:

a b c
1988-12-14 01:03:03 1988-12-13 22:03:03-01 1988-12-14

The simplest reproduce case is:

setup
{
CREATE TABLE c_tm(a timestamp, b timestamptz, c date);
}

session "s1"
step "s1inserttm"
{
INSERT INTO c_tm VALUES('1988-12-14 01:03:03 +2', '1988-12-14
01:03:03 +2', '1988-12-14 01:03:03 +2');
}

step "s1read"
{
SELECT * FROM c_tm;
}

Is there any simple way to improve this?

--
Best Regards
Andy Fan

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Ken Kato 2021-11-17 01:44:44 CREATE tab completion
Previous Message Paul Jungwirth 2021-11-16 23:55:26 Re: SQL:2011 application time