Docker image of 11~beta2-2 orders strings case-insensitively

From: Yahor Yuzefovich <yahor(at)cockroachlabs(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Docker image of 11~beta2-2 orders strings case-insensitively
Date: 2018-08-06 14:56:59
Message-ID: CABz5gWFR8bPrWeh73AcLYFn6nTojHEKWWDdXX=T91CU8RKn7=g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

Best,
Yahor Yuzefovich

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2018-08-06 15:56:07 Re: Docker image of 11~beta2-2 orders strings case-insensitively
Previous Message Tom Lane 2018-08-04 22:37:09 Re: Fwd: Problem with a "complex" upsert