Re: Row pattern recognition

From: Erik Rijkers <er(at)xs4all(dot)nl>
To: Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>, vik(at)postgresfriends(dot)org
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Row pattern recognition
Date: 2023-09-22 08:26:49
Message-ID: b7ae9117-3b94-05f4-4813-05ee9ea5cce2@xs4all.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Op 9/22/23 om 10:23 schreef Erik Rijkers:
> 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
> (Champion's address bounced; removed)
>

Sorry, I forgot to re-attach the regression.diffs with resend...

Erik

> 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2023-09-22 08:39:49 Re: [PoC] pg_upgrade: allow to upgrade publisher node
Previous Message Benoit Lobréau 2023-09-22 08:25:20 Re: Questions about the new subscription parameter: password_required