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

Bug in 7.1.3 and 7.2?

From: Hans-Jürgen Schönig <hs(at)cybertec(dot)at>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug in 7.1.3 and 7.2?
Date: 2001-11-08 15:40:20
Message-ID: 3BEAA764.4D2AB9CC@cybertec.at (view raw or flat)
Thread:
Lists: pgsql-bugs
there seems to be a problem in 7.1.3 and 7.2:

test=# select * from a;
 id
----
  1
  2
  3
(3 rows)

test=# select * from b;
 id
----
  3
  4
(2 rows)

test=# select a.*, d.* from a as c, b as d where a.id=b.id;
NOTICE:  Adding missing FROM-clause entry for table "a"
NOTICE:  Adding missing FROM-clause entry for table "b"
 id | id
----+----
  3 |  3
  3 |  3
  3 |  3
  3 |  4
  3 |  4
  3 |  4
(6 rows)

Althoug c and d are aliases for a and b, the two tables are added to the

list in the from clause. Is this the desired behaviour or is it a bug?

    Hans


Responses

pgsql-bugs by date

Next:From: Stephen PillingerDate: 2001-11-08 16:04:55
Subject: PRNG not seeded => Seg.Fault
Previous:From: Vincent.GaboriauDate: 2001-11-08 14:44:16
Subject: Curious problem with the character û é

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