<div dir="ltr"><div class="gmail_extra"><div class="gmail_quote">2014-03-28 12:48 GMT+01:00 Ashutosh Dhundhara <span dir="ltr"><<a href="mailto:ashutoshdhundhara@yahoo.com" target="_blank">ashutoshdhundhara@yahoo.com</a>></span>:<br>

<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div><div style="font-size:10pt;font-family:HelveticaNeue,'Helvetica Neue',Helvetica,Arial,'Lucida Grande',sans-serif">

<div><span>Hello All,</span></div><div style="background-color:transparent"><br></div><div style="background-color:transparent"><span><span style="white-space:pre-wrap">     </span>I have a table `vb_test` having one column `id`. I applied two foreign key constraints over `vb_test`.`id` as follows: </span></div>

<div style="background-color:transparent">1) <span style="white-space:pre-wrap">        </span>a<span style="background-color:transparent">lter table `vb_test`</span></div><div style="background-color:transparent"><span style="white-space:pre-wrap">     </span>add constraint fk1 foreign key(id) references parent_one(id);</div>

<div style="background-color:transparent">2) <span>       </span>a<span style="background-color:transparent">lter table `vb_test`</span></div><div style="background-color:transparent"><span style="white-space:pre-wrap">     </span>add constraint fk2 foreign key(id) references parent_two(id);</div>

<div style="background-color:transparent">Up to this, everything is fine.</div><div style="background-color:transparent"><br></div><div style="background-color:transparent">Now when I switch to "Visual Builder" in QBE, I see only one line joining `vb_test`.`id` to `parent_one`.`id` in the diagram.</div>

<div style="background-color:transparent">There is no link from <span style="font-size:10pt">`vb_test`.`id` to `parent_two`.`id`.</span></div><div style="font-size:10pt;background-color:transparent"><span style="font-size:10pt">Is this an intended behavior or a bug ?</span></div>

<div></div><div> </div><div>Regards, <span class=""><font color="#888888"><br>Ashutosh Dhundhara</font></span></div></div></div><br>------------------------------------------------------------------------------<br>
<br>_______________________________________________<br>
Phpmyadmin-devel mailing list<br>
<a href="mailto:Phpmyadmin-devel@lists.sourceforge.net">Phpmyadmin-devel@lists.sourceforge.net</a><br>
<a href="https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel" target="_blank">https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel</a><br>
<br></blockquote></div><br></div><div class="gmail_extra">Hi,<div><br></div><div>I think this is linked to this ticket: <a href="https://sourceforge.net/p/phpmyadmin/feature-requests/919/">https://sourceforge.net/p/phpmyadmin/feature-requests/919/</a></div>

<div>The problem is bigger than only having 2 FK on the same field, but also to have a FK on multiple fields.</div><div><br></div><div>So I'm not sure that you need to create a new ticket.</div><div><br></div><div>Hugues.</div>

</div></div>