Skip site navigation (1) Skip section navigation (2)

Re: [BUGS] Bug in 6.4.2. Aggregate/View/Where-condition

From: Chris Cogdon <chris(at)felidae(dot)apana(dot)org(dot)au>
To: pgsql-bugs(at)postgreSQL(dot)org
Subject: Re: [BUGS] Bug in 6.4.2. Aggregate/View/Where-condition
Date: 2000-02-28 13:22:28
Message-ID: Pine.LNX.4.10.10002290018300.12235-100000@uncia.felidae.apana.org.au (view raw or flat)
Thread:
Lists: pgsql-bugs
On Mon, 28 Feb 2000, Chris Cogdon wrote:

> 
> 
> Hope you wonderful folks can help me with this problem. Even stating 'it
> works fine under version such-and-such' would be a great help (save me
> downloading and compliling n different versions :)

Update:

1. It does a similar thing under 6.5.2 (redhat-6.1 this time, the previous
was redhat-6.0), except the error message is different:

ERROR:  ExecEvalExpr: unknown expression type 108


2. Notice how this example under 6.4.2 returns one, empty row?

> test1=> select * from span where 0<min;          
> ref|min|max
> ---+---+---
>    |   |   
> (1 row)

Under 6.5.2, it returns, correctly:

test1=> select * from span where 0<min;
ref|min|max
---+---+---
  1|  1|  4
(1 row)

but, under 6.5.2 a query that shouldnt return /any/ rows, still returns
one empty row:

test1=> select * from span where 50<min;
ref|min|max
---+---+---
   |   |   
(1 row)


bugsbugsbugsbugsbugsbugsbugs :)



   ("`-/")_.-'"``-._        Ch'marr, a.k.a.
    . . `; -._    )-;-,_`)  Chris Cogdon <chris(at)felidae(dot)apana(dot)org(dot)au>
   (v_,)'  _  )`-.\  ``-'
  _.- _..-_/ / ((.'       FC1.3: FFH3cmA+>++C++D++H++M++P++R++T+++WZ++Sm++
((,.-'   ((,/   fL               RLCT acl+++d++e+f+++h++i++++jp-sm++


In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2000-02-28 15:06:28
Subject: Re: [BUGS] Bug in 6.4.2. Aggregate/View/Where-condition
Previous:From: Chris CogdonDate: 2000-02-28 12:51:46
Subject: Bug in 6.4.2. Aggregate/View/Where-condition

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group