Description:
Query returns an unexpected result.
How-To-Repeat:
run the script below:
---------------------------------------------------------------------
create table member
(
userid int(11) primary key auto_increment,
mailaddress char(40) not null
);
insert into member values (null,'[EMAIL PROTECTED]');
insert into member values (null,'[EMAIL PROTECTED]');
create table orders
(
orderid int(11) primary key auto_increment,
userid int(11) not null,
placedate datetime,
status enum('WORKING','ACCEPTED','CANCELED','SHIPPED'),
comments char(255)
);
insert into orders values (null,1,sysdate(),'ACCEPTED',null);
insert into orders values (null,2,sysdate(),'ACCEPTED',null);
alter table orders add
(
contact_date datetime,
payment_date datetime,
shipping_date datetime,
followup_date datetime,
cancel_date datetime
);
update orders set shipping_date=sysdate();
update orders set cancel_date=sysdate() where orderid=1;
select
o.orderid,
o.shipping_date,
o.cancel_date
from orders o, member u
where o.userid = u.userid;
select
o.orderid,
o.shipping_date,
o.cancel_date
from orders o, member u
where o.userid = u.userid
and o.orderid = 1;
---------------------------------------------------------------------
the results of the last two queries are:
orderid shipping_date cancel_date
1 2002-05-20 21:50:24 NULL
2 2002-05-20 21:50:24 NULL
orderid shipping_date cancel_date
1 2002-05-20 21:50:24 2002-05-20 21:50:24
in the first query, cancel_date should not be null for orderid=1.
MySQL support: none
Severity: serious
Priority: high
Category: mysqld
Class: support
Release: mysql-3.23.38
Exectutable: mysqld-nt
System: Win200
__________________________________________________
Do You Yahoo!?
Yahoo! BB is Broadband by Yahoo!
http://bb.yahoo.co.jp/
---------------------------------------------------------------------
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
