From: | Erik Rijkers <er(at)xs4all(dot)nl> |
---|---|
To: | Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>, jchampion(at)timescale(dot)com, vik(at)postgresfriends(dot)org |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Row pattern recognition |
Date: | 2023-09-22 08:12:38 |
Message-ID: | 71ebb753-f3ee-69cb-3490-15f710e36499@xs4all.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Op 9/22/23 om 07:16 schreef Tatsuo Ishii:
>> Attached is the fix against v6 patch. I will include this in upcoming v7 patch.
>
> Attached is the v7 patch. It includes the fix mentioned above. Also
Hi,
In my hands, make check fails on the rpr test; see attached .diff file.
In these two statements:
-- using NEXT
-- using AFTER MATCH SKIP TO NEXT ROW
result of first_value(price) and next_value(price) are empty.
Erik Rijkers
> this time the pattern matching engine is enhanced: previously it
> recursed to row direction, which means if the number of rows in a
> frame is large, it could exceed the limit of stack depth. The new
> version recurses over matched pattern variables in a row, which is at
> most 26 which should be small enough.
>
> 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 |
---|---|---|
regression.diffs | text/plain | 3.7 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Andrey Lepikhov | 2023-09-22 08:14:43 | Re: [PATCH] Add extra statistics to explain for Nested Loop |
Previous Message | Dean Rasheed | 2023-09-22 08:09:12 | Re: Infinite Interval |