Nonclustered columnstore index on indexed view not generated correctly in SQLPrompt

Tomo1

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

Just an update, we tested with newer versions and the issue still persists.

SQL Prompt: 10.14.11.7894
SSMS: 20.0.70.0

JoshH

Hello, 

Could you provide the steps you took in SQL Prompt so I can attempt to recreate the issue on my side? 

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.

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