[
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-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org
