You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Felipe Perez (Jira)" <ji...@apache.org> on 2020/05/15 04:32:00 UTC
[jira] [Created] (CASSANDRA-15814) order by descending on frozen
list not working
Felipe Perez created CASSANDRA-15814:
----------------------------------------
Summary: order by descending on frozen list not working
Key: CASSANDRA-15814
URL: https://issues.apache.org/jira/browse/CASSANDRA-15814
Project: Cassandra
Issue Type: Bug
Reporter: Felipe Perez
By creating a table like the following:
{code:java}
CREATE TABLE IF NOT EXISTS software (
name ascii,
version frozen<list<int>>,
data ascii,
PRIMARY KEY(name,version)
)
{code}
It works and version is ordered in an ascending order. But when trying to order in descending order:
{code:java}
CREATE TABLE IF NOT EXISTS software (
name ascii,
version frozen<list<int>>,
data ascii,
PRIMARY KEY(name,version)
) WITH CLUSTERING ORDER BY (version DESC);
{code}
The table is created normally, but when trying to insert a row:
{code:java}
insert into software(name, version) values ('t1', [2,10,30,40,50]);
{code}
Cassandra throws an error:
{code:java}
InvalidRequest: Error from server: code=2200 [Invalid query] message="Invalid list literal for version of type frozen<list<int>>"
{code}
The goal here is that I would like to get the last version of a software.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org