It's a miracle.
Which version of the BDB patch do you use?
I'm using 3.2.9a.
(Previously, there has been a version 3.2.3g...)
Thanks...
Günther Pewny
Sinisa Milivojevic wrote:
> Guenther Pewny writes:
> > Hi folks,
> >
> > I have a problem with BDB tables. Please look at this short mysql session:
> >
> > mysql> create table sample (
> > id1 int(8) not null,
> > id2 int(8) not null,
> > primary key (id1,id2))
> > type=BDB;
> > Query OK, 0 rows affected (0.67 sec)
> >
> > mysql> insert into sample values (1, 2);
> > Query OK, 1 row affected (0.07 sec)
> >
> > mysql> select id2 from sample where id1=1;
> > +-----+
> > | id2 |
> > +-----+
> > | 2 |
> > +-----+
> > 1 row in set (0.00 sec)
> >
> > mysql> select min(id2) from sample where id1=1;
> > +----------+
> > | min(id2) |
> > +----------+
> > | 2 |
> > +----------+
> > 1 row in set (0.00 sec)
> >
> > mysql> select max(id2) from sample where id1=1;
> > +----------+
> > | max(id2) |
> > +----------+
> > | NULL |
> > +----------+
> > 1 row in set (0.00 sec)
> >
> > Is this a bug in mySQL?
> > Why does MIN() return the correct result, while MAX() does not?
> > Is it a severe bug which possibly can cause data inconsistency
> > within the table data or does there exist a "good" workaround for
> > this problem with only modifying the query?
> >
> > Thanks
> > Günther Pewny
> >
> >
>
> Hi!
>
> I have just tested this with 3.23.33 and it executed just fine !!
>
> Regards,
>
> Sinisa
>
> ____ __ _____ _____ ___ == MySQL AB
> /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
> /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
> /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
> /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
> ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
> /*/ \*\ Developers Team
---------------------------------------------------------------------
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
