Can you try this with a more recent MySQL version?
I cannot reproduce it here, on FreeBSD 4.3 running MySQL 3.23.38.
G'luck,
Peter
--
This sentence contains exactly threee erors.
On Tue, May 22, 2001 at 08:32:24PM +0300, 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,
---------------------------------------------------------------------
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
