| From: | Emre Hasegeli <emre(at)hasegeli(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, tomasz(dot)kontusz(at)gmail(dot)com, PostgreSQL Bugs <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Re: BUG #14637: Tests fail with pl_PL.UTF-8 locale |
| Date: | 2017-05-25 14:44:39 |
| Message-ID: | CAE2gYzxJZJRjR4fwcS66VLKDMcHLk_d0VzqGJjP7X18J5g0z-g@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
> FWIW, I tried to reproduce the OP's reported failure with pl_PL.UTF-8,
> but it seems to pass fine for me. This implies that that locale works
> differently on his Ubuntu box than my RHEL box, which makes the idea
> of trying to guarantee that it works even more problematic.
It works on my computer too:
> hasegeli=# select 'I- 580 Ramp' < 'I- 580/I-680 Ramp' collate "en_US";
> ?column?
> ----------
> t
> (1 row)
But not on my Debian box:
> debian=# select 'I- 580 Ramp' < 'I- 580/I-680 Ramp' collate "en_US";
> ?column?
> ----------
> f
> (1 row)
It is fine with COLLATE "C":
> debian =# select 'I- 580 Ramp' < 'I- 580/I-680 Ramp' collate "C";
> ?column?
> ----------
> t
> (1 row)
I suggest the attached.
| Attachment | Content-Type | Size |
|---|---|---|
| 0001-Fix-test-select_views-collation.patch | application/octet-stream | 217.3 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2017-05-25 14:52:40 | Re: BUG #14637: Tests fail with pl_PL.UTF-8 locale |
| Previous Message | Tom Lane | 2017-05-25 14:15:58 | Re: BUG #14637: Tests fail with pl_PL.UTF-8 locale |