Bug #43343 ibmdb2i Storage Engine does not honor timezone settings with INSERT
Submitted: 3 Mar 2009 22:13 Modified: 7 Dec 2010 8:53
Reporter: Kyle Joiner Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Server: DB2SE for IBM i Severity:S3 (Non-critical)
Version:5.1.30, 5.0, 5.1, 6.0 bzr OS:Any (Linux, IBM i5os)
Assigned to: CPU Architecture:Any
Tags: ibmdb2i, time zone

[3 Mar 2009 22:13] Kyle Joiner
Description:
The CSV storage engine is not honoring the time_zone system variable when doing INSERTs.

How to repeat:
create table t1 (ts timestamp) engine=csv;
set time_zone='+00:00';
insert into t1 (ts) values ('2003-03-30 02:30:00');
set time_zone='+10:30';
insert into t1 (ts) values ('2003-03-30 02:30:00');
set time_zone='-10:00';
insert into t1 (ts) values ('2003-03-30 02:30:00');
select * from t1;

Expected:

+---------------------+   
| ts                  |   
+---------------------+   
| 2003-03-29 16:30:00 |   
| 2003-03-29 06:00:00 |   
| 2003-03-30 02:30:00 |   
+---------------------+   
3 rows in set (0.01 sec)  

Actual:

+---------------------+   
| ts                  |   
+---------------------+   
| 2003-03-30 02:30:00 |   
| 2003-03-30 02:30:00 |   
| 2003-03-30 02:30:00 |   
+---------------------+   
3 rows in set (0.01 sec)

How to repeat:
How to repeat:
create table t1 (ts timestamp) engine=csv;
set time_zone='+00:00';
insert into t1 (ts) values ('2003-03-30 02:30:00');
set time_zone='+10:30';
insert into t1 (ts) values ('2003-03-30 02:30:00');
set time_zone='-10:00';
insert into t1 (ts) values ('2003-03-30 02:30:00');
select * from t1;