| 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 |
| 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 |