You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Kristine Hahn (JIRA)" <ji...@apache.org> on 2012/11/28 01:28:58 UTC
[jira] [Created] (CASSANDRA-4999) 1.2.0-beta2 does returns empty
results from song_tags in CQL2
Kristine Hahn created CASSANDRA-4999:
----------------------------------------
Summary: 1.2.0-beta2 does returns empty results from song_tags in CQL2
Key: CASSANDRA-4999
URL: https://issues.apache.org/jira/browse/CASSANDRA-4999
Project: Cassandra
Issue Type: Bug
Affects Versions: 1.2.0 beta 2
Reporter: Kristine Hahn
Priority: Trivial
To reproduce the problem:
1. start CQL2 ./cqlsh --cql2
Connected to Test Cluster at localhost:9160.
[cqlsh 2.3.0 | Cassandra 0.0.0 | CQL spec 2.0.0 | Thrift protocol 19.35.0]
2. create a keyspace and use it.
3. create the tables and insert data:
CREATE COLUMNFAMILY songs (id uuid PRIMARY KEY, title text, album text, artist text, data blob);
CREATE COLUMNFAMILY song_tags (id uuid PRIMARY KEY) WITH comparator=text;
insert into songs (id, title, artist, album) values ('a3e64f8f-bd44-4f28-b8d9-6938726e34d4', 'La Grange', 'ZZ Top', 'Tres Hombres');
insert into songs (id, title, artist, album) values ('8a172618-b121-4136-bb10-f665cfc469eb', 'Moving in Stereo', 'Fu Manchu', 'We Must Obey');
insert into songs (id, title, artist, album) values ('62c36092-82a1-3a00-93d1-46196ee77204', 'Outside Woman Blues', 'Back Door Slam', 'Roll Away');
insert into song_tags ('id', 'blues', '1973') values ('a3e64f8f-bd44-4f28-b8d9-6938726e34d4', '', '');
insert into song_tags ('id', 'covers', '2007') values ('8a172618-b121-4136-bb10-f665cfc469eb', '', '');
4. Select * from song_tags;
Expected result:
id,8a172618-b121-4136-bb10-f665cfc469eb | 2007, | covers,
id,a3e64f8f-bd44-4f28-b8d9-6938726e34d4 | 1973, | blues,
Actual result:
none
--
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-4999) CQL2 returns empty results from
song_tags
Posted by "Brandon Williams (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13505735#comment-13505735 ]
Brandon Williams commented on CASSANDRA-4999:
---------------------------------------------
This appears to just be a problem in cqlsh, if you only insert one tag it works, but with more it just seems to print whitespace.
> CQL2 returns empty results from song_tags
> -----------------------------------------
>
> Key: CASSANDRA-4999
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4999
> Project: Cassandra
> Issue Type: Bug
> Affects Versions: 1.2.0 beta 2
> Reporter: Kristine Hahn
> Priority: Trivial
>
> To reproduce the problem:
> 1. start CQL2 ./cqlsh --cql2
> Connected to Test Cluster at localhost:9160.
> [cqlsh 2.3.0 | Cassandra 0.0.0 | CQL spec 2.0.0 | Thrift protocol 19.35.0]
> 2. create a keyspace and use it.
> 3. create the tables and insert data:
> CREATE COLUMNFAMILY songs (id uuid PRIMARY KEY, title text, album text, artist text, data blob);
> CREATE COLUMNFAMILY song_tags (id uuid PRIMARY KEY) WITH comparator=text;
> insert into songs (id, title, artist, album) values ('a3e64f8f-bd44-4f28-b8d9-6938726e34d4', 'La Grange', 'ZZ Top', 'Tres Hombres');
> insert into songs (id, title, artist, album) values ('8a172618-b121-4136-bb10-f665cfc469eb', 'Moving in Stereo', 'Fu Manchu', 'We Must Obey');
> insert into songs (id, title, artist, album) values ('62c36092-82a1-3a00-93d1-46196ee77204', 'Outside Woman Blues', 'Back Door Slam', 'Roll Away');
> insert into song_tags ('id', 'blues', '1973') values ('a3e64f8f-bd44-4f28-b8d9-6938726e34d4', '', '');
> insert into song_tags ('id', 'covers', '2007') values ('8a172618-b121-4136-bb10-f665cfc469eb', '', '');
> 4. Select * from song_tags;
> Expected result:
> id,8a172618-b121-4136-bb10-f665cfc469eb | 2007, | covers,
> id,a3e64f8f-bd44-4f28-b8d9-6938726e34d4 | 1973, | blues,
> Actual result:
> none
--
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] [Assigned] (CASSANDRA-4999) CQL2 returns empty results from
song_tags
Posted by "Brandon Williams (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4999?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Brandon Williams reassigned CASSANDRA-4999:
-------------------------------------------
Assignee: Aleksey Yeschenko
> CQL2 returns empty results from song_tags
> -----------------------------------------
>
> Key: CASSANDRA-4999
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4999
> Project: Cassandra
> Issue Type: Bug
> Affects Versions: 1.2.0 beta 2
> Reporter: Kristine Hahn
> Assignee: Aleksey Yeschenko
> Priority: Trivial
>
> To reproduce the problem:
> 1. start CQL2 ./cqlsh --cql2
> Connected to Test Cluster at localhost:9160.
> [cqlsh 2.3.0 | Cassandra 0.0.0 | CQL spec 2.0.0 | Thrift protocol 19.35.0]
> 2. create a keyspace and use it.
> 3. create the tables and insert data:
> CREATE COLUMNFAMILY songs (id uuid PRIMARY KEY, title text, album text, artist text, data blob);
> CREATE COLUMNFAMILY song_tags (id uuid PRIMARY KEY) WITH comparator=text;
> insert into songs (id, title, artist, album) values ('a3e64f8f-bd44-4f28-b8d9-6938726e34d4', 'La Grange', 'ZZ Top', 'Tres Hombres');
> insert into songs (id, title, artist, album) values ('8a172618-b121-4136-bb10-f665cfc469eb', 'Moving in Stereo', 'Fu Manchu', 'We Must Obey');
> insert into songs (id, title, artist, album) values ('62c36092-82a1-3a00-93d1-46196ee77204', 'Outside Woman Blues', 'Back Door Slam', 'Roll Away');
> insert into song_tags ('id', 'blues', '1973') values ('a3e64f8f-bd44-4f28-b8d9-6938726e34d4', '', '');
> insert into song_tags ('id', 'covers', '2007') values ('8a172618-b121-4136-bb10-f665cfc469eb', '', '');
> 4. Select * from song_tags;
> Expected result:
> id,8a172618-b121-4136-bb10-f665cfc469eb | 2007, | covers,
> id,a3e64f8f-bd44-4f28-b8d9-6938726e34d4 | 1973, | blues,
> Actual result:
> none
--
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-4999) CQL2 returns empty results from
song_tags
Posted by "Kristine Hahn (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4999?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kristine Hahn updated CASSANDRA-4999:
-------------------------------------
Summary: CQL2 returns empty results from song_tags (was: 1.2.0-beta2 does returns empty results from song_tags in CQL2)
> CQL2 returns empty results from song_tags
> -----------------------------------------
>
> Key: CASSANDRA-4999
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4999
> Project: Cassandra
> Issue Type: Bug
> Affects Versions: 1.2.0 beta 2
> Reporter: Kristine Hahn
> Priority: Trivial
>
> To reproduce the problem:
> 1. start CQL2 ./cqlsh --cql2
> Connected to Test Cluster at localhost:9160.
> [cqlsh 2.3.0 | Cassandra 0.0.0 | CQL spec 2.0.0 | Thrift protocol 19.35.0]
> 2. create a keyspace and use it.
> 3. create the tables and insert data:
> CREATE COLUMNFAMILY songs (id uuid PRIMARY KEY, title text, album text, artist text, data blob);
> CREATE COLUMNFAMILY song_tags (id uuid PRIMARY KEY) WITH comparator=text;
> insert into songs (id, title, artist, album) values ('a3e64f8f-bd44-4f28-b8d9-6938726e34d4', 'La Grange', 'ZZ Top', 'Tres Hombres');
> insert into songs (id, title, artist, album) values ('8a172618-b121-4136-bb10-f665cfc469eb', 'Moving in Stereo', 'Fu Manchu', 'We Must Obey');
> insert into songs (id, title, artist, album) values ('62c36092-82a1-3a00-93d1-46196ee77204', 'Outside Woman Blues', 'Back Door Slam', 'Roll Away');
> insert into song_tags ('id', 'blues', '1973') values ('a3e64f8f-bd44-4f28-b8d9-6938726e34d4', '', '');
> insert into song_tags ('id', 'covers', '2007') values ('8a172618-b121-4136-bb10-f665cfc469eb', '', '');
> 4. Select * from song_tags;
> Expected result:
> id,8a172618-b121-4136-bb10-f665cfc469eb | 2007, | covers,
> id,a3e64f8f-bd44-4f28-b8d9-6938726e34d4 | 1973, | blues,
> Actual result:
> none
--
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