From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | 13080839167(at)163(dot)com, PostgreSQL Bug List <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
Subject: | Re: BUG #18482: The first data after paging is inconsistent with the actual first data |
Date: | 2024-05-28 17:21:04 |
Message-ID: | CAKFQuwaw3kD0NSz6EkbTPA3s=e6j7h=0dsDdf_-q77XrrOk4mw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Tue, May 28, 2024, 10:40 PG Bug reporting form <noreply(at)postgresql(dot)org>
wrote:
> The following bug has been logged on the website:
>
> Bug reference: 18482
> Logged by: yincai.jiang
> Email address: 13080839167(at)163(dot)com
> PostgreSQL version: 15.4
> Operating system: red hat
> Description:
>
> version:PostgreSQL 15.4 on aarch64-unknown-linux-gnu, compiled by gcc (GCC)
> 7.3.1 20180712 (Red Hat 7.3.1-6), 64-bit
>
>
> The first data obtained through the following query
> SELECT
>
> "id","customname","customcodesap","operationreason","status","rebateprogress","rebateorder","createtime","updatetime","createuserid","createusername","updateuserid","updateusername","isdelete"
> FROM "fds_custom"
> ORDER BY "rebateorder";
>
>
> It does not match the first piece of data obtained after the following
> execution.
> SELECT
>
> "id","customname","customcodesap","operationreason","status","rebateprogress","rebateorder","createtime","updatetime","createuserid","createusername","updateuserid","updateusername","isdelete"
> FROM "fds_custom"
> ORDER BY "rebateorder"
> LIMIT 10 offset 0;
>
I think you need to demonstrate the bug with actual data so people can
reproduce it. More likely rebateorder is insufficient for a deterministic
ordering of the result set.
David J.
From | Date | Subject | |
---|---|---|---|
Next Message | Haifang Wang (Centific Technologies Inc) | 2024-05-28 18:21:18 | RE: [EXTERNAL] Re: Windows Application Issues | PostgreSQL | REF # 48475607 |
Previous Message | Japin Li | 2024-05-28 14:20:16 | Re: BUG #18467: postgres_fdw (deparser) ignores LimitOption |