How can we help you today? How can we help you today?

Nonclustered columnstore index on indexed view not generated correctly in SQLPrompt

Hey!
I created a table with clustered rowstore and nonclustered columnstore indexes. After that, I created an indexed view on top of that table.

Then I created a nonclustered columnstore index on that indexed view. The issue is that SQL Prompt is not generating nonclustered columnstore index on top of indexed view correctly. Instead of it being generated like this:

CREATE NONCLUSTERED COLUMNSTORE INDEX [CSIDX_mv_indexed_view] ON [schema].[mv_indexed_view] (ColumnList) ON [partSchema] ([partColumn])
GO

It is being generated like this:

CREATE NONCLUSTERED INDEX [CSIDX_mv_indexed_view] ON [schema].[mv_indexed_view]) INCLUDE (ColumnList) ON [partSchema] ([partColumn])

Additional note is that SQL Compare is generating the code correctly.

EDIT: Versions
SQL Prompt: 10.14.10.7538
SQL Compare: 15.3.0.25068
SSMS: 19.3
Tomo1
0

Comments

4 comments

Sort by
  • Tomo1
    Just an update, we tested with newer versions and the issue still persists.

    SQL Prompt: 10.14.11.7894
    SSMS: 20.0.70.0
    Tomo1
    0
  • JoshH
    Hello, 

    Could you provide the steps you took in SQL Prompt so I can attempt to recreate the issue on my side?
    JoshH
    0
  • Tomo1
    Hey, 

    after creating the objects as mentioned in the first post, you just generate the DDL by pressing F12 or mouseover popup that shows the DDL script.
    Tomo1
    0
  • JoshH
    That issue was solved in this release. Give it a try. https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.14.22.11347.exe
    JoshH
    0

Add comment

Please sign in to leave a comment.