Haksun, Confirming that my system-combination (below) works as expected and does NOT exhibit the XP 'bug' you are experiencing. My system's output is 1 2 1 2 + 1 4 1 2 + 1 2 1 4 + 1 4 1 4. Regards, =dn
> DL, > > Thanks for the reply. > Can you give more details please? > > If I understand you correctly, you did not reproduce the errors I get. > In other words, your output was exactly the same as > > > > f1 f2 f1 f2 > > > > > > 1 2 1 2 > > > > > > 1 4 1 2 > > > > > > 1 2 1 4 > > > > > > 1 4 1 4 > > > > > > If that is the case, is this a Win-XP specific bug? > Can someone running versions other than MySQL 4.0.5-beta on XP verify if > it is a bug please? > > Thanks! > > > Haksun > > > -----Original Message----- > > From: DL Neil [mailto:[EMAIL PROTECTED]] > > Sent: Sunday, December 01, 2002 3:39 PM > > To: Haksun Li; [EMAIL PROTECTED] > > Subject: Re: mysql join problem (bug?) > > > > Hi Haksun, > > Cross-join works perfectly on 3.23.53-max-nt under Win2000 SP2, both > from > > command line and MySQL Control Center 0.8.6-alpha. > > Regards, > > =dn > > > > > > > Hi all, > > > > > > > > > > > > I found this join problem using mysql 3.23.53-max-nt (on WinXP). > > > > > > It works fine on MySQL 3.23.52-log (on Linux). > > > > > > > > > > > > Could someone please confirm that it is a bug? Or enlighten me on > > > writing the correct sql? > > > > > > > > > > > > I have a table and data as shown in the script below. > > > > > > > > > > > > > > > > > > CREATE TABLE test ( > > > > > > f1 int(11) NOT NULL default '0', > > > > > > f2 int(11) NOT NULL default '0' > > > > > > ) TYPE=MyISAM; > > > > > > > > > > > > # > > > > > > # Dumping data for table `test` > > > > > > # > > > > > > > > > > > > INSERT INTO test VALUES (1, 2); > > > > > > INSERT INTO test VALUES (1, 4); > > > > > > > > > > > > > > > > > > Then I do a join with this query: > > > > > > > > > > > > SELECT t1.*, t2.* from test as t1, test as t2 where t1.f1 = t2.f1 > > > > > > > > > > > > Unfortuantley, I got this output. > > > > > > > > > > > > > > > > > > f1 f2 f1 f2 > > > > > > 1 2 1 2 > > > > > > 1 2 1 2 > > > > > > 1 4 1 4 > > > > > > 1 4 1 4 > > > > > > > > > > > > > > > > > > > > > > > > I would expect the output like this (which I get on Linux using > MySQL > > > 3.23.52-log). I also get this using other DB (e.g. Access). > > > > > > > > > > > > f1 f2 f1 f2 > > > > > > 1 2 1 2 > > > > > > 1 4 1 2 > > > > > > 1 2 1 4 > > > > > > 1 4 1 4 > > > > > > > > > > > > > > > > > > Does anyone else experience the same problem? > > > > > > > > > > > > Thanks. > > > > > > > > > > > > Haksun > > > > > > > > > > > > > > --------------------------------------------------------------------- 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