You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Tyler Patterson (Created) (JIRA)" <ji...@apache.org> on 2012/03/06 03:49:57 UTC

[jira] [Created] (CASSANDRA-4002) cqlsh: error when selecting on certain column families

cqlsh: error when selecting on certain column families
------------------------------------------------------

                 Key: CASSANDRA-4002
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-4002
             Project: Cassandra
          Issue Type: Bug
         Environment: ubuntu and osx
            Reporter: Tyler Patterson


Here are two examples that produce the error:

{code}
CREATE COLUMNFAMILY cf8 (KEY text PRIMARY KEY) WITH default_validation=uuid AND comparator=uuid;
INSERT INTO cf8 (KEY, '2097887f-53b2-4b89-bfb4-09fea6980d40', 'c3e990b5-238c-46f1-8c88-0267f5a5c446') VALUES ('76616c7565305f30', '2097887f-53b2-4b89-bfb4-09fea6980d40', 'c3e990b5-238c-46f1-8c88-0267f5a5c446');
select * from cf7 where KEY='76616c7565305f30';
{code}

produces the error: cannot concatenate 'str' and 'bool' objects

{code}
CREATE COLUMNFAMILY cf_blob_bool (KEY blob PRIMARY KEY) WITH default_validation=boolean AND comparator=boolean;
INSERT INTO cf_blob_bool (KEY, 'True', 'False') VALUES ('76616c7565305f30', 'True', 'False');
select * from cf_blob_bool where KEY='76616c7565305f30';
{code}
produces the error: cannot concatenate 'str' and 'bool' objects

--
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-4002) cqlsh: error when selecting on certain column families

Posted by "Jonathan Ellis (Resolved) (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/CASSANDRA-4002?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jonathan Ellis resolved CASSANDRA-4002.
---------------------------------------

    Resolution: Duplicate
      Assignee:     (was: paul cannon)

closing as duplicate then
                
> cqlsh: error when selecting on certain column families
> ------------------------------------------------------
>
>                 Key: CASSANDRA-4002
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-4002
>             Project: Cassandra
>          Issue Type: Bug
>         Environment: ubuntu and osx
>            Reporter: Tyler Patterson
>
> Here are two examples that produce the error:
> {code}
> CREATE COLUMNFAMILY cf8 (KEY text PRIMARY KEY) WITH default_validation=uuid AND comparator=uuid;
> INSERT INTO cf8 (KEY, '2097887f-53b2-4b89-bfb4-09fea6980d40', 'c3e990b5-238c-46f1-8c88-0267f5a5c446') VALUES ('76616c7565305f30', '2097887f-53b2-4b89-bfb4-09fea6980d40', 'c3e990b5-238c-46f1-8c88-0267f5a5c446');
> select * from cf8 where KEY='76616c7565305f30';
> {code}
> produces the error: cannot concatenate 'str' and 'bool' objects
> {code}
> CREATE COLUMNFAMILY cf_blob_bool (KEY blob PRIMARY KEY) WITH default_validation=boolean AND comparator=boolean;
> INSERT INTO cf_blob_bool (KEY, 'True', 'False') VALUES ('76616c7565305f30', 'True', 'False');
> select * from cf_blob_bool where KEY='76616c7565305f30';
> {code}
> produces the error: cannot concatenate 'str' and 'bool' objects

--
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-4002) cqlsh: error when selecting on certain column families

Posted by "paul cannon (Assigned) (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/CASSANDRA-4002?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

paul cannon reassigned CASSANDRA-4002:
--------------------------------------

    Assignee: paul cannon
    
> cqlsh: error when selecting on certain column families
> ------------------------------------------------------
>
>                 Key: CASSANDRA-4002
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-4002
>             Project: Cassandra
>          Issue Type: Bug
>         Environment: ubuntu and osx
>            Reporter: Tyler Patterson
>            Assignee: paul cannon
>
> Here are two examples that produce the error:
> {code}
> CREATE COLUMNFAMILY cf8 (KEY text PRIMARY KEY) WITH default_validation=uuid AND comparator=uuid;
> INSERT INTO cf8 (KEY, '2097887f-53b2-4b89-bfb4-09fea6980d40', 'c3e990b5-238c-46f1-8c88-0267f5a5c446') VALUES ('76616c7565305f30', '2097887f-53b2-4b89-bfb4-09fea6980d40', 'c3e990b5-238c-46f1-8c88-0267f5a5c446');
> select * from cf7 where KEY='76616c7565305f30';
> {code}
> produces the error: cannot concatenate 'str' and 'bool' objects
> {code}
> CREATE COLUMNFAMILY cf_blob_bool (KEY blob PRIMARY KEY) WITH default_validation=boolean AND comparator=boolean;
> INSERT INTO cf_blob_bool (KEY, 'True', 'False') VALUES ('76616c7565305f30', 'True', 'False');
> select * from cf_blob_bool where KEY='76616c7565305f30';
> {code}
> produces the error: cannot concatenate 'str' and 'bool' objects

