MYSQL wrote:
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.
I highly doubt that's the case otherwise mysql.com would have been
flooded with bug reports about this.
Can you provide a sample case of what's going on (create table syntax,
5-10 lines of data and the exact query you're running) and someone might
be able to work out what's going on.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]