On Mon, 22 Sep 2003, Sean Chittenden wrote:
> > > Here's a fun one.
> > >
> > > test=# CREATE TABLE table_s1 (i int);
> > > test=# CREATE TABLE table_s2 (j int);
> > > test=# EXPLAIN ANALYZE SELECT table_s1.i, table_s2.j FROM table_s1 AS s1,
> > > table_s2 AS s2 WHERE s1.i = s2.j;
> > > NOTICE:
> > Here's a fun one.
> >
> > test=# CREATE TABLE table_s1 (i int);
> > test=# CREATE TABLE table_s2 (j int);
> > test=# EXPLAIN ANALYZE SELECT table_s1.i, table_s2.j FROM table_s1 AS s1, table_s2
> > AS s2 WHERE s1.i = s2.j;
> > NOTICE: adding missing FROM-clause entry for table "table_s1"
> > N
> NOTICE: adding missing FROM-clause entry for table "table_s1"
> NOTICE: adding missing FROM-clause entry for table "table_s2"
> and execution times explode, naturally. I don't know if the spec says
> this is the correct behavior or not, but I have a feeling its not and
> this is a bug.
This
On Mon, 22 Sep 2003, Sean Chittenden wrote:
> Here's a fun one.
>
> test=# CREATE TABLE table_s1 (i int);
> test=# CREATE TABLE table_s2 (j int);
> test=# EXPLAIN ANALYZE SELECT table_s1.i, table_s2.j FROM table_s1 AS s1, table_s2
> AS s2 WHERE s1.i = s2.j;
> NOTICE: adding missing FROM-clause e
