[Dbix-class] DBIx JOIN issue in New version

Dagfinn Ilmari Mannsåker ilmari at ilmari.org
Tue Feb 11 11:48:15 GMT 2014


Sheeju Alex <sheejuec7 at gmail.com> writes:

> After upgrading to new DBIX version my JOIN statement is failing, here is
> the query in new and old version

Could you please show us the relationship definition and the ->search()
call(s) you are using that lead to these queries?

> ** WORKING in this version
>
> DBIx Version: 0.08195
>
> SELECT * FROM "AlertContact" "me"  JOIN "AlertProfile" "Profile" ON
> "Profile"."Id" = "me"."ProfileId" WHERE ( ( "Profile"."Refe
> renceId" = ? AND "me"."Name" = ? ) ): '1', 'Email'
>
>
> ** NOT WORKING in this version
>
> DBIx Version: 0.08250

This is not the most recent version, 0.08270 is out now. Could you try
that as well?

> SELECT * FROM "AlertContact" "me"  JOIN "AlertProfile" "Profile" ON
> "Profile"."Id" *IDENT* ? WHERE ( ( "Profile"."ReferenceId" = ? AND
> "me"."Name" = ? ) )" with ParamValues: 1='me.ProfileId', 2='1', 3='Email']
>
> I see extra keyword IDENT in JOIN statement, Can you please let me know
> how to fix it?
>
> Thanks,
> Sheeju

-- 
"I use RMS as a guide in the same way that a boat captain would use
 a lighthouse.  It's good to know where it is, but you generally
 don't want to find yourself in the same spot." - Tollef Fog Heen




More information about the DBIx-Class mailing list