Re: Have the planner convert COUNT(1) / COUNT(not_null_col) to COUNT(*) - Mailing list pgsql-hackers

From David Rowley
Subject Re: Have the planner convert COUNT(1) / COUNT(not_null_col) to COUNT(*)
Date
Msg-id CAApHDvrWqiq2VVz7-JgNyApQ3y5xr_boBbMgJarAb8db8=mZkA@mail.gmail.com
Whole thread Raw
In response to Re: Have the planner convert COUNT(1) / COUNT(not_null_col) to COUNT(*)  ("Matheus Alcantara" <matheusssilv97@gmail.com>)
Responses Re: Have the planner convert COUNT(1) / COUNT(not_null_col) to COUNT(*)
List pgsql-hackers
On Tue, 4 Nov 2025 at 09:38, Matheus Alcantara <matheusssilv97@gmail.com> wrote:
> I looked the code and it seems to be in a good shape, but I tried to
> apply the v2 on top of e7ccb247b38 in master to run some tests and a
> rebase is necessary.

Are you sure you've not got something else in your branch? It applies
ok here, and the CFbot isn't complaining either. CFBot's is based on
cf8be0225, which is 2 commits before the one you're trying, but
src/test/regress/expected/aggregates.out hasn't been changed since
2025-10-07.

David



pgsql-hackers by date:

Previous
From: Bryan Green
Date:
Subject: Re: [PATCH] Fix orphaned backend processes on Windows using Job Objects
Next
From: David Rowley
Date:
Subject: Re: Have the planner convert COUNT(1) / COUNT(not_null_col) to COUNT(*)