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
