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 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 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 > >--------------------------------------------------------------------- >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 > > > > --------------------------------------------------------------------- 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
