Pg, Netezza, and... Sybase?

From: yary <not(dot)com(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Pg, Netezza, and... Sybase?
Date: 2012-10-01 19:49:14
Message-ID: CAG2CFAZ5_iViLRgZGyyojuGhjOb=H70ZyqY_9+s0w4aAbNRJdA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is there a link between Sybase and Postgres?

I ask because I came across a bug in Netezza, and Netezza has a
well-known Postgres lineage, but when web-searching the bug, the first
thing I found was a Sybase reference-

http://geekswithblogs.net/marocanu2001/archive/2011/08/11/nasty-bug-in-sybase-iq-analytical-function-last_value-over-partition.aspx

and indeed that is the exact bug I found in Netezza! "first_value"
works great, "last_value" has window size 1 unless you also say "rows
between unbounded preceding and unbounded following".

Two unrelated commercial products with the same bug makes me wonder...
does/did Postgres also have this issue, with both NZ and Sybase
importing the same buggy code?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Hugo <Nabble> 2012-10-01 19:52:31 Thousands of schemas and ANALYZE goes out of memory
Previous Message Jeff Janes 2012-10-01 19:05:43 Re: Securing .pgpass File?