> Hi, > I was able to reproduce exactly the problem, with clean compile > and --enable-cassert: > test=# SELECT x,y,lead(y) IGNORE NULLS OVER (ORDER BY x) FROM > (VALUES(1,NULL),(2,2),(3,NULL)) AS v(x,y); > x | y | lead > ---+---+------ > 1 | | 2 > 2 | 2 | 2 > 3 | | 2 > (3 rows) > > test=# > Also, make check errors out at window test (without --enable-cassert it was > passed in previous compile):
Yeah, same here. Another possible problem is, probably the code does not work well if there are multiple partitions. Since win_nonnulls stores currentpos in a partition, when the partition ends, win_nonnulls needs to be reset. Otherwise, it mistakenly represents currentpos in the previous partition. Best reagards, -- Tatsuo Ishii SRA OSS K.K. English: http://www.sraoss.co.jp/index_en/ Japanese:http://www.sraoss.co.jp
