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