Re: [Postgres-xc-developers] GROUP BY clause with JOIN clause and DISTINCT clause and combination of implicit/explicit table specification

[Michael P. <mic...@gm...>]

On Thu, Nov 21, 2013 at 12:32 AM, Masataka Saito <pg...@gm...> wrote:
> XC can't build a plan.
>
> db=# explain verbose SELECT DISTINCT t2.b FROM t1 JOIN t2 ON t1.id =
> t2.id GROUP BY b;
> ERROR:  ORDER/GROUP BY expression not found in targetlist
This is a higher-level bug, planner bug just by looking at this code
path src/backend/optimizer/util/tlist.c...

Note: Setting up VERBOSITY to verbose in .psqlrc helps grabbing more
details about the errors that occurred in server like the file name +
name of this elog/ereport ERROR:
\set VERBOSITY verbose
For dev purposes it is a pretty useful default ;)

Regards,
-- 
Michael