From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: zengxianshu0910@163.com
Subject: BUG #18781: pg group gy The number of returned data bars in a field is inconsistent
Date: Mon, 20 Jan 2025 12:52:38 +0000
Message-ID: <18781-958d4c108372a2a4@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 18781
Logged by: pg group gy The number of returned data bars in a field is inconsistent
Email address: zengxianshu0910@163.com
PostgreSQL version: 13.6
Operating system: windows
Description:
我本地有一个表book，数据是4660708条，本地执行
with tmp1 as (
SELECT book_name
FROM book
GROUP BY book_name)
select count(*) from tmp1 ;
每次返回的结果数据每次都不一样，相差大概1到几百，数据库是从服务器dompall下来的，我本地和另一台测试服务器一样的数据库，执行的效果是一样的，都是每次结果不一样，服务器上也是每次执行的结果不一样，可以肯定的是book表是没有被修改过，麻烦有时间
帮忙看下，谢谢。
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, zengxianshu0910@163.com
Subject: Re: BUG #18781: pg group gy The number of returned data bars in a field is inconsistent
In-Reply-To: <18781-958d4c108372a2a4@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