query would produce is tiny.
Eugene
-Original Message-
From: Arthur Fuller [mailto:afuller@;etsys.com]
Sent: Monday, November 11, 2002 7:54 AM
To: Eugene Bendersky
Cc: [EMAIL PROTECTED]
Subject: RE: query crushes server
A Cartesian product will generate the number of rows in Table 1 times
its not waiting, its crushing.
-Original Message-
From: gerald_clark [mailto:gerald_clark@;suppliersystems.com]
Sent: Monday, November 11, 2002 6:07 AM
To: Eugene Bendersky
Cc: [EMAIL PROTECTED]
Subject: Re: query crushes server
You have no where clause.
The cartesian product you are
May be this was reported already.
I have windows 2000 using mysql version 4.0.3-beta-nt
When I ran a query like
select distinct a.* from tasks a, gnrlasoc b;
mysqld-nt.exe crashes.
I know this query makes no sense but it should not crush server
Eugene Bendersky
