From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: 13080839167@163.com
Subject: BUG #18482: The first data after paging is inconsistent with the actual first data
Date: Tue, 28 May 2024 03:01:33 +0000
Message-ID: <18482-a97cf1fd02550f7d@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 18482
Logged by: yincai.jiang
Email address: 13080839167@163.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;
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, 13080839167@163.com
Subject: Re: BUG #18482: The first data after paging is inconsistent with the actual first data
In-Reply-To: <18482-a97cf1fd02550f7d@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox