MySQL Bugs: #34484: MySQL crashes or reports an error when performing SQL query

Bug #34484	MySQL crashes or reports an error when performing SQL query
Submitted:	12 Feb 2008 8:46	Modified:	12 Feb 2008 11:35
Reporter:	ren hoek	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	5.0.51a-community-nt MySQL Community Edit	OS:	Windows
Assigned to:		CPU Architecture:	Any
Tags:	crash, error

Description:
When i perform a certain SQL query MySQL either ´gives me this error message:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Unexpected eof found when reading file 'C:\WINDOWS\TEMP\MY2F.tmp' (Errcode: 0)

or it just plain crashes..
When i execute the SQL query through asp it throws the ODBC error and when i execute the query in MySQL Querybrowser the MySQL process crashes
I checked and made sure that there is plenty of free space..

How to repeat:
it happens when i execute the following SQL query:

SELECT users.brugerid, users.username, users.navn, users.adresse1, users.adresse2, users.postnummer, users.stad, users.telefon, users.firma, users.email, users.reseller, users.businesstype, IFNULL((SELECT accesslog.login_time from accesslog where accesslog.xpoint_username=users.username order by accesslog.login_time desc limit 1), 'NOT AVAILABLE') AS logintime, IFNULL((SELECT accesslog.login_status from accesslog where accesslog.xpoint_username=users.username order by accesslog.login_time desc limit 1), 'NOT AVAILABLE') AS loginstatus, IFNULL((SELECT accesslog.xpoint_version from accesslog where accesslog.xpoint_username=users.username order by accesslog.login_time desc limit 1), 'NOT AVAILABLE') AS loginversion, userproducts.productid, userproducts.expiredate, userproducts.productusage, userproducts.ordertime, userproducts.cancelled, products.product_type, product_language.displayname, product_language.region FROM users INNER JOIN userproducts ON userproducts.brugerid = users.brugerid INNER JOIN products ON products.productid = userproducts.productid INNER JOIN product_language ON product_language.productid = products.productid WHERE users.password IS NOT NULL AND userproducts.productusage = 'real' AND product_language.lang = 'EN' ORDER BY users.brugerid ASC

Thank you for the bug report. Could you please test with the latest released
version 5.0.51a and if still happens the crash please provide the dump file
with create table and insert data statements for run the query on our side.
Thanks in advance.

Thank you for the feedback. I wasn't able to repeat with server built with
current source tree so I assume it was fixed somewhat:

productusage: real
   ordertime: 2008-01-28 17:20:28
   cancelled: 0
product_type: basic
 displayname: Office KMS
      region: Denmark
1172 rows in set (5.88 sec)

mysql> show variables like "%version%";
+-------------------------+---------------------+
| Variable_name           | Value               |
+-------------------------+---------------------+
| protocol_version        | 10                  |
| version                 | 5.0.56-nt-debug     |
| version_comment         | Source distribution |
| version_compile_machine | ia32                |
| version_compile_os      | Win32               |
+-------------------------+---------------------+
5 rows in set (0.03 sec)

mysql>

Please wait until the above version is released. Thanks in advance.

thanks for the help! i will await the release :o)