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 Email Updates:
Status: Closed Impact on me:
None 
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.