[
https://issues.apache.org/jira/browse/CASSANDRA-19889?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17883783#comment-17883783
]
Stefan Miklosovic commented on CASSANDRA-19889:
-----------------------------------------------
TestSecondaryIndexes is CASSANDRA-19938
[CASSANDRA-19889-trunk|https://github.com/instaclustr/cassandra/tree/CASSANDRA-19889-trunk]
{noformat}
java17_pre-commit_tests
✓ j17_build 4m 5s
✓ j17_cqlsh_dtests_py311 7m 4s
✓ j17_cqlsh_dtests_py311_vnode 7m 18s
✓ j17_cqlsh_dtests_py38 6m 42s
✓ j17_cqlsh_dtests_py38_vnode 7m 14s
✓ j17_cqlshlib_cython_tests 7m 31s
✓ j17_cqlshlib_tests 9m 6s
✓ j17_dtests 31m 55s
✓ j17_dtests_vnode 33m 32s
✓ j17_jvm_dtests 24m 40s
✓ j17_unit_tests 14m 15s
✓ j17_unit_tests_repeat 15m 48s
✓ j17_utests_latest_repeat 23m 32s
✓ j17_utests_oa 14m 12s
✓ j17_utests_oa_repeat 21m 12s
✕ j17_dtests_latest 44m 37s
replica_side_filtering_test.TestSecondaryIndexes
test_complementary_deletion_with_limit_on_clustering_key_column
replica_side_filtering_test.TestSecondaryIndexes
test_complementary_deletion_with_limit_on_partition_key_column_with_not_empty_partitions
bootstrap_test.TestBootstrap test_killed_wiped_node_cannot_join
✕ j17_jvm_dtests_latest_vnode 24m 41s
org.apache.cassandra.distributed.test.tcm.CMSPlacementAfterMoveTest
testMoveToCMS
✕ j17_utests_latest 14m 46s
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/4765/workflows/b907c0ca-42c3-468b-98d9-78419065a25f]
[java17_separate_tests|https://app.circleci.com/pipelines/github/instaclustr/cassandra/4765/workflows/1be6bb2a-d602-4a70-9845-49b627ee18f3]
[java11_pre-commit_tests|https://app.circleci.com/pipelines/github/instaclustr/cassandra/4765/workflows/10690b3a-4502-4c0b-bb9b-055d47aed0aa]
[java11_separate_tests|https://app.circleci.com/pipelines/github/instaclustr/cassandra/4765/workflows/2df0a9bb-57d9-4c4c-beb0-5591a724f641]
> 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]
