From: martin
Date: March 19 1999 12:16pm
Subject: mysqld coredumps when joining with empty table
List-Archive: http://lists.mysql.com/mysql/586
Message-Id: <19990319121624.16419.qmail@mail.svenskabutiker.se>

>Description:
mysqld coredumps with a floating point exception when 
running the following query:

DB Error [Lost connection to MySQL server during query] : 
SELECT Variant.*, Unit.unit FROM Variant LEFT JOIN
Unit using (unit_id)WHERE ItemID = 751 ORDER BY TextID at Fetch.pm line 395 

If the Unit table is empty.

>How-To-Repeat:

>Fix:
I inserted one record into the Unit table and it now works as expected.

>Submitter-Id:	<submitter ID>
>Originator: 	Martin Nilsson
>Organization:  Filex AB
>MySQL support: none
>Synopsis:	mysqld coredumps whe LEFT JOINING with empty table
>Severity:	serious
>Priority:	medium
>Category:	mysql
>Class:		sw-bug
>Release:	mysql-3.22.20a (Source distribution)
>Server: /usr/local/bin/mysqladmin  Ver 7.8 Distrib 3.22.20a, for unknown-freebsd2.2.8 on i386
TCX Datakonsult AB, by Monty

Server version		3.22.20a
Protocol version	10
Connection		Localhost via UNIX socket
UNIX socket		/tmp/mysql.sock
Uptime:			52 min 1 sec

Threads: 1  Questions: 1300  Slow queries: 0  Opens: 24  Flush tables: 1  Open tables: 20
>Environment:
	
System: FreeBSD www.svenskabutiker.se 2.2.8-STABLE FreeBSD 2.2.8-STABLE #0: Tue Feb  2 18:12:42 CET 1999     root@stripped:/usr/src/sys/compile/WWWx  i386


Some paths:  /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: gcc version 2.7.2.1
Compilation info: CC='gcc'  CFLAGS=''  CXX='gcc'  CXXFLAGS=''  LDFLAGS=''
Configure command: ./configure  --with-unix-socket-path=/var/tmp/mysql.sock --with-low-memory --with-mit-threads=yes
Perl: This is perl, version 5.005_02 built for i386-freebsd