>-----Message d'origine----- >De : Zbigniew Lukasiak [mailto:[EMAIL PROTECTED] >Envoyé : mercredi, 5. novembre 2008 14:58 >À : DBIx::Class user and developer list >Objet : Re: [Dbix-class] SQL::Abstract 1.x subqueries patch > >I've started testing it with the latest DBIC. > >Here is a test I propose: > >Index: t/02where.t >=================================================================== >--- t/02where.t (wersja 5054) >+++ t/02where.t (kopia robocza) >@@ -175,6 +175,18 @@ > stmt => " WHERE ( (bar > ? AND bar < ?) AND foo IN (?, ?) )", > bind => [44, 55, 22, 33], > }, >+ { >+ where => { >+ '-and' => [ >+ {}, >+ { >+ 'me.id' => '1' >+ } >+ ] >+ }, >+ stmt => " WHERE ( ( me.id = ? ) )", >+ bind => [ 1 ], >+ }, > > ); > >Currently this is translated into "WHERE ( 0 AND ( me.id = ? ) )" and >that causes t/relationship_doesnt_exist.t in DBIC fail. I've tested >that the 1.24 does ignore that spurious clause (it is added in the >'single' method in ResultSet). >
Hi, Thanks for the bug report; fixed in revision 5055 (with your test added). Cheers, Laurent Dami _______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk