BUG #18781: pg group gy The number of returned data bars in a field is inconsistent - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #18781: pg group gy The number of returned data bars in a field is inconsistent
Date
Msg-id 18781-958d4c108372a2a4@postgresql.org
Whole thread Raw
List 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@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表是没有被修改过,麻烦有时间
帮忙看下,谢谢。


pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #18780: Bindings types are lost for complex queries
Next
From: "David G. Johnston"
Date:
Subject: Re: BUG #18780: Bindings types are lost for complex queries