BUG #18781: pg group gy The number of returned data bars in a field is inconsistent

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: zengxianshu0910(at)163(dot)com
Subject: BUG #18781: pg group gy The number of returned data bars in a field is inconsistent
Date: 2025-01-20 12:52:38
Message-ID: 18781-958d4c108372a2a4@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: 18781
Logged by: pg group gy The number of returned data bars in a field is inconsistent
Email address: zengxianshu0910(at)163(dot)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表是没有被修改过,麻烦有时间
帮忙看下,谢谢。

Browse pgsql-bugs by date

  From Date Subject
Next Message David G. Johnston 2025-01-20 15:18:08 Re: BUG #18780: Bindings types are lost for complex queries
Previous Message PG Bug reporting form 2025-01-19 22:25:42 BUG #18780: Bindings types are lost for complex queries