[
https://issues.apache.org/jira/browse/CASSANDRA-15814?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17162896#comment-17162896
]
Andres de la Peña commented on CASSANDRA-15814:
-----------------------------------------------
bq. 3.11 utest is failing SASIIndexTests which on cassandra ci are solid as a
rock. I'd run those locally a few times before merging to confim
[~Bereng] All those tests have some failure in
[ci-cassandra|https://ci-cassandra.apache.org/job/Cassandra-3.11/75/testReport/org.apache.cassandra.index.sasi/SASIIndexTest/],
although it only has the 11 more recent runs.
I'm running the test multiplexer for {{SASIIndexTest}} at cassandra-3.11 and
15814-3.11:
||branch||run1||run2||
|cassandra-3.11|[664|https://jenkins-cassandra.datastax.lan/job/parameterized-testall/664/]|[666|https://jenkins-cassandra.datastax.lan/job/parameterized-testall/666/]|
|15814-3.11|[665|https://jenkins-cassandra.datastax.lan/job/parameterized-testall/665/]|[667|https://jenkins-cassandra.datastax.lan/job/parameterized-testall/667/]|
For the first pair of runs I've seen that the following tests fail in both
branches:
* testIndexMemtableSwitching
* testPagination
* testIndexRedistribution
However, {{testTruncate}} only fails in 15814-3.11. Since it only has failed 2
in 100 times, it's likely that we haven't seen it failing in cassandra-3.11 due
to it's relatively low flakiness, thereof the second round of multiplexer runs.
Also, none of the tables created in SASI tests uses collections, so everything
suggests that those tests failures are not related.
> 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: [email protected]
For additional commands, e-mail: [email protected]
