title: Problem with MySQL LEAST() function not returning results
body: <p>I've been recently using LEAST(tb1, tb2, tb3) AS name within my queries to fetch minimal values across multiple columns and check whether they were not equal to a default value of 0.00 </p>
  
  <p>So far it was working correctly and as intended for me, as well, the version of the script on a remote server is working fine. </p>
  
  <p>However, after changing column defaults and NULL status (I was attempting to see if i could use NULL as opposed to 0.00, which after reading the LEAST documentation would not have been what I wanted to do.) and then afterwards re-importing the table I was originally using. It still will not work as it did before, for no apparent reason, my queries that use LEAST() return nothing at all, empty arrays, and no visible error messages. </p>
  
  <p>I have restarted MySQL, Flushed the tables, pulled the remote script to test on my dev server, and nothing seems to work. </p>
  
  <p>Running the same query on the table via phpmyadmin on both my dev and remote server returns opposite results, locally it returns zero rows, remotely it returns rows, with the same EXPLAIN result on both(aside from #rows in the table). </p>
  
  <p>Removing the LEAST() functions from the queries, does return data on my dev server. </p>
  
  <p>Here is an example query: </p>
  
  <pre><code>SELECT id, make, model, LEAST(r24ch10k, r36ch10k, r24ch15k, r36ch15k, r24ch20k, r36ch20k) AS lowest 
      FROM xml 
      WHERE LEAST(r24ch10k, r36ch10k, r24ch15k, r36ch15k, r24ch20k, r36ch20k) != 0.00         
      ORDER BY lowest LIMIT 5
  </code></pre>
  
  <p><strong>My Local Server Information</strong>:<br>
  Server Version: 5.1.51-community<br>
  Apache/2.2.16 (Win32) PHP/5.3.3<br>
  MySQL client version: mysqlnd 5.0.7-dev - 091210 - $Revision: 300533 $<br>
  PHP extension: mysqli   </p>
  
  <p><strong>My Remote Server Information</strong>:<br>
  Server version: 5.0.51a-24+lenny5<br>
  Apache/2.2.16 PHP/5.3.3<br>
  MySQL client version: 5.0.51a<br>
  PHP extension: mysql   </p>
  
  <p>Help in resolving this issue would be appreciated.</p>