Re: Row pattern recognition

From: Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>
To: champion(dot)p(at)gmail(dot)com, er(at)xs4all(dot)nl, vik(at)postgresfriends(dot)org
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Row pattern recognition
Date: 2023-12-04 11:40:48
Message-ID: 20231204.204048.1998548830490453126.t-ishii@sranhm.sra.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Attached is the v12 patch. Below are the summary of the changes from
previous version.

- Rebase. CFbot says v11 patch needs rebase since Nov 30, 2023.

- Apply preprocess_expression() to DEFINE clause in the planning
phase. This is necessary to simply const expressions like:

DEFINE A price < (99 + 1)
to:
DEFINE A price < 100

- Re-allow to use WinSetMarkPosition() in eval_windowaggregates().

- FYI here is the list to explain what were changed in each patch file.

0001-Row-pattern-recognition-patch-for-raw-parser.patch
- Fix conflict.

0002-Row-pattern-recognition-patch-parse-analysis.patch
- Same as before.

0003-Row-pattern-recognition-patch-planner.patch
- Call preprocess_expression() for DEFINE clause in subquery_planner().

0004-Row-pattern-recognition-patch-executor.patch
- Re-allow to use WinSetMarkPosition() in eval_windowaggregates().

0005-Row-pattern-recognition-patch-docs.patch
- Same as before.

0006-Row-pattern-recognition-patch-tests.patch
- Same as before.

0007-Allow-to-print-raw-parse-tree.patch
- Same as before.

Best reagards,
--
Tatsuo Ishii
SRA OSS LLC
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp

Attachment Content-Type Size
v12-0001-Row-pattern-recognition-patch-for-raw-parser.patch text/x-patch 21.1 KB
v12-0002-Row-pattern-recognition-patch-parse-analysis.patch text/x-patch 11.2 KB
v12-0003-Row-pattern-recognition-patch-planner.patch text/x-patch 6.6 KB
v12-0004-Row-pattern-recognition-patch-executor.patch text/x-patch 51.1 KB
v12-0005-Row-pattern-recognition-patch-docs.patch text/x-patch 9.6 KB
v12-0006-Row-pattern-recognition-patch-tests.patch text/x-patch 46.2 KB
v12-0007-Allow-to-print-raw-parse-tree.patch text/x-patch 749 bytes

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tomas Vondra 2023-12-04 12:00:27 Re: undetected deadlock in ALTER SUBSCRIPTION ... REFRESH PUBLICATION
Previous Message Amit Kapila 2023-12-04 11:37:47 Re: undetected deadlock in ALTER SUBSCRIPTION ... REFRESH PUBLICATION