Mailing-List: contact commits-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@cassandra.apache.org
Date: Tue, 30 Oct 2012 15:46:12 +0000 (UTC)
From: "Jonathan Ellis (JIRA)" <jira@apache.org>
To: commits@cassandra.apache.org
Message-ID: <115831698.44987.1351611972265.JavaMail.jiratomcat@arcas>
In-Reply-To: <1087812759.152577.1349143867849.JavaMail.jiratomcat@arcas>
Subject: [jira] [Reopened] (CASSANDRA-4746) cqlsh timestamp formatting is
 broken - displays wrong timezone info (at least on Ubuntu)
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


     [ https://issues.apache.org/jira/browse/CASSANDRA-4746?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jonathan Ellis reopened CASSANDRA-4746:
---------------------------------------


reopening because this was not merged to trunk.  (I got a conflict on merge so I just kept the trunk version as a temporary fix.)
                
> cqlsh timestamp formatting is broken - displays wrong timezone info (at least on Ubuntu)
> ----------------------------------------------------------------------------------------
>
>                 Key: CASSANDRA-4746
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-4746
>             Project: Cassandra
>          Issue Type: Bug
>    Affects Versions: 1.1.5, 1.2.0 beta 1
>         Environment: 64-bit Ubuntu 12.04, python 2.7.3
>            Reporter: Aleksey Yeschenko
>            Assignee: Aleksey Yeschenko
>            Priority: Minor
>              Labels: cqlsh
>             Fix For: 1.1.7, 1.2.0 beta 2
>
>         Attachments: 4746-1.1.txt, 4746.txt
>
>
> cqlsh> create keyspace test with strategy_class = 'SimpleStrategy' AND strategy_options:replication_factor = 1;
> cqlsh> use test;
> cqlsh:test> create table ts (id int primary key, ts timestamp);
> cqlsh:test> insert into ts (id, ts) values (1, '2012-05-14 07:53:20+0000');
> cqlsh:test> select * from ts;
>  id | ts
> ----+--------------------------
>   1 | 2012-05-14 10:53:20+0000
> Should've been 2012-05-14 10:53:20+0300.
> cqlsh formats timestamps using '%Y-%m-%d %H:%M:%S%z' format-string and 'the %z escape that expands to the preferred hour/minute offset is not supported by all ANSI C libraries'. In this case it's just replaced with all zeroes.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira