Almost there on column aliases - Mailing list pgsql-hackers

From Thomas Lockhart
Subject Almost there on column aliases
Date
Msg-id 38A3A7DB.6A684EF@alumni.caltech.edu
Whole thread Raw
Responses Re: [HACKERS] Almost there on column aliases  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
I've got most of the regression tests running, but one of the rules
tests has uncovered a problem in my code, at least for a query
involving a merge join.

Could someone run a "-d 99" query using the following from the
regression test (rules.sql):

select rtest_t2.a, rtest_t3.bfrom rtest_t2, rtest_t3where rtest_t2.a = rtest_t3.a;

and send me the query, the rewritten query, and the plan emitted by
the backend (it should be a MERGEJOIN plan)? It might speed up my
rummaging around for the reason for the failure :(

Another possibility is that I submit/commit my patches (there are
quite a few files touched and I *really* want to get them off of my
system and into the tree soon) but I was a bit hesitant to commit
something with a known problem of this nature.

TIA
                      - Thomas

-- 
Thomas Lockhart                lockhart@alumni.caltech.edu
South Pasadena, California


pgsql-hackers by date:

Previous
From: Philip Warner
Date:
Subject: Re: [HACKERS] Solution for LIMIT cost estimation
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] libpq