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 Target Version:

[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.