List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:March 4 2000 11:38pm
Subject:strange errors when grouping by a function in 3.23.11
View as plain text  
Hi!

> 
> 
> Hello all.  I'm getting some strange errors with mysql 3.23.11 on
> linux-alpha:
> 
> This first query is fine:
> mysql> select docID, month(transferred), year(transferred) from
> User_Documents limit 20;
> +-------+--------------------+-------------------+
> | docID | month(transferred) | year(transferred) |
> +-------+--------------------+-------------------+
> |    15 |                 12 |              1998 |
> |    11 |                  6 |              1997 |
> |     8 |                  1 |              2000 |
> 
> <cut>
> 
> 
> However, if you try to group by a function:
> mysql> select count(docID), month(transferred) as m, year(transferred) as y
> from User_Documents group by m, y limit 20;
> +----------------------+----------------------+---------------------+
> | count(docID)         | m                    | y                   |
> +----------------------+----------------------+---------------------+
> |  4323455642275676160 | -1702360659146015169 | 3657872875471241504 |
> | -8070450532229041469 | -4350477240039825358 | 3657943244215419168 |
> |  4611686018446267414 |    -9007199254667244 | 1446535089688150304 |
> 
> <cut>

The problem is a bug in memcpy in egcs 1.1.2 on Linux-Alpha.  We had
added a workaround for this in MySQL 3.23.12.

Regards,
Monty
Thread
strange errors when grouping by a function in 3.23.11Michael Widenius5 Mar