--
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-4002) cqlsh: error when selecting on certain column families

Posted by "Tyler Patterson (Commented) (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/CASSANDRA-4002?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13224564#comment-13224564 ] 

Tyler Patterson commented on CASSANDRA-4002:
--------------------------------------------

The patch works for me.
                
> cqlsh: error when selecting on certain column families
> ------------------------------------------------------
>
>                 Key: CASSANDRA-4002
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-4002
>             Project: Cassandra
>          Issue Type: Bug
>         Environment: ubuntu and osx
>            Reporter: Tyler Patterson
>            Assignee: paul cannon
>
> Here are two examples that produce the error:
> {code}
> CREATE COLUMNFAMILY cf8 (KEY text PRIMARY KEY) WITH default_validation=uuid AND comparator=uuid;
> INSERT INTO cf8 (KEY, '2097887f-53b2-4b89-bfb4-09fea6980d40', 'c3e990b5-238c-46f1-8c88-0267f5a5c446') VALUES ('76616c7565305f30', '2097887f-53b2-4b89-bfb4-09fea6980d40', 'c3e990b5-238c-46f1-8c88-0267f5a5c446');
> select * from cf8 where KEY='76616c7565305f30';
> {code}
> produces the error: cannot concatenate 'str' and 'bool' objects
> {code}
> CREATE COLUMNFAMILY cf_blob_bool (KEY blob PRIMARY KEY) WITH default_validation=boolean AND comparator=boolean;
> INSERT INTO cf_blob_bool (KEY, 'True', 'False') VALUES ('76616c7565305f30', 'True', 'False');
> select * from cf_blob_bool where KEY='76616c7565305f30';
> {code}
> produces the error: cannot concatenate 'str' and 'bool' objects

--
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-4002) cqlsh: error when selecting on certain column families

Posted by "Tyler Patterson (Commented) (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/CASSANDRA-4002?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13222950#comment-13222950 ] 

Tyler Patterson commented on CASSANDRA-4002:
--------------------------------------------

I get the same error when the key is of type decimal, and the comparator and default_validation are both of type int.
                
> cqlsh: error when selecting on certain column families
> ------------------------------------------------------
>
>                 Key: CASSANDRA-4002
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-4002
>             Project: Cassandra
>          Issue Type: Bug
>         Environment: ubuntu and osx
>            Reporter: Tyler Patterson
>
> Here are two examples that produce the error:
> {code}
> CREATE COLUMNFAMILY cf8 (KEY text PRIMARY KEY) WITH default_validation=uuid AND comparator=uuid;
> INSERT INTO cf8 (KEY, '2097887f-53b2-4b89-bfb4-09fea6980d40', 'c3e990b5-238c-46f1-8c88-0267f5a5c446') VALUES ('76616c7565305f30', '2097887f-53b2-4b89-bfb4-09fea6980d40', 'c3e990b5-238c-46f1-8c88-0267f5a5c446');
> select * from cf7 where KEY='76616c7565305f30';
> {code}
> produces the error: cannot concatenate 'str' and 'bool' objects
> {code}
> CREATE COLUMNFAMILY cf_blob_bool (KEY blob PRIMARY KEY) WITH default_validation=boolean AND comparator=boolean;
> INSERT INTO cf_blob_bool (KEY, 'True', 'False') VALUES ('76616c7565305f30', 'True', 'False');
> select * from cf_blob_bool where KEY='76616c7565305f30';
> {code}
> produces the error: cannot concatenate 'str' and 'bool' objects

--
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-4002) cqlsh: error when selecting on certain column families

Posted by "paul cannon (Commented) (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/CASSANDRA-4002?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13223875#comment-13223875 ] 

paul cannon commented on CASSANDRA-4002:
----------------------------------------

Tyler- could you try out the patch at CASSANDRA-4003? While these are technically different issues, the fix there was wide enough that it should fix this as well.
                
