From: | Stephen van Egmond <svanegmond(at)bang(dot)dhs(dot)org> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Bug report: selects rope in tables they shouldn't |
Date: | 2000-06-26 16:21:46 |
Message-ID: | 20000626122146.A25752@bang.dhs.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Sorry for the unformatted bug report, I can't find the bug form on
postgresql.org.
Version: 7.0
Platform: Debian Linux (woody) running kernel 2.2.14
Question:
Is it valid syntax to refer to a table when it's not in the FROM of the
select? It's producing awfully wierd output:
CREATE TABLE A (
x integer
);
CREATE TABLE B(
x integer
);
insert into A values (1);
insert into B values (2);
select * from A where B.x=2;
x
---
1
(1 row)
svan=# explain select * from A where B.x=2;
NOTICE: QUERY PLAN:
Nested Loop (cost=0.00..322.50 rows=10000 width=8)
-> Seq Scan on b (cost=0.00..22.50 rows=10 width=4)
-> Seq Scan on a (cost=0.00..20.00 rows=1000 width=4)
EXPLAIN
--
,,,
(. .)
+--ooO-(_)-Ooo------------ --- -- - - - -
| Stephen van Egmond http://bang.dhs.org/
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Pascoe | 2000-06-27 13:22:59 | Queries with multiple USINGs crash backend |
Previous Message | Oliver Elphick | 2000-06-25 22:26:16 | TRUNCATE violates Referential Integrity |