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

[Masataka S. <pg...@gm...>]

Thanks for your information.
It seems very helpful.

cx=# explain verbose SELECT DISTINCT t2.b FROM t1 JOIN t2 ON t1.id =
t2.id GROUP BY b;
ERROR:  XX000: ORDER/GROUP BY expression not found in targetlist
LOCATION:  get_sortgroupref_tle, tlist.c:251

On Thu, Nov 21, 2013 at 9:53 AM, 鈴木 幸市 <ko...@in...> wrote:
> Yes, you can do it with SET command as well just for a target statement.
>
> Regards;
> ---
> Koichi Suzuki
>
> 2013/11/21 7:46、Michael Paquier <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
>>
>> ------------------------------------------------------------------------------
>> Shape the Mobile Experience: Free Subscription
>> Software experts and developers: Be at the forefront of tech innovation.
>> Intel(R) Software Adrenaline delivers strategic insight and game-changing
>> conversations that shape the rapidly evolving mobile landscape. Sign up now.
>> http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk
>> _______________________________________________
>> Postgres-xc-developers mailing list
>> Pos...@li...
>> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers
>>
>