From: t.katsumata1122@gmail.com
To: pgsql-bugs@postgresql.org
Subject: BUG #14476: crosstabview reports mistaken location
Date: Sun, 25 Dec 2016 02:15:19 +0000
Message-ID: <20161225021519.10139.45460@wrigleys.postgresql.org> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-bugs>
The following bug has been logged on the website:
Bug reference: 14476
Logged by: Tomonari Katsumata
Email address: t.katsumata1122@gmail.com
PostgreSQL version: 9.6.1
Operating system: macOS Sierra 10.12.1
Description:
Hi,
I'm playing with crosstabview, PostgreSQL9.6 new feature.
And I noticed the error message is not correct when it has duplicate data.
-- How to reproduce -----
create table ctv(x int, y int, v text);
insert into ctv values (1, generate_series(1,10), '*');
insert into ctv values (1, 10, '*'); -- duplicate data
select * from ctv;
\crosstabview
-------------------------
The last 2 statements work like below.
postgres=# select * from ctv;
x | y | v
---+----+---
1 | 1 | *
1 | 2 | *
1 | 3 | *
1 | 4 | *
1 | 5 | *
1 | 6 | *
1 | 7 | *
1 | 8 | *
1 | 9 | *
1 | 10 | *
1 | 10 | *
(11 rows)
postgres=# \crosstabview
\crosstabview: query result contains multiple data values for row "1",
column "9"
In above case, although there is duplicate data on row(x):1 and
column(y):10,
row(x):1 and column(y):9 is not duplicate.
So I think it should be the message say
\crosstabview: query result contains multiple data values for row "1",
column "10"
It seems this problem is reproduced when number of row is higher than 10.
Could you check this, please?
Best regards,
-------
Tomonari Katsumata
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: t.katsumata1122@gmail.com
Subject: Re: BUG #14476: crosstabview reports mistaken location
In-Reply-To: <20161225021519.10139.45460@wrigleys.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox