Mailing-List: contact commits-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@cassandra.apache.org
Date: Thu, 10 Aug 2017 01:48:00 +0000 (UTC)
From: "Stavros Kontopoulos (JIRA)" <jira@apache.org>
To: commits@cassandra.apache.org
Message-ID: <JIRA.13089042.1500643710000.134060.1502329680116@Atlassian.JIRA>
In-Reply-To: <JIRA.13089042.1500643710000@Atlassian.JIRA>
References: <JIRA.13089042.1500643710000@Atlassian.JIRA> <JIRA.13089042.1500643710517@jira-lw-us.apache.org>
Subject: [jira] [Comment Edited] (CASSANDRA-13717) INSERT statement fails
 when Tuple type is used as clustering column with default DESC order
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Thu, 10 Aug 2017 01:48:06 -0000


    [ 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:47 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}

What are the next steps for the review (I am new here)?


was (Author: skonto):
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}


> 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