Re: Row pattern recognition - Mailing list pgsql-hackers

From Erik Rijkers
Subject Re: Row pattern recognition
Date
Msg-id 3632f9e6-4c40-1d7c-df99-97cd5024a9bd@xs4all.nl
Whole thread Raw
In response to Re: Row pattern recognition  (Tatsuo Ishii <ishii@sraoss.co.jp>)
List pgsql-hackers
Op 9/22/23 om 12:12 schreef Tatsuo Ishii:
>> 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)
> 
> On my side his adress bounced too:-<
> 
>> 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.
> 
> Strange. I have checked out fresh master branch and applied the v7
> patches, then ran make check. All tests including the rpr test
> passed. This is Ubuntu 20.04.

The curious thing is that the server otherwise builds ok, and if I 
explicitly run on that server 'CREATE TEMP TABLE stock' + the 20 INSERTS 
  (just to make sure to have known data), those two statements now both 
return the correct result.

So maybe the testing/timing is wonky (not necessarily the server).

Erik

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



pgsql-hackers by date:

Previous
From: Dilip Kumar
Date:
Subject: Re: logical decoding and replication of sequences, take 2
Next
From: shveta malik
Date:
Subject: Re: Synchronizing slots from primary to standby