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

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #18781: pg group gy The number of returned data bars in a field is inconsistent
Дата
Msg-id 18781-958d4c108372a2a4@postgresql.org
обсуждение исходный текст
Список 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 по дате отправления: