<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:windowtext;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-NZ" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">Hi Sheeju,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">I believe you need to update the SQL::Abstract module as well.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">Kind regards,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">Paul Findlay<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> Sheeju Alex [mailto:sheejuec7@gmail.com]
<br>
<b>Sent:</b> Wednesday, 12 February 2014 12:27 a.m.<br>
<b>To:</b> dbix-class@lists.scsys.co.uk<br>
<b>Subject:</b> [Dbix-class] DBIx JOIN issue in New version<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal">After upgrading to new DBIX version my JOIN statement is failing, here is the query in new and old version
<br>
<br>
** WORKING in this version<br>
<br>
DBIx Version: 0.08195 <br>
<br>
SELECT * FROM "AlertContact" "me" JOIN "AlertProfile" "Profile" ON "Profile"."Id" = "me"."ProfileId" WHERE ( ( "Profile"."Refe<br>
renceId" = ? AND "me"."Name" = ? ) ): '1', 'Email' <o:p></o:p></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt">** NOT WORKING in this version<br>
<br>
DBIx Version: 0.08250<br>
<br>
SELECT * FROM "AlertContact" "me" JOIN "AlertProfile" "Profile" ON "Profile"."Id"
<b>IDENT</b> ? WHERE ( ( "Profile"."ReferenceId" = ? AND "me"."Name" = ? ) )" with ParamValues: 1='me.ProfileId', 2='1', 3='Email']<o:p></o:p></p>
</div>
<p class="MsoNormal">I see extra keyword IDENT in JOIN statement, Can you please let me know
<o:p></o:p></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt">how to fix it?<o:p></o:p></p>
</div>
<p class="MsoNormal">Thanks,<br>
Sheeju<o:p></o:p></p>
</div>
</div>
<br>
<hr>
<font face="Arial" color="Blue" size="1">DISCLAIMER<br>
This email contains information that is confidential and which may be legally privileged. If you have received this email in error, please notify the sender immediately and delete the email. This email is intended solely for the use of the intended recipient
and you may not use or disclose this email in any way.<br>
</font>
</body>
</html>