strange behvaviour in join? BUG in 7.02?
От | Radoslaw Stachowiak |
---|---|
Тема | strange behvaviour in join? BUG in 7.02? |
Дата | |
Msg-id | 20001110114320.J5821@blue.alter.pl обсуждение исходный текст |
Ответы |
Re: strange behvaviour in join? BUG in 7.02?
|
Список | 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/
В списке pgsql-general по дате отправления: