[
https://issues.apache.org/jira/browse/CASSANDRA-15814?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17161294#comment-17161294
]
Andres de la Peña commented on CASSANDRA-15814:
-----------------------------------------------
[~Bereng] I'm adding the requested additional tests to the PR for 2.2, and also
some additional tests for the related already existing tests that aren't
verifying every collection type. If they look good to you I'll merge them up to
the other PRs and run CI for them.
The CircleCI run for the updated 2.2 PR is
[here|https://app.circleci.com/pipelines/github/adelapena/cassandra/66/workflows/8314df8a-ebf4-4ba1-95ce-2e85aedb3851].
> 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
> Components: CQL/Interpreter
> Reporter: Felipe Perez
> Assignee: Andres de la Peña
> Priority: Normal
> Time Spent: 1.5h
> Remaining Estimate: 0h
>
> 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: [email protected]
For additional commands, e-mail: [email protected]
