Bug #6849 Crash while preparing query containing const expr with IN and CONVERT_TZ()
Submitted: 26 Nov 2004 14:02 Modified: 21 Dec 2004 18:02
Reporter: Dmitry Lenev Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0-bk (2004-11-26) OS:
Assigned to: Dmitry Lenev CPU Architecture:Any

[26 Nov 2004 14:02] Dmitry Lenev 
Description:
Server crashes if one tries to prepare simple query which contains constant expression
involving IN and CONVERT_TZ(), which should read time zone description from system
tables.

This bug only present in 5.0, it does not occur in 4.1.

How to repeat:
Restart server to ensure that any time zone mentioned in CONVERT_TZ() function
will require access to system tables.

Run the following query:
prepare stmt1 from "select '2004-01-01 00:00:00' IN (CONVERT_TZ('2004-01-01 00:00:00', 'Europe/Moscow', 'UTC'))";

Server will crash.
[15 Dec 2004 14:24] Dmitry Lenev 
ChangeSet
  1.1743 04/12/15 17:19:57 dlenev@brandersnatch.localdomain +7 -0
  Fix for bug #6849 "Crash while preparing query containing const expr with
  IN and CONVERT_TZ()".
[21 Dec 2004 18:02] Dmitry Lenev 
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html