Re: bug with current sources? Re: cost of parse/plan/execute for one sample query

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Barry Lind <barry(at)xythos(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: bug with current sources? Re: cost of parse/plan/execute for one sample query
Date: 2002-04-14 17:11:16
Message-ID: 22244.1018804276@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Barry Lind <barry(at)xythos(dot)com> writes:
> In testing Neil's PREPARE/EXECUTE patch on my test query, I found the
> parser complains that this query is not valid when using current
> sources. The error I get is:

> psql:testorig.sql:1: ERROR: JOIN/ON clause refers to "xf2", which is
> not part of JOIN

Hmm. I have an open bug with sub-SELECTs inside a JOIN, but this
example doesn't look like it would trigger that.

> I think the sql is valid (at least it has worked in 7.1 and 7.2). Is
> this a bug?

Dunno. Give me a test case (and no, I am *not* going to try to
reverse-engineer table schemas from that SELECT).

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-04-14 17:15:30 Re: 7.2 crash...
Previous Message Bruce Momjian 2002-04-14 17:11:02 Re: Again, sorry, caching.