BUG #15919: When sorting, does the result show that S > s is correct?

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #15919: When sorting, does the result show that S > s is correct?
Дата
Msg-id 15919-187cdb0f64d34ab9@postgresql.org
обсуждение исходный текст
Ответы Re: BUG #15919: When sorting, does the result show that S > s is correct?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      15919
Logged by:          强 魏
Email address:      1726002692@qq.com
PostgreSQL version: 11.4
Operating system:   CentOS Linux release 7.6.1810 (Core)
Description:

postgres@[local]:5433[postgres]#select * from t order by info desc;
+------+
| info |
+------+
| S    |
| s    |
+------+
(2 rows)

Time: 0.718 ms
postgres@[local]:5433[postgres]#select * from t order by info asc;
+------+
| info |
+------+
| s    |
| S    |
+------+
(2 rows)

Time: 0.789 ms
postgres@[local]:5433[postgres]#select ascii('s') AS "s",ascii('S') AS
"S";
+-----+----+
|  s  | S  |
+-----+----+
| 115 | 83 |
+-----+----+
(1 row)

Time: 0.381 ms
postgres@[local]:5433[postgres]#show lc_collate 
postgres-# ;
+-------------+
| lc_collate  |
+-------------+
| en_US.UTF-8 |
+-------------+
(1 row)

Time: 0.407 ms


В списке pgsql-bugs по дате отправления:

Предыдущее
От: Thomas Kellerer
Дата:
Сообщение: Re: BUG #15893: pg_dump is not working like as postgres version 10
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #15919: When sorting, does the result show that S > s is correct?