BUG #2714: Wrong Result with static number

From: "Frank Schmidt" <schmidt(at)dozent(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2714: Wrong Result with static number
Date: 2006-10-24 08:46:24
Message-ID: 200610240846.k9O8kOl7068702@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 2714
Logged by: Frank Schmidt
Email address: schmidt(at)dozent(dot)net
PostgreSQL version: 8.1.5
Operating system: Windows
Description: Wrong Result with static number
Details:

Follow skript works fine:

SELECT DISTINCT Artikelname, cast(BD1.Einzelpreis * (1 - Rabatt) as
decimal(8,2)) AS Preis, Rabatt
FROM Artikel A1, Bestelldetails BD1
WHERE A1.ArtikelNr = BD1.ArtikelNr
AND BD1.Einzelpreis * (1 - Rabatt) as decimal(8,2))>= ALL (SELECT
Einzelpreis * (1 - Rabatt) as decimal(8,2))
FROM Bestelldetails);

But when I change the Statement "BD1.Einzelpreis * (1 - Rabatt) as
decimal(8,2))>= " to a static number (like 5) no result will be generated.

SELECT DISTINCT Artikelname, cast(BD1.Einzelpreis * (1 - Rabatt) as
decimal(8,2)) AS Preis, Rabatt
FROM Artikel A1, Bestelldetails BD1
WHERE A1.ArtikelNr = BD1.ArtikelNr
AND 5 >= ALL (SELECT Einzelpreis * (1 - Rabatt) as decimal(8,2))
FROM Bestelldetails);

I can change the value to anything (real existing data), but nothing
happend.

Whats wrong?

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Thomas H. 2006-10-24 13:15:52 Re: could not rename xlog (was: BUG #2712)
Previous Message Magnus Hagander 2006-10-24 06:05:28 Re: BUG #2712: could not fsync segment: Permission