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

• Submitted: 14 Jan 2005 10:51
• Modified: 5 Feb 2005 3:05
• Reporter: Dmitri Lenev
• Status: Closed
• Category: Server
• Severity: S3 (Non-critical)
• Version: 4.1
• OS: Any (Any)
• Assigned to: Dmitri Lenev

[14 Jan 2005 10:51] Dmitri 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 19:54] Dmitri Lenev

Fixed in 4.1.10 (5.0 branch was not affected).

[5 Feb 2005 3:05] Paul DuBois

Mentioned in 4.1.10 change notes.