| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | t(dot)katsumata1122(at)gmail(dot)com |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #14476: crosstabview reports mistaken location |
| Date: | 2016-12-25 21:07:37 |
| Message-ID: | 17567.1482700057@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
t(dot)katsumata1122(at)gmail(dot)com writes:
> I'm playing with crosstabview, PostgreSQL9.6 new feature.
> And I noticed the error message is not correct when it has duplicate data.
Yup, you're right.
> It seems this problem is reproduced when number of row is higher than 10.
It looks to me like the triggering condition is that the data values
aren't in ASCII (strcmp()) order. As long as they are, the "pivot value"
array order matches the rank order and so the error message accidentally
selects the appropriate array entries.
Fix pushed, thanks for the report!
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | nte | 2016-12-26 09:36:34 | BUG #14478: Right Trim trims too much? |
| Previous Message | John R Pierce | 2016-12-25 17:34:00 | Re: BUG #14477: Can't start service because of upgrade-like installation |