Re: Row pattern recognition
Tatsuo Ishii <ishii@postgresql.org>
From: Tatsuo Ishii <ishii@postgresql.org>
To: assam258@gmail.com
Cc: jacob.champion@enterprisedb.com, david.g.johnston@gmail.com,
vik@postgresfriends.org, er@xs4all.nl, peter@eisentraut.org,
pgsql-hackers@postgresql.org
Date: 2026-01-18T07:52:43Z
Lists: pgsql-hackers
Hi Henson,
> Attached is the patch with the following changes:
[snip]
After applying your patch on top of v39 patch sets, I see compiler
warnings:
nodeWindowAgg.c: In function ‘nfa_absorb_contexts’:
nodeWindowAgg.c:5565:47: warning: the comparison will always evaluate as ‘true’ for the address of ‘counts’ will never be NULL [-Waddress]
5565 | if (s->counts != NULL && s->counts[0] > newerMaxCount)
| ^~
In file included from ../../../src/include/executor/execdesc.h:18,
from ../../../src/include/executor/executor.h:18,
from nodeWindowAgg.c:41:
../../../src/include/nodes/execnodes.h:2532:25: note: ‘counts’ declared here
2532 | int32 counts[FLEXIBLE_ARRAY_MEMBER]; /* repetition counts by depth */
| ^~~~~~
nodeWindowAgg.c:5572:47: warning: the comparison will always evaluate as ‘true’ for the address of ‘counts’ will never be NULL [-Waddress]
5572 | if (s->counts != NULL && s->counts[0] > olderMaxCount)
| ^~
../../../src/include/nodes/execnodes.h:2532:25: note: ‘counts’ declared here
2532 | int32 counts[FLEXIBLE_ARRAY_MEMBER]; /* repetition counts by depth */
| ^~~~~~
nodeWindowAgg.c:5429:33: warning: variable ‘maxDepth’ set but not used [-Wunused-but-set-variable]
5429 | int maxDepth;
| ^~~~~~~~
Shall I fix them (and post v40 patches), or would you like to fix and
post another patch?
Best regards,
--
Tatsuo Ishii
SRA OSS K.K.
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp
Commits
Same data as JSON:
GET /api/v1/messages/:b64id/commits
the thread's linked commits as JSON, with link sources.
API reference →
-
Adjust cross-version upgrade tests for seg_out() fix
- 3e3d7875e956 19 (unreleased) cited
-
Rationalize error comments in partition split/merge tests
- ecb2508aaf9b 19 (unreleased) cited
-
Add fast path for foreign key constraint checks
- 2da86c1ef9b5 19 (unreleased) cited
-
Fix assorted pretty-trivial memory leaks in the backend.
- e78d1d6d47dc 19 (unreleased) cited
-
Add temporal FOREIGN KEY contraints
- 89f908a6d0ac 18.0 cited
-
Add trailing commas to enum definitions
- 611806cd726f 17.0 cited
-
Remove obsolete executor cleanup code
- d060e921ea5a 17.0 cited