BUG #18482: The first data after paging is inconsistent with the actual first data

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: 13080839167(at)163(dot)com
Subject: BUG #18482: The first data after paging is inconsistent with the actual first data
Date: 2024-05-28 03:01:33
Message-ID: 18482-a97cf1fd02550f7d@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: 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;

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2024-05-28 03:15:06 BUG #18483: Segmentation fault in tests modules
Previous Message Guillaume Lelarge 2024-05-27 16:24:17 Re: BUG #18481: BIGINT Out of Range Error When Selecting Data