Re: Pg, Netezza, and... Sybase?

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: yary <not(dot)com(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Pg, Netezza, and... Sybase?
Date: 2012-10-01 20:18:18
Message-ID: 20121001201818.GD7922@momjian.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Oct 1, 2012 at 03:49:14PM -0400, yary wrote:
> 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?

There is no code connection between Sybase and Postgres.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2012-10-01 20:37:11 Re: Pg, Netezza, and... Sybase?
Previous Message Shaun Thomas 2012-10-01 20:10:43 Re: Securing .pgpass File?