[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