mysql join problem

Sinisa,

Thanks for the reply.

However, it is not the order.

The rows are different!

For example, the row "1 2 1 4" are not there when I use
mysql 3.23.53-max-nt (on WinXP) and MySQL 4.0.5-beta (WinXP).

How-To-Repeat:

Like I said, I got:
f1 f2 f1 f2
1 2 1 2
1 2 1 2
1 4 1 4
1 4 1 4


This output is wrong! The rows "1 2 1 4" and "1 4 1 2" should be there
instead!


Haksun

> -----Original Message-----
> From: Sinisa Milivojevic [mailto:sinisa@mysql.com]
> Sent: Monday, December 02, 2002 2:04 PM
> To: haksunli@engin.umich.edu
> Cc: bugs@lists.mysql.com
> Subject: Re: mysql join problem (bug?)
>
> Haksun Li writes:
> > Hi all,
> >
> > 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
> >
>
> Hi!
>
> I get exactly the same output as above with 4.0.6.
>
> But this is not relevant.
>
> With relational databases, if you do not specify the manner in which
> you wish result set to be ordered, you can get it in any order. And
> any order is all right, according to all pertaining standards.
>
>
> --
> Regards,
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic

> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
> /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
> <___/ www.mysql.com


------------------------------------------------------------ ---------
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 bugs-thread13187@lists.mysql.com
To unsubscribe, e-mail