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 →
  1. Adjust cross-version upgrade tests for seg_out() fix

  2. Rationalize error comments in partition split/merge tests

  3. Add fast path for foreign key constraint checks

  4. Fix assorted pretty-trivial memory leaks in the backend.

  5. Add temporal FOREIGN KEY contraints

  6. Add trailing commas to enum definitions

  7. Remove obsolete executor cleanup code