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

[Ashutosh B. <ash...@en...>]

Can you please provide output of EXPLAIN verbose?


On Thu, Nov 14, 2013 at 1:44 PM, Masataka Saito <pg...@gm...> wrote:

> Hello, all.
>
> I'm testing complex SQLs on Postgres-XC 1.1.
> And I found bad SQL that XC doesn't accept.
>
> The SQL is  from answer 2 of chapter 17 in SQL puzzle book by Joe Celko.
> I simplified it for everyone's reproduction.
>
> db=# CREATE TABLE t1(id INT, a INT);
> CREATE TABLE
> db=# CREATE TABLE t2(id INT, b INT);
> CREATE TABLE
> db=# 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 SQL is accepted by PostgreSQL 9.2.4.
>
> Can anyone solve or explain this issue?
>
> Regards.
>
>
> ------------------------------------------------------------------------------
> DreamFactory - Open Source REST & JSON Services for HTML5 & Native Apps
> OAuth, Users, Roles, SQL, NoSQL, BLOB Storage and External API Access
> Free app hosting. Or install the open source package on any LAMP server.
> Sign up and see examples for AngularJS, jQuery, Sencha Touch and Native!
> http://pubads.g.doubleclick.net/gampad/clk?id=63469471&iu=/4140/ostg.clktrk
> _______________________________________________
> Postgres-xc-developers mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers
>



-- 
Best Wishes,
Ashutosh Bapat
EnterpriseDB Corporation
The Postgres Database Company