mssql: table partition support

[AnielaN994]

Hello,

We have tables partitioned by scheme that I've understood they'll be supported by atlas in feature releases and for some of those partitioned by scheme tables, there is no Primary key created. Hence there is a default heap entry in sys.indexes that has the name NULL.

Due to this, at atlas schema inspect, "Error: mssql: sql: Scan error on column index 2, name "index_name": converting NULL to string is unsupported" is returned. When I create myself the PK on the table, the error is no more encountered.

When the migration is done with flyway, the error is not encountered from the default heap entry in sys.indexes.

Is there any solution for this ?

Many Thanks.

[giautm]

Hello, can you please share the SQL that create the table?

[AnielaN994]

CREATE TABLE [test].[exec_log](
[partition_key] [int] NOT NULL,
[host_name] nvarchar NOT NULL,
[error_msg] nvarchar NOT NULL
) ON psLog -- psLog is the partition scheme
GO

[giautm]

Sorry, also the create schema script. I need the sql to preproduce the issue

[AnielaN994]

`CREATE PARTITION FUNCTION pfLog AS RANGE RIGHT FOR VALUES (20220101, 99999999)
GO
CREATE PARTITION SCHEME [psLog] AS PARTITION [pfLog] TO ([PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY])
GO

CREATE TABLE [test].[exec_log](
[partition_key] [int] NOT NULL,
[host_name] nvarchar NOT NULL,
[error_msg] nvarchar NOT NULL
) ON psLog
GO `

[giautm]

Hello @AnielaN994, we will exclude the partitioned tables from inspect result. In the meanwhile, please use the exclude flag to ignore this table.

[AnielaN994]

Hello. It's not only this tables, we have more tables like this and we want their definition to be in the generated schema.sql via inspect in order to execute the script on other databases and for the moment we can exclude the partition schemes until they will be supported but we cannot exclude the tables themselves.