Run the following script in SQL Server.
IF NOT EXISTS (select 'exists' from sys.partition_functions where name = 'TEST_PARTFUNC') CREATE PARTITION FUNCTION [TEST_PARTFUNC] (varchar(20)) AS RANGE LEFT FOR VALUES (N'ABCDE',N'ASDSAD',N'FGHIJ',N'HFSER',N'POSAW',N'RUZDAW') GO IF NOT EXISTS (select 'exists' from sys.partition_schemes where name = 'TEST_PARTSCHEME_INDEX') CREATE PARTITION SCHEME [TEST_PARTSCHEME_INDEX] AS PARTITION [TEST_PARTFUNC] TO ([PRIMARY],[PRIMARY],[PRIMARY],[PRIMARY],[PRIMARY],[PRIMARY],[PRIMARY]) GO CREATE TABLE dbo.TEST_TABLE ( STAGE_SOURCE VARCHAR(20) NOT NULL, ID INT NOT NULL, [COL1] VARCHAR(20) NOT NULL, [COL2] VARCHAR(20) NOT NULL ) GO CREATE NONCLUSTERED INDEX [TEST_INDEX] ON [dbo].[TEST_TABLE]([ID], [STAGE_SOURCE]) INCLUDE ([COL1], [COL2]) WITH ( FILLFACTOR = 100, DATA_COMPRESSION = PAGE ) ON [TEST_PARTSCHEME_INDEX] (STAGE_SOURCE) GO
In schema browser, select the index TEST_INDEX and choose Script Object -> CREATE. The following script is generated.
CREATE NONCLUSTERED INDEX [TEST_INDEX] ON [dbo].[TEST_TABLE]([ID], [STAGE_SOURCE]) INCLUDE ([COL1], [COL1], [COL1], [COL1], [COL1], [COL1], [COL1], [COL2], [COL2], [COL2], [COL2], [COL2], [COL2], [COL2]) GO
This is caused by va:#7022. The extraction query was updated and the DISTINCT clause was omitted if doing extraction for a given index name. The DISTINCT clause is now in the extraction query whether doing extraction for a given index or for all indexes.
Notes to QA: Please do regression testing on va:#7022.
Issue #15072 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build ADS 18.0.3-5 |
No time estimate |
This is caused by va:#7022. The extraction query was updated and the DISTINCT clause was omitted if doing extraction for a given index name. The DISTINCT clause is now in the extraction query whether doing extraction for a given index or for all indexes.
Notes to QA: Please do regression testing on va:#7022.