|
Hi,
I recently updated to version 4.1.2 from a slightly
older one like 4.1.11 or something. But I am now having
a problem.
Before,this query would work fine:
Select distinctrow * from mytable order by
mydatecolumn.
mydatecolumn is a column of type date.
This used to return the records in order of date,
as it should. After the update however, it now returns them in random
order.
If i use a int type column to order by, then it
works fine, it seems ony the date columns will no longer work.
If i take distinctrow out of the query then it
should work, but i have way to much to change to do that, and i still need to be
able to select distinct rows when making a join.
Why does it no longer work?
Thanks.
|
No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.405 / Virus Database: 268.10.9/416 - Release Date: 8/10/2006
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
