Hi.
On Mon, May 20, 2002 at 07:28:01PM +0300, [EMAIL PROTECTED] wrote:
[...]
> II> select
> II> o.orderid,
> II> o.shipping_date,
> II> o.cancel_date
> II> from orders o, member u
> II> where o.userid = u.userid;
[...]
> II> ---------------------------------------------------------------------
> II> the results of the last two queries are:
>
> II> orderid shipping_date cancel_date
> II> 1 2002-05-20 21:50:24 NULL
> II> 2 2002-05-20 21:50:24 NULL
> II> orderid shipping_date cancel_date
> II> 1 2002-05-20 21:50:24 2002-05-20 21:50:24
>
> II> in the first query, cancel_date should not be null for orderid=1.
>
> It is fixed in v4.0.2 ...
As the 4.0.x tree is still declared alpha, can we expect an back-port
of the fix to the 3.23.x tree?
Bye,
Benjamin.
--
[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
