On Tuesday 23 July 2002 19:39, Sergey S. Kostyliov wrote: > >Description: > > ERROR 2013: Lost connection to MySQL server during query. > > >How-To-Repeat: > > select distinct s.supplier_id, s.who_pay, r.name as rname, s.name, > s.nick, s.address, s.contact_person, s.email, s.fax, > s.comment > from supplier s, product_supplier ps, shop_product_supplier sps > use index(product_supplier_id) > left join route r on r.route_id=s.route_id > where ps.product_supplier_id=sps.product_supplier_id and > sps.shop_id=10 and ps.supplier_id=s.supplier_id > order by name > limit 0, 10 > > > Result: > ERROR 2013: Lost connection to MySQL server during query > Note: > The same results with oficial mysql-4.0.2 and latest bk snapshot, > mysql was compiled with both gcc-3.1 and gcc-295.3 > >
Unfortunately we can't test this bug report as we do not have tables to run this query with. Please check tables you have at first to eliminate corrupted table is the source of the problem and if problem persist upload them into secret directory at ftp://support.mysql.com If you are able to create small repeatable case you may send it in the mail. -- __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Peter Zaitsev <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Moscow, Russia <___/ www.mysql.com M: +7 095 725 4955 --------------------------------------------------------------------- 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