cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Stavros Kontopoulos (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (CASSANDRA-13717) INSERT statement fails when Tuple type is used as clustering column with default DESC order
Date Thu, 10 Aug 2017 01:46:00 GMT

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

Stavros Kontopoulos edited comment on CASSANDRA-13717 at 8/10/17 1:45 AM:
--------------------------------------------------------------------------

I have created a patch and verified Jeff's suggestion:
[patch|https://drive.google.com/open?id=0B0SeiqgJaLZvclhmY0N4dEJtUGs]

{noformat}
cqlsh> create keyspace test with replication = {'class':'SimpleStrategy','replication_factor':
1};cqlsh> create table test.test_table ( id int, tdemo tuple<timestamp, varchar>,
primary key (id, tdemo) ) with clustering order by (tdemo desc);
cqlsh> insert into test.test_table (id, tdemo) values (1, ('2017-02-03 03:05+0000','Europe'));
cqlsh> select * from test.test_table;
 id | tdemo
----+-----------------------------------------------
  1 | ('2017-02-03 03:05:00.000000+0000', 'Europe')

(1 rows)

{noformat}




was (Author: skonto):
I have created a patch and verified Jeff's suggestion:
[patch|https://drive.google.com/open?id=0B0SeiqgJaLZvclhmY0N4dEJtUGs]


> INSERT statement fails when Tuple type is used as clustering column with default DESC
order
> -------------------------------------------------------------------------------------------
>
>                 Key: CASSANDRA-13717
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-13717
>             Project: Cassandra
>          Issue Type: Bug
>         Environment: Cassandra 3.11
>            Reporter: Anastasios Kichidis
>         Attachments: example_queries.cql
>
>
> When a column family is created and a Tuple is used on clustering column with default
clustering order DESC, then the INSERT statement fails. 
> For example, the following table will make the INSERT statement fail with error message
"Invalid tuple type literal for tdemo of type frozen<tuple<timestamp, text>>"
, although the INSERT statement is correct (works as expected when the default order is ASC)
> {noformat}
> create table test_table (
> 	id int,
> 	tdemo tuple<timestamp, varchar>,
> 	primary key (id, tdemo)
> ) with clustering order by (tdemo desc);
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org


Mime
View raw message