[
https://issues.apache.org/jira/browse/CASSANDRA-19889?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17883781#comment-17883781
]
Stefan Miklosovic commented on CASSANDRA-19889:
-----------------------------------------------
This is 4.1, for j11_dtests I just executed them again here
https://app.circleci.com/pipelines/github/instaclustr/cassandra/4770/workflows/ed52930c-dc90-4764-86fc-b86035c24667/jobs/278867/tests
I think CircleCI just had a bad day for 4.1 otherwise all good.
[CASSANDRA-19889-4.1|https://github.com/instaclustr/cassandra/tree/CASSANDRA-19889-4.1]
{noformat}
java11_pre-commit_tests
✓ j11_build 2m 0s
✓ j11_cqlsh_dtests_py3 5m 33s
✓ j11_cqlsh_dtests_py311 5m 53s
✓ j11_cqlsh_dtests_py311_vnode 5m 55s
✓ j11_cqlsh_dtests_py38 5m 38s
✓ j11_cqlsh_dtests_py38_vnode 6m 1s
✓ j11_cqlsh_dtests_py3_vnode 5m 45s
✓ j11_cqlshlib_cython_tests 10m 12s
✓ j11_cqlshlib_tests 6m 21s
✓ j11_jvm_dtests 17m 45s
✓ j11_jvm_dtests_vnode 16m 29s
✓ j11_unit_tests 8m 28s
✕ j11_dtests 36m 18s
sstable_generation_loading_test.TestSSTableGenerationAndLoading
test_sstableloader_uppercase_keyspace_name
transient_replication_ring_test.TestTransientReplicationRing
test_move_backwards_between_and_cleanup
transient_replication_test.TestTransientReplicationRepairStreamEntireSSTable
test_primary_range_repair
transient_replication_test.TestTransientReplicationRepairStreamEntireSSTable
test_transient_incremental_repair
ttl_test.TestTTL test_update_column_ttl_with_default_ttl
wide_rows_test.TestWideRows test_wide_rows
largecolumn_test.TestLargeColumn test_cleanup
replica_side_filtering_test.TestSecondaryIndexes
test_update_on_static_column_with_empty_partition
secondary_indexes_test.TestSecondaryIndexes test_6924_dropping_cf
snapshot_test.TestArchiveCommitlog
test_archive_commitlog_restore_skip_by_position
transient_replication_ring_test.TestTransientReplicationRing
test_bootstrap_and_cleanup
transient_replication_test.TestTransientReplicationRepairStreamEntireSSTable
test_full_repair_from_transient_replica
user_types_test.TestUserTypes test_type_keyspace_permission_isolation
✕ j11_dtests_vnode 35m 31s
largecolumn_test.TestLargeColumn test_cleanup
java11_separate_tests
✓ j11_build 2m 2s
✕ j11_dtests 34m 43s
largecolumn_test.TestLargeColumn test_cleanup
java8_pre-commit_tests
java8_separate_tests
{noformat}
[java11_pre-commit_tests|https://app.circleci.com/pipelines/github/instaclustr/cassandra/4770/workflows/0aa77b86-dc5e-467c-b6f9-5549b8ce8c65]
[java11_separate_tests|https://app.circleci.com/pipelines/github/instaclustr/cassandra/4770/workflows/ed52930c-dc90-4764-86fc-b86035c24667]
[java8_pre-commit_tests|https://app.circleci.com/pipelines/github/instaclustr/cassandra/4770/workflows/b764cdff-5394-4341-91d8-c94a8317ae22]
[java8_separate_tests|https://app.circleci.com/pipelines/github/instaclustr/cassandra/4770/workflows/e8808312-0bcd-4ef6-986d-8ca5d318aac6]
> 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]
