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
• Status: Won't fix
• 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)
• 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;