You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Ahmet AKYOL (JIRA)" <ji...@apache.org> on 2012/06/20 19:40:42 UTC
[jira] [Created] (CASSANDRA-4362) cqlsh can't display reversed type
values properly
Ahmet AKYOL created CASSANDRA-4362:
--------------------------------------
Summary: cqlsh can't display reversed type values properly
Key: CASSANDRA-4362
URL: https://issues.apache.org/jira/browse/CASSANDRA-4362
Project: Cassandra
Issue Type: Bug
Components: Tools
Affects Versions: 1.1.1
Reporter: Ahmet AKYOL
Priority: Minor
Here is table and data:
CREATE TABLE t1 (
a int,
b bigint,
c varchar,
d varchar,
PRIMARY KEY (a,b,c)
) WITH CLUSTERING ORDER BY (b DESC, c DESC);
INSERT INTO db.t1 (a,b,c,d) VALUES (1,10,'u1','s1');
INSERT INTO db.t1 (a,b,c,d) VALUES (1,15,'u1','d1');
INSERT INTO db.t1 (a,b,c,d) VALUES (1,21,'u3','ghfgh f1g');
INSERT INTO db.t1 (a,b,c,d) VALUES (1,31,'u2','1gh');
INSERT INTO db.t1 (a,b,c,d) VALUES (1,41,'u3','fgh1');
And here's the query
cqlsh:db> SELECT * FROM t1;
a | b | c | d
---+----------------------------------+----+-----------
1 | \x00\x00\x00\x00\x00\x00\x00) | u3 | fgh1
1 | \x00\x00\x00\x00\x00\x00\x00\x1f | u2 | 1gh
1 | \x00\x00\x00\x00\x00\x00\x00\x15 | u3 | ghfgh f1g
1 | \x00\x00\x00\x00\x00\x00\x00\x0f | u1 | d1
1 | \x00\x00\x00\x00\x00\x00\x00\n | u1 | s1
As you can see, cqlsh can't display reversed type values properly ...
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-4362) cqlsh can't display reversed
type values properly
Posted by "Aleksey Yeschenko (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4362?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13483805#comment-13483805 ]
Aleksey Yeschenko commented on CASSANDRA-4362:
----------------------------------------------
cqlsh:db> select * from t1;
a | b | c | d
---+----+----+-----------
1 | 41 | u3 | fgh1
1 | 31 | u2 | 1gh
1 | 21 | u3 | ghfgh f1g
1 | 15 | u1 | d1
1 | 10 | u1 | s1
I assume this it not a problem anymore.
> cqlsh can't display reversed type values properly
> -------------------------------------------------
>
> Key: CASSANDRA-4362
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4362
> Project: Cassandra
> Issue Type: Bug
> Components: Tools
> Affects Versions: 1.1.1
> Reporter: Ahmet AKYOL
> Assignee: Aleksey Yeschenko
> Priority: Minor
> Labels: cqlsh
> Fix For: 1.2.0
>
>
> Here is table and data:
> CREATE TABLE t1 (
> a int,
> b bigint,
> c varchar,
> d varchar,
> PRIMARY KEY (a,b,c)
> ) WITH CLUSTERING ORDER BY (b DESC, c DESC);
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,10,'u1','s1');
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,15,'u1','d1');
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,21,'u3','ghfgh f1g');
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,31,'u2','1gh');
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,41,'u3','fgh1');
> And here's the query
> cqlsh:db> SELECT * FROM t1;
> a | b | c | d
> ---+----------------------------------+----+-----------
> 1 | \x00\x00\x00\x00\x00\x00\x00) | u3 | fgh1
> 1 | \x00\x00\x00\x00\x00\x00\x00\x1f | u2 | 1gh
> 1 | \x00\x00\x00\x00\x00\x00\x00\x15 | u3 | ghfgh f1g
> 1 | \x00\x00\x00\x00\x00\x00\x00\x0f | u1 | d1
> 1 | \x00\x00\x00\x00\x00\x00\x00\n | u1 | s1
> As you can see, cqlsh can't display reversed type values properly ...
--
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-4362) cqlsh can't display reversed
type values properly
Posted by "Sylvain Lebresne (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4362?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13397685#comment-13397685 ]
Sylvain Lebresne commented on CASSANDRA-4362:
---------------------------------------------
That's likely because cqlsh don't know about ReversedType. However, I'm not sure we should fix cqlsh, but maybe rather not send the ReversedType bits. After all for CQL3, the reversed part is a server side optimization, clients shouldn't have to care about it.
> cqlsh can't display reversed type values properly
> -------------------------------------------------
>
> Key: CASSANDRA-4362
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4362
> Project: Cassandra
> Issue Type: Bug
> Components: Tools
> Affects Versions: 1.1.1
> Reporter: Ahmet AKYOL
> Priority: Minor
> Labels: cqlsh
>
> Here is table and data:
> CREATE TABLE t1 (
> a int,
> b bigint,
> c varchar,
> d varchar,
> PRIMARY KEY (a,b,c)
> ) WITH CLUSTERING ORDER BY (b DESC, c DESC);
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,10,'u1','s1');
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,15,'u1','d1');
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,21,'u3','ghfgh f1g');
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,31,'u2','1gh');
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,41,'u3','fgh1');
> And here's the query
> cqlsh:db> SELECT * FROM t1;
> a | b | c | d
> ---+----------------------------------+----+-----------
> 1 | \x00\x00\x00\x00\x00\x00\x00) | u3 | fgh1
> 1 | \x00\x00\x00\x00\x00\x00\x00\x1f | u2 | 1gh
> 1 | \x00\x00\x00\x00\x00\x00\x00\x15 | u3 | ghfgh f1g
> 1 | \x00\x00\x00\x00\x00\x00\x00\x0f | u1 | d1
> 1 | \x00\x00\x00\x00\x00\x00\x00\n | u1 | s1
> As you can see, cqlsh can't display reversed type values properly ...
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-4362) cqlsh can't display reversed
type values properly
Posted by "Ahmet AKYOL (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4362?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13397709#comment-13397709 ]
Ahmet AKYOL commented on CASSANDRA-4362:
----------------------------------------
It's OK for me, not a big deal. However, "clients shouldn't have to care about it" must mean "cqlsh displays reversed type properly", right :)
What I mean is, yes reversed part is a server side optimization, but as clients, we don't care unless we get the proper results...
> cqlsh can't display reversed type values properly
> -------------------------------------------------
>
> Key: CASSANDRA-4362
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4362
> Project: Cassandra
> Issue Type: Bug
> Components: Tools
> Affects Versions: 1.1.1
> Reporter: Ahmet AKYOL
> Priority: Minor
> Labels: cqlsh
>
> Here is table and data:
> CREATE TABLE t1 (
> a int,
> b bigint,
> c varchar,
> d varchar,
> PRIMARY KEY (a,b,c)
> ) WITH CLUSTERING ORDER BY (b DESC, c DESC);
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,10,'u1','s1');
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,15,'u1','d1');
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,21,'u3','ghfgh f1g');
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,31,'u2','1gh');
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,41,'u3','fgh1');
> And here's the query
> cqlsh:db> SELECT * FROM t1;
> a | b | c | d
> ---+----------------------------------+----+-----------
> 1 | \x00\x00\x00\x00\x00\x00\x00) | u3 | fgh1
> 1 | \x00\x00\x00\x00\x00\x00\x00\x1f | u2 | 1gh
> 1 | \x00\x00\x00\x00\x00\x00\x00\x15 | u3 | ghfgh f1g
> 1 | \x00\x00\x00\x00\x00\x00\x00\x0f | u1 | d1
> 1 | \x00\x00\x00\x00\x00\x00\x00\n | u1 | s1
> As you can see, cqlsh can't display reversed type values properly ...
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Assigned] (CASSANDRA-4362) cqlsh can't display reversed
type values properly
Posted by "paul cannon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4362?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
paul cannon reassigned CASSANDRA-4362:
--------------------------------------
Assignee: paul cannon
> cqlsh can't display reversed type values properly
> -------------------------------------------------
>
> Key: CASSANDRA-4362
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4362
> Project: Cassandra
> Issue Type: Bug
> Components: Tools
> Affects Versions: 1.1.1
> Reporter: Ahmet AKYOL
> Assignee: paul cannon
> Priority: Minor
> Labels: cqlsh
>
> Here is table and data:
> CREATE TABLE t1 (
> a int,
> b bigint,
> c varchar,
> d varchar,
> PRIMARY KEY (a,b,c)
> ) WITH CLUSTERING ORDER BY (b DESC, c DESC);
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,10,'u1','s1');
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,15,'u1','d1');
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,21,'u3','ghfgh f1g');
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,31,'u2','1gh');
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,41,'u3','fgh1');
> And here's the query
> cqlsh:db> SELECT * FROM t1;
> a | b | c | d
> ---+----------------------------------+----+-----------
> 1 | \x00\x00\x00\x00\x00\x00\x00) | u3 | fgh1
> 1 | \x00\x00\x00\x00\x00\x00\x00\x1f | u2 | 1gh
> 1 | \x00\x00\x00\x00\x00\x00\x00\x15 | u3 | ghfgh f1g
> 1 | \x00\x00\x00\x00\x00\x00\x00\x0f | u1 | d1
> 1 | \x00\x00\x00\x00\x00\x00\x00\n | u1 | s1
> As you can see, cqlsh can't display reversed type values properly ...
--
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-4362) cqlsh can't display reversed type
values properly
Posted by "paul cannon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4362?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
paul cannon updated CASSANDRA-4362:
-----------------------------------
Fix Version/s: 1.2.0
Since the python-cql driver supports parametrized types as of its 1.1 version, it is now trivial to teach it how to deal with ReversedType. I've done that in the driver, and once we get a new release into cassandra this should be fixed for cassandra 1.2.
> cqlsh can't display reversed type values properly
> -------------------------------------------------
>
> Key: CASSANDRA-4362
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4362
> Project: Cassandra
> Issue Type: Bug
> Components: Tools
> Affects Versions: 1.1.1
> Reporter: Ahmet AKYOL
> Assignee: paul cannon
> Priority: Minor
> Labels: cqlsh
> Fix For: 1.2.0
>
>
> Here is table and data:
> CREATE TABLE t1 (
> a int,
> b bigint,
> c varchar,
> d varchar,
> PRIMARY KEY (a,b,c)
> ) WITH CLUSTERING ORDER BY (b DESC, c DESC);
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,10,'u1','s1');
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,15,'u1','d1');
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,21,'u3','ghfgh f1g');
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,31,'u2','1gh');
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,41,'u3','fgh1');
> And here's the query
> cqlsh:db> SELECT * FROM t1;
> a | b | c | d
> ---+----------------------------------+----+-----------
> 1 | \x00\x00\x00\x00\x00\x00\x00) | u3 | fgh1
> 1 | \x00\x00\x00\x00\x00\x00\x00\x1f | u2 | 1gh
> 1 | \x00\x00\x00\x00\x00\x00\x00\x15 | u3 | ghfgh f1g
> 1 | \x00\x00\x00\x00\x00\x00\x00\x0f | u1 | d1
> 1 | \x00\x00\x00\x00\x00\x00\x00\n | u1 | s1
> As you can see, cqlsh can't display reversed type values properly ...
--
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-4362) cqlsh can't display reversed
type values properly
Posted by "Sylvain Lebresne (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4362?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13397716#comment-13397716 ]
Sylvain Lebresne commented on CASSANDRA-4362:
---------------------------------------------
I was not commenting the report itself, it's clearly a bug (thanks for reporting it), I was discussing how to fix it.
> cqlsh can't display reversed type values properly
> -------------------------------------------------
>
> Key: CASSANDRA-4362
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4362
> Project: Cassandra
> Issue Type: Bug
> Components: Tools
> Affects Versions: 1.1.1
> Reporter: Ahmet AKYOL
> Priority: Minor
> Labels: cqlsh
>
> Here is table and data:
> CREATE TABLE t1 (
> a int,
> b bigint,
> c varchar,
> d varchar,
> PRIMARY KEY (a,b,c)
> ) WITH CLUSTERING ORDER BY (b DESC, c DESC);
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,10,'u1','s1');
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,15,'u1','d1');
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,21,'u3','ghfgh f1g');
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,31,'u2','1gh');
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,41,'u3','fgh1');
> And here's the query
> cqlsh:db> SELECT * FROM t1;
> a | b | c | d
> ---+----------------------------------+----+-----------
> 1 | \x00\x00\x00\x00\x00\x00\x00) | u3 | fgh1
> 1 | \x00\x00\x00\x00\x00\x00\x00\x1f | u2 | 1gh
> 1 | \x00\x00\x00\x00\x00\x00\x00\x15 | u3 | ghfgh f1g
> 1 | \x00\x00\x00\x00\x00\x00\x00\x0f | u1 | d1
> 1 | \x00\x00\x00\x00\x00\x00\x00\n | u1 | s1
> As you can see, cqlsh can't display reversed type values properly ...
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-4362) cqlsh can't display reversed
type values properly
Posted by "Ahmet AKYOL (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4362?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13397777#comment-13397777 ]
Ahmet AKYOL commented on CASSANDRA-4362:
----------------------------------------
BTW, there is no information about 'reversed type' on datastax's comprehensive documentation or on cassandra.apache.org . I like to see 'comparator' and 'clustering order' usage of 'reversed type' documented. I don't know if such a wish is an issue creation worthy but please note it down ... Thanks in advance ..
> cqlsh can't display reversed type values properly
> -------------------------------------------------
>
> Key: CASSANDRA-4362
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4362
> Project: Cassandra
> Issue Type: Bug
> Components: Tools
> Affects Versions: 1.1.1
> Reporter: Ahmet AKYOL
> Priority: Minor
> Labels: cqlsh
>
> Here is table and data:
> CREATE TABLE t1 (
> a int,
> b bigint,
> c varchar,
> d varchar,
> PRIMARY KEY (a,b,c)
> ) WITH CLUSTERING ORDER BY (b DESC, c DESC);
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,10,'u1','s1');
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,15,'u1','d1');
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,21,'u3','ghfgh f1g');
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,31,'u2','1gh');
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,41,'u3','fgh1');
> And here's the query
> cqlsh:db> SELECT * FROM t1;
> a | b | c | d
> ---+----------------------------------+----+-----------
> 1 | \x00\x00\x00\x00\x00\x00\x00) | u3 | fgh1
> 1 | \x00\x00\x00\x00\x00\x00\x00\x1f | u2 | 1gh
> 1 | \x00\x00\x00\x00\x00\x00\x00\x15 | u3 | ghfgh f1g
> 1 | \x00\x00\x00\x00\x00\x00\x00\x0f | u1 | d1
> 1 | \x00\x00\x00\x00\x00\x00\x00\n | u1 | s1
> As you can see, cqlsh can't display reversed type values properly ...
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Comment Edited] (CASSANDRA-4362) cqlsh can't display
reversed type values properly
Posted by "Aleksey Yeschenko (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4362?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13483805#comment-13483805 ]
Aleksey Yeschenko edited comment on CASSANDRA-4362 at 10/25/12 1:27 AM:
------------------------------------------------------------------------
cqlsh:db> select * from t1;
a | b | c | d
---+----+----+-----------
1 | 41 | u3 | fgh1
1 | 31 | u2 | 1gh
1 | 21 | u3 | ghfgh f1g
1 | 15 | u1 | d1
1 | 10 | u1 | s1
I assume this is not a problem anymore.
was (Author: iamaleksey):
cqlsh:db> select * from t1;
a | b | c | d
---+----+----+-----------
1 | 41 | u3 | fgh1
1 | 31 | u2 | 1gh
1 | 21 | u3 | ghfgh f1g
1 | 15 | u1 | d1
1 | 10 | u1 | s1
I assume this it not a problem anymore.
> cqlsh can't display reversed type values properly
> -------------------------------------------------
>
> Key: CASSANDRA-4362
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4362
> Project: Cassandra
> Issue Type: Bug
> Components: Tools
> Affects Versions: 1.1.1
> Reporter: Ahmet AKYOL
> Assignee: Aleksey Yeschenko
> Priority: Minor
> Labels: cqlsh
> Fix For: 1.2.0
>
>
> Here is table and data:
> CREATE TABLE t1 (
> a int,
> b bigint,
> c varchar,
> d varchar,
> PRIMARY KEY (a,b,c)
> ) WITH CLUSTERING ORDER BY (b DESC, c DESC);
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,10,'u1','s1');
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,15,'u1','d1');
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,21,'u3','ghfgh f1g');
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,31,'u2','1gh');
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,41,'u3','fgh1');
> And here's the query
> cqlsh:db> SELECT * FROM t1;
> a | b | c | d
> ---+----------------------------------+----+-----------
> 1 | \x00\x00\x00\x00\x00\x00\x00) | u3 | fgh1
> 1 | \x00\x00\x00\x00\x00\x00\x00\x1f | u2 | 1gh
> 1 | \x00\x00\x00\x00\x00\x00\x00\x15 | u3 | ghfgh f1g
> 1 | \x00\x00\x00\x00\x00\x00\x00\x0f | u1 | d1
> 1 | \x00\x00\x00\x00\x00\x00\x00\n | u1 | s1
> As you can see, cqlsh can't display reversed type values properly ...
--
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] [Comment Edited] (CASSANDRA-4362) cqlsh can't display
reversed type values properly
Posted by "Ahmet AKYOL (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4362?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13397709#comment-13397709 ]
Ahmet AKYOL edited comment on CASSANDRA-4362 at 6/20/12 6:13 PM:
-----------------------------------------------------------------
It's OK for me, not a big deal. However, "clients shouldn't have to care about it" must mean "cqlsh displays reversed type properly", right ?
What I mean is, yes reversed part is a server side optimization, but as clients, we don't care unless we get the proper results :)
was (Author: liqusha):
It's OK for me, not a big deal. However, "clients shouldn't have to care about it" must mean "cqlsh displays reversed type properly", right :)
What I mean is, yes reversed part is a server side optimization, but as clients, we don't care unless we get the proper results...
> cqlsh can't display reversed type values properly
> -------------------------------------------------
>
> Key: CASSANDRA-4362
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4362
> Project: Cassandra
> Issue Type: Bug
> Components: Tools
> Affects Versions: 1.1.1
> Reporter: Ahmet AKYOL
> Priority: Minor
> Labels: cqlsh
>
> Here is table and data:
> CREATE TABLE t1 (
> a int,
> b bigint,
> c varchar,
> d varchar,
> PRIMARY KEY (a,b,c)
> ) WITH CLUSTERING ORDER BY (b DESC, c DESC);
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,10,'u1','s1');
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,15,'u1','d1');
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,21,'u3','ghfgh f1g');
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,31,'u2','1gh');
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,41,'u3','fgh1');
> And here's the query
> cqlsh:db> SELECT * FROM t1;
> a | b | c | d
> ---+----------------------------------+----+-----------
> 1 | \x00\x00\x00\x00\x00\x00\x00) | u3 | fgh1
> 1 | \x00\x00\x00\x00\x00\x00\x00\x1f | u2 | 1gh
> 1 | \x00\x00\x00\x00\x00\x00\x00\x15 | u3 | ghfgh f1g
> 1 | \x00\x00\x00\x00\x00\x00\x00\x0f | u1 | d1
> 1 | \x00\x00\x00\x00\x00\x00\x00\n | u1 | s1
> As you can see, cqlsh can't display reversed type values properly ...
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-4362) cqlsh can't display reversed
type values properly
Posted by "Ahmet AKYOL (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4362?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13397736#comment-13397736 ]
Ahmet AKYOL commented on CASSANDRA-4362:
----------------------------------------
my bad, I've just misinterpreted. keep up the good work ...
> cqlsh can't display reversed type values properly
> -------------------------------------------------
>
> Key: CASSANDRA-4362
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4362
> Project: Cassandra
> Issue Type: Bug
> Components: Tools
> Affects Versions: 1.1.1
> Reporter: Ahmet AKYOL
> Priority: Minor
> Labels: cqlsh
>
> Here is table and data:
> CREATE TABLE t1 (
> a int,
> b bigint,
> c varchar,
> d varchar,
> PRIMARY KEY (a,b,c)
> ) WITH CLUSTERING ORDER BY (b DESC, c DESC);
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,10,'u1','s1');
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,15,'u1','d1');
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,21,'u3','ghfgh f1g');
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,31,'u2','1gh');
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,41,'u3','fgh1');
> And here's the query
> cqlsh:db> SELECT * FROM t1;
> a | b | c | d
> ---+----------------------------------+----+-----------
> 1 | \x00\x00\x00\x00\x00\x00\x00) | u3 | fgh1
> 1 | \x00\x00\x00\x00\x00\x00\x00\x1f | u2 | 1gh
> 1 | \x00\x00\x00\x00\x00\x00\x00\x15 | u3 | ghfgh f1g
> 1 | \x00\x00\x00\x00\x00\x00\x00\x0f | u1 | d1
> 1 | \x00\x00\x00\x00\x00\x00\x00\n | u1 | s1
> As you can see, cqlsh can't display reversed type values properly ...
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Resolved] (CASSANDRA-4362) cqlsh can't display reversed
type values properly
Posted by "Aleksey Yeschenko (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4362?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Aleksey Yeschenko resolved CASSANDRA-4362.
------------------------------------------
Resolution: Not A Problem
> cqlsh can't display reversed type values properly
> -------------------------------------------------
>
> Key: CASSANDRA-4362
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4362
> Project: Cassandra
> Issue Type: Bug
> Components: Tools
> Affects Versions: 1.1.1
> Reporter: Ahmet AKYOL
> Assignee: Aleksey Yeschenko
> Priority: Minor
> Labels: cqlsh
> Fix For: 1.2.0
>
>
> Here is table and data:
> CREATE TABLE t1 (
> a int,
> b bigint,
> c varchar,
> d varchar,
> PRIMARY KEY (a,b,c)
> ) WITH CLUSTERING ORDER BY (b DESC, c DESC);
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,10,'u1','s1');
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,15,'u1','d1');
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,21,'u3','ghfgh f1g');
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,31,'u2','1gh');
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,41,'u3','fgh1');
> And here's the query
> cqlsh:db> SELECT * FROM t1;
> a | b | c | d
> ---+----------------------------------+----+-----------
> 1 | \x00\x00\x00\x00\x00\x00\x00) | u3 | fgh1
> 1 | \x00\x00\x00\x00\x00\x00\x00\x1f | u2 | 1gh
> 1 | \x00\x00\x00\x00\x00\x00\x00\x15 | u3 | ghfgh f1g
> 1 | \x00\x00\x00\x00\x00\x00\x00\x0f | u1 | d1
> 1 | \x00\x00\x00\x00\x00\x00\x00\n | u1 | s1
> As you can see, cqlsh can't display reversed type values properly ...
--
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-4362) cqlsh can't display reversed
type values properly
Posted by "paul cannon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4362?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13398603#comment-13398603 ]
paul cannon commented on CASSANDRA-4362:
----------------------------------------
As a workaround, you can tell cqlsh explicitly to treat the b column as bigint:
{noformat}
ASSUME t1(b) VALUES ARE bigint;
{noformat}
That will last until the end of the session. (You might need the patch from CASSANDRA-4352).
> cqlsh can't display reversed type values properly
> -------------------------------------------------
>
> Key: CASSANDRA-4362
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4362
> Project: Cassandra
> Issue Type: Bug
> Components: Tools
> Affects Versions: 1.1.1
> Reporter: Ahmet AKYOL
> Priority: Minor
> Labels: cqlsh
>
> Here is table and data:
> CREATE TABLE t1 (
> a int,
> b bigint,
> c varchar,
> d varchar,
> PRIMARY KEY (a,b,c)
> ) WITH CLUSTERING ORDER BY (b DESC, c DESC);
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,10,'u1','s1');
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,15,'u1','d1');
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,21,'u3','ghfgh f1g');
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,31,'u2','1gh');
> INSERT INTO db.t1 (a,b,c,d) VALUES (1,41,'u3','fgh1');
> And here's the query
> cqlsh:db> SELECT * FROM t1;
> a | b | c | d
> ---+----------------------------------+----+-----------
> 1 | \x00\x00\x00\x00\x00\x00\x00) | u3 | fgh1
> 1 | \x00\x00\x00\x00\x00\x00\x00\x1f | u2 | 1gh
> 1 | \x00\x00\x00\x00\x00\x00\x00\x15 | u3 | ghfgh f1g
> 1 | \x00\x00\x00\x00\x00\x00\x00\x0f | u1 | d1
> 1 | \x00\x00\x00\x00\x00\x00\x00\n | u1 | s1
> As you can see, cqlsh can't display reversed type values properly ...
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira