From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Cc: | 1726002692(at)qq(dot)com |
Subject: | BUG #15919: When sorting, does the result show that S > s is correct? |
Date: | 2019-07-19 11:48:04 |
Message-ID: | 15919-187cdb0f64d34ab9@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 15919
Logged by: 强 魏
Email address: 1726002692(at)qq(dot)com
PostgreSQL version: 11.4
Operating system: CentOS Linux release 7.6.1810 (Core)
Description:
postgres(at)[local]:5433[postgres]#select * from t order by info desc;
+------+
| info |
+------+
| S |
| s |
+------+
(2 rows)
Time: 0.718 ms
postgres(at)[local]:5433[postgres]#select * from t order by info asc;
+------+
| info |
+------+
| s |
| S |
+------+
(2 rows)
Time: 0.789 ms
postgres(at)[local]:5433[postgres]#select ascii('s') AS "s",ascii('S') AS
"S";
+-----+----+
| s | S |
+-----+----+
| 115 | 83 |
+-----+----+
(1 row)
Time: 0.381 ms
postgres(at)[local]:5433[postgres]#show lc_collate
postgres-# ;
+-------------+
| lc_collate |
+-------------+
| en_US.UTF-8 |
+-------------+
(1 row)
Time: 0.407 ms
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2019-07-19 14:16:13 | Re: BUG #15919: When sorting, does the result show that S > s is correct? |
Previous Message | Thomas Kellerer | 2019-07-19 10:06:50 | Re: BUG #15893: pg_dump is not working like as postgres version 10 |