That is pretty old.
3.23.38 works fine.
Tarog Adrian wrote:
> Hello,
> I think me and my fellows here at office, found a bug in mysql.
> The system is:
> RedHat 7.0, kernel 2.2.16, on Celeron 700MHz
> mysql version 3.23.22
> Here is the script:
> (
> cat <<EOF
> connect test;
> create table test (i numeric(4), j numeric(4));
> insert into test (i,j) values (1, 1);
> insert into test (i,j) values (1, 2);
> insert into test (i,j) values (1, 3);
> insert into test (i,j) values (2, 1);
> insert into test (i,j) values (2, 2);
> select * from test;
> select i, min(j), max(j) from test group by i;
> EOF
> ) | mysql -p
>
> and here is the result:
>
> i j
> 1 1
> 1 2
> 1 3
> 2 1
> 2 2
> i min(j) max(j)
> 1 0 3
> 2 0 2
>
> the interesting part is that if I replace
> create table test (i numeric(4), j numeric(4))
> with
> create table test (i integer, j integer)
> ,
> then the result is ok
>
> We have tested this script on another machine with Pentium 100MHz and
> RH7.0, and the result is the same.
>
> I hope this bug report will be usefull.
> Looking forward for your reply,
>
> Adrian Tarog
> System Engineer
> SC JOLIDON SRL
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Gerald L. Clark
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php