[ https://issues.apache.org/jira/browse/CASSANDRA-15814?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17162948#comment-17162948 ]
Andres de la Peña commented on CASSANDRA-15814: ----------------------------------------------- [~Bereng] The second run of the multiplexer has produced two failures in {{testTruncate}} for cassandra-3.11 and none for 15814-3.11, which is the opposite to the first run. That gives us a flakiness of 1% with and without the patch. With this and the lack of collections in the test I think it's safe to consider those failures unrelated, so I'd say we're ready to merge. > 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: 1h 40m > 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: commits-unsubscr...@cassandra.apache.org For additional commands, e-mail: commits-h...@cassandra.apache.org