Bug #7899 CREATE TABLE .. SELECT .. and CONVERT_TZ() function does not work well together

• Submitted: 14 Jan 2005 9:51
• Modified: 5 Feb 2005 2:05
• Reporter: Dmitry Lenev
• Status: Closed
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 4.1
• OS: Any (Any)
• Assigned to: Dmitry Lenev
• CPU Architecture: Any

[14 Jan 2005 9:51] Dmitry Lenev

Description:
If one uses CONVERT_TZ() function in SELECT, which in its turn is used in CREATE TABLE or INSERT statement, then system time zone tables will be added to list of tables
joined in SELECT and thus erroneous result will be produced.

How to repeat:
On server with non-empty time zone description tables do:

create table t1 select convert_tz(NULL,NULL,NULL);

It will perform full join of time zone description tables instead of creating table with one NULL row in it.

[29 Jan 2005 18:54] Dmitry Lenev

Fixed in 4.1.10 (5.0 branch was not affected).

[5 Feb 2005 2:05] Paul DuBois

Mentioned in 4.1.10 change notes.