<div dir="ltr"><div><div><div>I have upgraded to SQL::Abstract 1.77 version but still I see this issue<br><br></div><div>I have upgraded to DBIx::Class 0.08270 version but still I see this issue<br></div><div><br></div>Here is the relationship between AlertContact table and AlertProfile<br>

<br>__PACKAGE__-&gt;belongs_to(<br>    Profile =&gt; &#39;PAMS::WWW::Schema::Result::AlertProfile&#39;,<br>    {<br>        &#39;foreign.Id&#39; =&gt; &#39;self.ProfileId&#39;<br>    }<br>);<br><br></div>Here is the search call<br>

<br><div style="text-align:left">        my $alert_contact = $c-&gt;model(&#39;PAMSDB::AlertContact&#39;)-&gt;search(<br>            {<br>                &#39;Profile.ReferenceId&#39; =&gt; $profile-&gt;{ID},<br>                &#39;Name&#39;                =&gt; $href-&gt;{ContactMethod}<br>

            },<br>            {&#39;join&#39; =&gt; &#39;Profile&#39;}<br>        )-&gt;first;<br></div><br></div>Still this gives below Error<br><br>DBI Exception: DBD::Pg::st execute failed: ERROR:  syntax error at or near &quot;IDENT&quot;<br>

LINE 1: ...  JOIN &quot;AlertProfile&quot; &quot;Profile&quot; ON &quot;Profile&quot;.&quot;Id&quot; IDENT $1 W...<br>                                                             ^ [for Statement &quot;SELECT * FROM &quot;AlertContact&quot; &quot;me&quot;  JOIN &quot;AlertProfile&quot; &quot;Profile&quot; ON &quot;Profile&quot;.&quot;Id&quot; IDENT ? WHERE ( ( &quot;Name&quot; = ? AND &quot;Profile&quot;.&quot;ReferenceId&quot; = ? ) )&quot; with ParamValues: 1=&#39;me.ProfileId&#39;, 2=&#39;Office Email&#39;, 3=&#39;1&#39;] <br>

<div><div><div><div><div><div class="gmail_extra"><br></div><div class="gmail_extra">Please help..<br clear="all"></div><div class="gmail_extra"><div><div dir="ltr"><div><br></div>Best Regards,    <br>Sheeju Alex<br>
<div style="display:inline"></div></div></div>
<br><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
&gt; After upgrading to new DBIX version my JOIN statement is failing, here is<br>
&gt; the query in new and old version<br>
<br>
Could you please show us the relationship definition and the -&gt;search()<br>
call(s) you are using that lead to these queries?<br>
<br>
&gt; ** WORKING in this version<br>
&gt;<br>
&gt; DBIx Version: 0.08195<br>
&gt;<br>
&gt; SELECT * FROM &quot;AlertContact&quot; &quot;me&quot;  JOIN &quot;AlertProfile&quot; &quot;Profile&quot; ON<br>
&gt; &quot;Profile&quot;.&quot;Id&quot; = &quot;me&quot;.&quot;ProfileId&quot; WHERE ( ( &quot;Profile&quot;.&quot;Refe<br>
&gt; renceId&quot; = ? AND &quot;me&quot;.&quot;Name&quot; = ? ) ): &#39;1&#39;, &#39;Email&#39;<br>
&gt;<br>
&gt;<br>
&gt; ** NOT WORKING in this version<br>
&gt;<br>
&gt; DBIx Version: 0.08250<br>
<br>
This is not the most recent version, 0.08270 is out now. Could you try<br>
that as well?<br>
<br>
&gt; SELECT * FROM &quot;AlertContact&quot; &quot;me&quot;  JOIN &quot;AlertProfile&quot; &quot;Profile&quot; ON<br>
&gt; &quot;Profile&quot;.&quot;Id&quot; *IDENT* ? WHERE ( ( &quot;Profile&quot;.&quot;ReferenceId&quot; = ? AND<br>
&gt; &quot;me&quot;.&quot;Name&quot; = ? ) )&quot; with ParamValues: 1=&#39;me.ProfileId&#39;, 2=&#39;1&#39;, 3=&#39;Email&#39;]<br>
&gt;<br>
&gt; I see extra keyword IDENT in JOIN statement, Can you please let me know<br>
&gt; how to fix it?<br>
&gt;<br>
&gt; Thanks,<br>
&gt; Sheeju<br></blockquote></div></div></div></div></div></div></div></div>