[ 
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]

Reply via email to