> cqlsh: error when selecting on certain column families
> ------------------------------------------------------
>
>                 Key: CASSANDRA-4002
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-4002
>             Project: Cassandra
>          Issue Type: Bug
>         Environment: ubuntu and osx
>            Reporter: Tyler Patterson
>            Assignee: paul cannon
>
> Here are two examples that produce the error:
> {code}
> CREATE COLUMNFAMILY cf8 (KEY text PRIMARY KEY) WITH default_validation=uuid AND comparator=uuid;
> INSERT INTO cf8 (KEY, '2097887f-53b2-4b89-bfb4-09fea6980d40', 'c3e990b5-238c-46f1-8c88-0267f5a5c446') VALUES ('76616c7565305f30', '2097887f-53b2-4b89-bfb4-09fea6980d40', 'c3e990b5-238c-46f1-8c88-0267f5a5c446');
> select * from cf7 where KEY='76616c7565305f30';
> {code}
> produces the error: cannot concatenate 'str' and 'bool' objects
> {code}
> CREATE COLUMNFAMILY cf_blob_bool (KEY blob PRIMARY KEY) WITH default_validation=boolean AND comparator=boolean;
> INSERT INTO cf_blob_bool (KEY, 'True', 'False') VALUES ('76616c7565305f30', 'True', 'False');
> select * from cf_blob_bool where KEY='76616c7565305f30';
> {code}
> produces the error: cannot concatenate 'str' and 'bool' objects

--
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] [Updated] (CASSANDRA-4002) cqlsh: error when selecting on certain column families

Posted by "Tyler Patterson (Updated) (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/CASSANDRA-4002?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Tyler Patterson updated CASSANDRA-4002:
---------------------------------------

    Description: 
Here are two examples that produce the error:

{code}
CREATE COLUMNFAMILY cf8 (KEY text PRIMARY KEY) WITH default_validation=uuid AND comparator=uuid;
INSERT INTO cf8 (KEY, '2097887f-53b2-4b89-bfb4-09fea6980d40', 'c3e990b5-238c-46f1-8c88-0267f5a5c446') VALUES ('76616c7565305f30', '2097887f-53b2-4b89-bfb4-09fea6980d40', 'c3e990b5-238c-46f1-8c88-0267f5a5c446');
select * from cf8 where KEY='76616c7565305f30';
{code}

produces the error: cannot concatenate 'str' and 'bool' objects

{code}
CREATE COLUMNFAMILY cf_blob_bool (KEY blob PRIMARY KEY) WITH default_validation=boolean AND comparator=boolean;
INSERT INTO cf_blob_bool (KEY, 'True', 'False') VALUES ('76616c7565305f30', 'True', 'False');
select * from cf_blob_bool where KEY='76616c7565305f30';
{code}
produces the error: cannot concatenate 'str' and 'bool' objects

  was:
Here are two examples that produce the error:

{code}
CREATE COLUMNFAMILY cf8 (KEY text PRIMARY KEY) WITH default_validation=uuid AND comparator=uuid;
INSERT INTO cf8 (KEY, '2097887f-53b2-4b89-bfb4-09fea6980d40', 'c3e990b5-238c-46f1-8c88-0267f5a5c446') VALUES ('76616c7565305f30', '2097887f-53b2-4b89-bfb4-09fea6980d40', 'c3e990b5-238c-46f1-8c88-0267f5a5c446');
select * from cf7 where KEY='76616c7565305f30';
{code}

produces the error: cannot concatenate 'str' and 'bool' objects

{code}
CREATE COLUMNFAMILY cf_blob_bool (KEY blob PRIMARY KEY) WITH default_validation=boolean AND comparator=boolean;
INSERT INTO cf_blob_bool (KEY, 'True', 'False') VALUES ('76616c7565305f30', 'True', 'False');
select * from cf_blob_bool where KEY='76616c7565305f30';
{code}
produces the error: cannot concatenate 'str' and 'bool' objects

    
> cqlsh: error when selecting on certain column families
> ------------------------------------------------------
>
>                 Key: CASSANDRA-4002
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-4002
>             Project: Cassandra
>          Issue Type: Bug
>         Environment: ubuntu and osx
>            Reporter: Tyler Patterson
>            Assignee: paul cannon
>
> Here are two examples that produce the error:
> {code}
> CREATE COLUMNFAMILY cf8 (KEY text PRIMARY KEY) WITH default_validation=uuid AND comparator=uuid;
> INSERT INTO cf8 (KEY, '2097887f-53b2-4b89-bfb4-09fea6980d40', 'c3e990b5-238c-46f1-8c88-0267f5a5c446') VALUES ('76616c7565305f30', '2097887f-53b2-4b89-bfb4-09fea6980d40', 'c3e990b5-238c-46f1-8c88-0267f5a5c446');
> select * from cf8 where KEY='76616c7565305f30';
> {code}
> produces the error: cannot concatenate 'str' and 'bool' objects
> {code}
> CREATE COLUMNFAMILY cf_blob_bool (KEY blob PRIMARY KEY) WITH default_validation=boolean AND comparator=boolean;
> INSERT INTO cf_blob_bool (KEY, 'True', 'False') VALUES ('76616c7565305f30', 'True', 'False');
> select * from cf_blob_bool where KEY='76616c7565305f30';
> {code}
> produces the error: cannot concatenate 'str' and 'bool' objects

--
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