You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Aleksey Yeschenko (JIRA)" <ji...@apache.org> on 2012/10/02 04:11:07 UTC
[jira] [Created] (CASSANDRA-4746) cqlsh timestamp formatting is
broken - displays wrong timezone info (at least on Ubuntu)
Aleksey Yeschenko created CASSANDRA-4746:
--------------------------------------------
Summary: 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.2.0 beta 1, 1.1.5
Environment: 64-bit Ubuntu 12.04, python 2.7.3
Reporter: Aleksey Yeschenko
Assignee: Aleksey Yeschenko
Priority: Minor
Fix For: 1.1.6, 1.2.0 beta 2
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
[jira] [Updated] (CASSANDRA-4746) cqlsh timestamp formatting is
broken - displays wrong timezone info (at least on Ubuntu)
Posted by "Aleksey Yeschenko (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4746?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Aleksey Yeschenko updated CASSANDRA-4746:
-----------------------------------------
Reviewer: brandon.williams
> 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.2.0 beta 2
>
> Attachments: 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
[jira] [Updated] (CASSANDRA-4746) cqlsh timestamp formatting is
broken - displays wrong timezone info (at least on Ubuntu)
Posted by "Aleksey Yeschenko (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4746?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Aleksey Yeschenko updated CASSANDRA-4746:
-----------------------------------------
Attachment: 4746.txt
> 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.2.0 beta 2
>
> Attachments: 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
[jira] [Updated] (CASSANDRA-4746) cqlsh timestamp formatting is
broken - displays wrong timezone info (at least on Ubuntu)
Posted by "Aleksey Yeschenko (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4746?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Aleksey Yeschenko updated CASSANDRA-4746:
-----------------------------------------
Attachment: 4746-1.1.txt
> 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
[jira] [Commented] (CASSANDRA-4746) cqlsh timestamp formatting is
broken - displays wrong timezone info (at least on Ubuntu)
Posted by "Brandon Williams (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4746?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13487130#comment-13487130 ]
Brandon Williams commented on CASSANDRA-4746:
---------------------------------------------
I used both patches and did a 'merge -s ours' on the second one for trunk which may have caused confusion.
> 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
[jira] [Commented] (CASSANDRA-4746) cqlsh timestamp formatting is
broken - displays wrong timezone info (at least on Ubuntu)
Posted by "Aleksey Yeschenko (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4746?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13487104#comment-13487104 ]
Aleksey Yeschenko commented on CASSANDRA-4746:
----------------------------------------------
Huh? I have it in trunk. Seems like it was merged just fine.
> 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
[jira] [Updated] (CASSANDRA-4746) cqlsh timestamp formatting is
broken - displays wrong timezone info (at least on Ubuntu)
Posted by "Aleksey Yeschenko (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4746?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Aleksey Yeschenko updated CASSANDRA-4746:
-----------------------------------------
Fix Version/s: 1.1.7
> 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
[jira] [Updated] (CASSANDRA-4746) cqlsh timestamp formatting is
broken - displays wrong timezone info (at least on Ubuntu)
Posted by "Aleksey Yeschenko (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4746?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Aleksey Yeschenko updated CASSANDRA-4746:
-----------------------------------------
Fix Version/s: (was: 1.1.7)
1.2.0 beta 2
> 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.2.0 beta 2
>
> Attachments: 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
[jira] [Updated] (CASSANDRA-4746) cqlsh timestamp formatting is
broken - displays wrong timezone info (at least on Ubuntu)
Posted by "Aleksey Yeschenko (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4746?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Aleksey Yeschenko updated CASSANDRA-4746:
-----------------------------------------
Labels: cqlsh (was: )
> 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.6, 1.2.0 beta 2
>
>
> 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
[jira] [Commented] (CASSANDRA-4746) cqlsh timestamp formatting is
broken - displays wrong timezone info (at least on Ubuntu)
Posted by "Aleksey Yeschenko (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4746?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13484891#comment-13484891 ]
Aleksey Yeschenko commented on CASSANDRA-4746:
----------------------------------------------
Not anymore.
> 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
[jira] [Resolved] (CASSANDRA-4746) cqlsh timestamp formatting is
broken - displays wrong timezone info (at least on Ubuntu)
Posted by "Jonathan Ellis (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4746?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jonathan Ellis resolved CASSANDRA-4746.
---------------------------------------
Resolution: Fixed
> 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
[jira] [Commented] (CASSANDRA-4746) cqlsh timestamp formatting is
broken - displays wrong timezone info (at least on Ubuntu)
Posted by "Brandon Williams (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4746?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13484859#comment-13484859 ]
Brandon Williams commented on CASSANDRA-4746:
---------------------------------------------
Is there any reason not to put this in 1.1?
> 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.2.0 beta 2
>
> Attachments: 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
[jira] [Reopened] (CASSANDRA-4746) cqlsh timestamp formatting is
broken - displays wrong timezone info (at least on Ubuntu)
Posted by "Jonathan Ellis (JIRA)" <ji...@apache.org>.
[ 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