<div dir="ltr"><div><div><font>Hello all,<br></font></div><font><font>I am trying to fix </font>the bug <a href="https://sourceforge.net/p/phpmyadmin/bugs/4154/">https://sourceforge.net/p/phpmyadmin/bugs/4154/</a> . I have few observations regarding this:<br>
if you do </font><br><br></div><div style="text-align:left"><pre><span style="background-color:rgb(238,238,238)"><span class="">SELECT</span> <span class="">*</span> <span class="">FROM</span> <span class="">`</span><span class="">sortunion1</span><span class="">`</span>
<span class="">UNION</span>
<span class="">SELECT</span> <span class="">*</span> <span class="">FROM</span> <span class="">`</span><span class="">sortunion2</span></span><span class=""><span style="background-color:rgb(238,238,238)">` </span> <span style="background-color:rgb(238,238,238)"><span style></span></span></span><br>
</pre></div><pre><font size="4"><span style="font-family:arial,helvetica,sans-serif"><font size="4"><font size="4"><font>what I think is that when you are trying </font><font size="4"><font>to query <font>the above one</font> it transforms it into query as follows</font><br>
<br></font></font></font></span></font><span style="background-color:rgb(238,238,238)"><code class="">SELECT * FROM `sortunion1`
UNION
SELECT * FROM `sortunion2`  ORDER BY `sortunion2`.`id` DESC 
 LIMIT 0, 25</code></span><br></pre><pre><font size="4"><span style="font-family:arial,helvetica,sans-serif">but instead if it transforms the same query as<br></span></font><br><span style="background-color:rgb(238,238,238)"><code class="">SELECT * FROM `sortunion1`
UNION
(SELECT * FROM `sortunion2`  ORDER BY `sortunion2`.`id` DESC )
 LIMIT 0, 25</code></span><br><br></pre><pre><font size="4"><span style="font-family:arial,helvetica,sans-serif">Then there won't be any issue.<br></span></font></pre><pre><font size="4"><span style="font-family:arial,helvetica,sans-serif">Please tell me whether my understanding is correct or not. If yes,then I would like to take up the bug, else please suggest if there is any mistake in my approach.</span></font><br>
<br></pre><pre><span style="font-family:arial,helvetica,sans-serif"><font>Thanks,<br></font></span></pre><pre><span style="font-family:arial,helvetica,sans-serif"><font>Lakshit Arora</font></span><br></pre></div>