PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID15651
PG Version11.0
OSLinux
Opened2019-02-22 16:34:43+00
Reported byKaleb Akalework
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      15651
Logged by:          Kaleb Akalework
Email address:      (redacted)
PostgreSQL version: 11.0
Operating system:   Linux
Description:        

I have PostgresSQL database on Windows. I created database with Collation of
en_US.utf8. Then I created table (The steps to reproduce are below). I
inserted a few rows into this table one of which was row with special
characters "~!@#$^&(". The insert worked fine but then when I do a select on
the column for values >=' ' (Space), I get back all the rows except for the
row that contains 
"~!@#$^&(" . In the UTF8 table
https://www.utf8-chartable.de/unicode-utf8-table.pl, I can see that space is
the lowest printable character so technically every printable character
showed be greater than space but it isn't in this case. I create another
database and set collation to 'C'. then the same select query returns
"~!@#$^&(". The problem is only apparent in a Linux environment where
postgreSQL  is running and the database has a collation of en_US.utf8. Can
someone help please?

create table test (
	name_c varchar(14)
)

insert into test (name_c) values ('AAA')
insert into test (name_c) values ('BAA')
insert into test (name_c) values ('CAA')
insert into test (name_c) values ('DAA')
insert into test (name_c) values ('~!@#$^&(')

select * from test where name_c >= ' '

Messages

DateAuthorSubject
2019-02-22 16:34:43+00PG Bug reporting formBUG #15651: Collation setting en_US.utf8 breaking sort order
2019-02-22 18:03:26+00Tom LaneRe: BUG #15651: Collation setting en_US.utf8 breaking sort order
2019-02-22 18:18:16+00Kaleb AkaleworkRE: BUG #15651: Collation setting en_US.utf8 breaking sort order
2019-02-22 18:40:58+00Peter GeogheganRe: BUG #15651: Collation setting en_US.utf8 breaking sort order
2019-02-22 19:17:06+00Kaleb AkaleworkRE: BUG #15651: Collation setting en_US.utf8 breaking sort order
2019-02-22 19:53:58+00Tom LaneRe: BUG #15651: Collation setting en_US.utf8 breaking sort order
2019-02-23 08:36:39+00Peter EisentrautRe: BUG #15651: Collation setting en_US.utf8 breaking sort order
2019-02-23 17:30:01+00"Daniel Verite"Re: BUG #15651: Collation setting en_US.utf8 breaking sort order
2019-02-23 17:48:55+00"Daniel Verite"RE: BUG #15651: Collation setting en_US.utf8 breaking sort order