Mailing-List: contact commits-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@cassandra.apache.org
Date: Sat, 29 Dec 2012 00:42:13 +0000 (UTC)
From: "Aleksey Yeschenko (JIRA)" <jira@apache.org>
To: commits@cassandra.apache.org
Message-ID: <JIRA.12617909.1354062484374.60381.1356741733551@arcas>
In-Reply-To: <JIRA.12617909.1354062484374@arcas>
References: <JIRA.12617909.1354062484374@arcas>
Subject: [jira] [Comment Edited] (CASSANDRA-4999) CQL2 returns empty results
 from song_tags
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ https://issues.apache.org/jira/browse/CASSANDRA-4999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13540677#comment-13540677 ] 

Aleksey Yeschenko edited comment on CASSANDRA-4999 at 12/29/12 12:41 AM:
-------------------------------------------------------------------------

Here is what I'm getting:

{quote}
cqlsh:test> select * from song_tags;

 id,a3e64f8f-bd44-4f28-b8d9-6938726e34d4 | 1973, | blues,
 id,8a172618-b121-4136-bb10-f665cfc469eb | 2007, | covers,
{quote}

branch: cassandra-1.2. I assume it was somehow fixed in one of the unrelated cqlsh patches, although I have no idea which one it was (assuming the problem was really in cqlsh that is).
                
      was (Author: iamaleksey):
    Here is what I'm getting:

{{monospaced}}
cqlsh:test> select * from song_tags;

 id,a3e64f8f-bd44-4f28-b8d9-6938726e34d4 | 1973, | blues,
 id,8a172618-b121-4136-bb10-f665cfc469eb | 2007, | covers,
{{monospaced}}

branch: cassandra-1.2. I assume it was somehow fixed in one of the unrelated cqlsh patches, although I have no idea which one it was (assuming the problem was really in cqlsh that is).
                  
> 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