Re: Docker image of 11~beta2-2 orders strings case-insensitively - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: Docker image of 11~beta2-2 orders strings case-insensitively
Date
Msg-id CAKFQuwbZUPnNDWys=VsOWUGO9uTg-LfWztzRj3H1NG6ttOMW-g@mail.gmail.com
Whole thread Raw
In response to Docker image of 11~beta2-2 orders strings case-insensitively  (Yahor Yuzefovich <yahor@cockroachlabs.com>)
Responses Re: Docker image of 11~beta2-2 orders strings case-insensitively  (Yahor Yuzefovich <yahor@cockroachlabs.com>)
List pgsql-bugs
On Monday, August 6, 2018, Yahor Yuzefovich <yahor@cockroachlabs.com> wrote:
Hello,

I used these commands to run Beta PG 11:
docker pull postgres:11
docker run --name POSTGRES11 -e POSTGRES_PASSWORD=postgres -d postgres:11
docker run -it --rm --link POSTGRES11:postgres postgres psql -h postgres -U postgres

I've created a table as follows:
CREATE TABLE t (id serial PRIMARY KEY, name VARCHAR (255) NOT NULL);
INSERT INTO t (name) VALUES ('M'), ('i'), ('A');

and ran this query:
SELECT name FROM t ORDER BY name;

I expected to see:
A
M
i

but found:
A
i
M

This is an environmental aspect (locale) of the docker image; not a bug.  I suggest posting on -general, with details about your locale settings, if you would like some guidance in that area.

David J.

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Docker image of 11~beta2-2 orders strings case-insensitively
Next
From: Tom Lane
Date:
Subject: Re: Fwd: Problem with a "complex" upsert