[
https://issues.apache.org/jira/browse/CASSANDRA-20365?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17929917#comment-17929917
]
Stefan Miklosovic commented on CASSANDRA-20365:
-----------------------------------------------
[CASSANDRA-20365|https://github.com/instaclustr/cassandra/tree/CASSANDRA-20365]
{noformat}
java17_pre-commit_tests
✓ j17_build 7m 0s
✓ j17_cqlsh_dtests_py311 7m 5s
✓ j17_cqlsh_dtests_py311_vnode 7m 46s
✓ j17_cqlsh_dtests_py38 6m 56s
✓ j17_cqlsh_dtests_py38_vnode 7m 5s
✓ j17_cqlshlib_cython_tests 8m 28s
✓ j17_cqlshlib_tests 10m 29s
✓ j17_dtests_latest 42m 1s
✓ j17_dtests_vnode 43m 18s
✓ j17_jvm_dtests_latest_vnode 25m 8s
✓ j17_unit_tests 14m 2s
✓ j17_unit_tests_repeat 9m 48s
✓ j17_utests_latest 14m 46s
✓ j17_utests_latest_repeat 8m 59s
✓ j17_utests_oa 15m 9s
✓ j17_utests_oa_repeat 9m 19s
✕ j17_dtests 36m 53s
refresh_test.TestRefresh test_refresh_deadlock_startup
✕ j17_jvm_dtests 27m 11s
org.apache.cassandra.fuzz.sai.MultiNodeSAITest indexOnlySaiTest TIMEOUTED
{noformat}
[java17_pre-commit_tests|https://app.circleci.com/pipelines/github/instaclustr/cassandra/5500/workflows/ea2bff25-3e39-4d2f-96ba-bc2982210610]
> DESCRIBE TABLE does not list materialized views
> -----------------------------------------------
>
> Key: CASSANDRA-20365
> URL: https://issues.apache.org/jira/browse/CASSANDRA-20365
> Project: Apache Cassandra
> Issue Type: Bug
> Components: Legacy/Core, Legacy/CQL
> Reporter: Nadav Har'El
> Assignee: Stefan Miklosovic
> Priority: Normal
> Fix For: 5.0.x, 5.x
>
> Time Spent: 10m
> Remaining Estimate: 0h
>
> I noticed that if I run DESCRIBE TABLE (the new server-side CQL command, not
> the old cqlsh command) on a table that has materialized views, I get back
> just {{CREATE TABLE}} command for the base table but no {{{}CREATE
> MATERIALIZED VIEW{}}}.
> I found this strange for several reasons:
> # Old cqlsh documentation such as
> [https://docs.datastax.com/en/cql/hcd/reference/cqlsh-commands/describe-table.html]
> suggested that DESCRIBE TABLE should return "executable CQL information for
> a single table, including materialized views that are based on the table".
> # Probably a user will want to recreate views when recreating a table.
> # On a table with secondary index, CREATE INDEX statements *are* included in
> the output of DESCRIBE TABLE. Why should indexes be listed and views not?
> Is any of this intentional? I couldn't find any CQL (not cqlsh) documentation
> explaining what DESCRIBE TABLE should return, or why.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]