Eugene,
Monday, November 11, 2002, 9:40:20 PM, you wrote:
EB> mysqld-nt.exe has genrated errors and will be closed by Windows.
EB> You will need to restart the program.
EB> An error log is being created.
EB> select distinct a.* from gnrlasoc a, tasks b where a.row_key_1 = b.prim_key;
EB> The num
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
A Cartesian product will generate the number of rows in Table 1 times the
number of rows in Table 2. For example if T1 has 1,000 rows and T2 has
10,000 rows your result set will contain 10,000,000 rows.
Arthur
-
Eugene Bendersky wrote:
>May be this was reported alread
You have no where clause.
The cartesian product you are creating
could be very large, and may be filling your temp
directory. This will make it appear to have crashed
when it is merely waiting for disk space.
Next time this happens, check freespace.
Eugene Bendersky wrote:
May be this was repo
Eugene,
Saturday, November 09, 2002, 1:33:39 AM, you wrote:
EB> May be this was reported already.
EB> I have windows 2000 using mysql version 4.0.3-beta-nt
EB> When I ran a query like
EB> select distinct a.* from tasks a, gnrlasoc b;
EB> mysqld-nt.exe crashes.
EB> I know this query makes no
