Le dimanche 26 juillet 2009 à 05:09:09, User T-ishii a écrit :
> Log Message:
> -----------
> fix: Join statment in parallel query
>
> sample)
> Accouts table is defined by dist_def,
> the below query is executed as loadbalance.
>
> SELECT a.aid
> FROM
> accounts as a
> JOIN
> accounts as b
> ON a.aid=b.aid
> WHERE a.aid =1 or a.aid=2;
>
> Modified Files:
> --------------
> pgpool-II:
> pool_rewrite_outfuncs.c (r1.16 -> r1.17)
>
> (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgpool/pgpool-II/pool_rewrite_
>outfuncs.c?r1=1.16&r2=1.17)
I can't compile the project anymore due to this commit. The comments in the
#if need to be closed. Here is a patch to fix this.
Regards.
--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com
Index: pool_rewrite_outfuncs.c
===================================================================
RCS file: /cvsroot/pgpool/pgpool-II/pool_rewrite_outfuncs.c,v
retrieving revision 1.17
diff -c -p -r1.17 pool_rewrite_outfuncs.c
*** pool_rewrite_outfuncs.c 26 Jul 2009 03:09:09 -0000 1.17
--- pool_rewrite_outfuncs.c 26 Jul 2009 05:22:45 -0000
*************** static void _rewriteList(Node *BaseSelec
*** 624,630 ****
if(lfirst(lc))
{
#if 0
! /* 2009/07/27
if(IsA(lfirst(lc),JoinExpr) || IsA(lfirst(lc),RangeVar) || IsA(lfirst(lc),RangeSubselect))
build_virtual_table(message,lfirst(lc),next);
#endif
--- 624,630 ----
if(lfirst(lc))
{
#if 0
! /* 2009/07/27 */
if(IsA(lfirst(lc),JoinExpr) || IsA(lfirst(lc),RangeVar) || IsA(lfirst(lc),RangeSubselect))
build_virtual_table(message,lfirst(lc),next);
#endif
_______________________________________________
Pgpool-hackers mailing list
[email protected]
http://pgfoundry.org/mailman/listinfo/pgpool-hackers
