strange behvaviour in join? BUG in 7.02?

From: Radoslaw Stachowiak <radek(at)alter(dot)pl>
To: pgsql-general(at)PostgreSQL(dot)org
Subject: strange behvaviour in join? BUG in 7.02?
Date: 2000-11-10 10:43:20
Message-ID: 20001110114320.J5821@blue.alter.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have PSQL 7.02

classic join on Two tables:

select l.id from linia l,lk_strefa2linia lk
where l.id = lk.fk_linia and lk.fk_strefa=5;

gives correct linia.ids.

but
select linia.id from linia l,lk_strefa2linia lk
where l.id = lk.fk_linia and lk.fk_strefa=5;

(the only difference is second word: linia.id instead l.id)
will give totaly different results).

tables definitions:

mlotdev=> \d lk_strefa2linia
Table "lk_strefa2linia"
Attribute | Type | Modifier
-----------+---------+----------
fk_strefa | integer | not null
fk_linia | integer | not null
Index: lk_strefa2linia_ukey

mlotdev=> \d linia
Table "linia"
Attribute | Type | Modifier
-----------+-------------+---------------------------------------------
id | integer | not null default nextval('seq_linia'::text)
fk_typ | integer | not null
numer | char(10) | not null
status | char(1) | not null default '?'
stamp | timestamp | not null default now()
opis | varchar(64) | not null
skrot | varchar(16) | not null
Index: linia_pkey

Please CC answer to me. Thanx!

--
radoslaw.stachowiak.........................................http://alter.pl/

Browse pgsql-general by date

  From Date Subject
Next Message Chris Picton 2000-11-10 10:55:04 bug?
Previous Message KuroiNeko 2000-11-10 10:00:50 Re: Re: Requests for Development