[
https://issues.apache.org/jira/browse/CASSANDRA-19889?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17883782#comment-17883782
]
Stefan Miklosovic commented on CASSANDRA-19889:
-----------------------------------------------
5.0, nothing which fails there fails locally.
[CASSANDRA-19889-5.0|https://github.com/instaclustr/cassandra/tree/CASSANDRA-19889-5.0]
{noformat}
java17_pre-commit_tests
✓ j17_build 4m 29s
✓ j17_cqlsh_dtests_py311 6m 35s
✓ j17_cqlsh_dtests_py311_vnode 7m 14s
✓ j17_cqlsh_dtests_py38 5m 47s
✓ j17_cqlsh_dtests_py38_vnode 6m 11s
✓ j17_cqlshlib_cython_tests 7m 22s
✓ j17_cqlshlib_tests 6m 33s
✓ j17_dtests 31m 42s
✓ j17_dtests_latest 32m 59s
✓ j17_jvm_dtests 22m 9s
✓ j17_jvm_dtests_latest_vnode 18m 1s
✓ j17_unit_tests 16m 18s
✓ j17_unit_tests_repeat 16m 38s
✓ j17_utests_latest_repeat 20m 27s
✓ j17_utests_oa 13m 58s
✓ j17_utests_oa_repeat 19m 49s
✕ j17_dtests_vnode 32m 51s
bootstrap_test.TestBootstrap test_read_from_bootstrapped_node
bootstrap_test.TestBootstrap test_shutdown_wiped_node_cannot_join
✕ j17_utests_latest 15m 29s
org.apache.cassandra.db.compaction.CompactionStrategyManagerPendingRepairTest
testFinalizedAndCompactionRace
java17_separate_tests
java11_pre-commit_tests
java11_separate_tests
{noformat}
[java17_pre-commit_tests|https://app.circleci.com/pipelines/github/instaclustr/cassandra/4768/workflows/2a7a154a-51fe-4a54-9609-7604a731f480]
[java17_separate_tests|https://app.circleci.com/pipelines/github/instaclustr/cassandra/4768/workflows/3a59e441-4101-4567-92e5-097a5f61a388]
[java11_pre-commit_tests|https://app.circleci.com/pipelines/github/instaclustr/cassandra/4768/workflows/18ff3c2e-f82f-4287-a89e-a265b3bda1bc]
[java11_separate_tests|https://app.circleci.com/pipelines/github/instaclustr/cassandra/4768/workflows/9ac2e887-5ff1-4b46-8447-5e29f4d16f78]
> Indexing a frozen collection that is the clustering key and reversed is
> rejected
> --------------------------------------------------------------------------------
>
> Key: CASSANDRA-19889
> URL: https://issues.apache.org/jira/browse/CASSANDRA-19889
> Project: Cassandra
> Issue Type: Bug
> Components: CQL/Interpreter
> Reporter: David Capwell
> Assignee: Sunil Ramchandra Pawar
> Priority: Normal
> Fix For: 4.0.x, 4.1.x, 5.0.x, 5.x
>
> Time Spent: 50m
> Remaining Estimate: 0h
>
> {code}
> CREATE TABLE tbl (
> pk int,
> ck frozen<list<int>>,
> value int,
> PRIMARY KEY(pk, ck)
> )
> WITH CLUSTERING ORDER BY (ck DESC)
> {code}
> If you index “ck” it will fail
> {code}
> CREATE INDEX ON tbl(FULL(ck));
> {code}
> The failure error is
> {code}
> Caused by: org.apache.cassandra.exceptions.InvalidRequestException: full()
> indexes can only be created on frozen collections
> at
> org.apache.cassandra.cql3.statements.schema.AlterSchemaStatement.ire(AlterSchemaStatement.java:222)
> at
> org.apache.cassandra.cql3.statements.schema.CreateIndexStatement.validateIndexTarget(CreateIndexStatement.java:250)
> at
> org.apache.cassandra.cql3.statements.schema.CreateIndexStatement.lambda$apply$1(CreateIndexStatement.java:177)
> {code}
> The reason? We have a ReverseType column! We must “unwrap” the type before
> this check...
> Basic test
> {code}
> schemaChange(format("CREATE TABLE %s.tbl (\n" +
> " pk int,\n" +
> " ck frozen<list<int>>,\n" +
> " value int,\n" +
> " PRIMARY KEY(pk, ck)\n" +
> ")\n" +
> "WITH CLUSTERING ORDER BY (ck DESC)", KEYSPACE));
> schemaChange(format("CREATE INDEX ON %s.tbl(FULL(ck));", KEYSPACE));
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
