SYSNAME - system-defined data type in Azure SQL Server

[AnielaN994]

Hello,

We have in our schema the system-defined data type SYSNAME used in some maintenance tables and procs and while applying the schema.sql with schema apply, for a database works but for another one we receive: Error: analyzing plan: unsupported type *mssql.SysNameType, not sure why.

Is the SYSNAME supported by atlas ?

Thanks.

[AnielaN994]

I replicated this with below:

create schema logtest;
go

CREATE TABLE logtest.[ERR_FNR](
[Key] [int] NULL,
[ColumnName] [sysname] NOT NULL
) ON [PRIMARY]
GO

Applying the schema in DB1, it works:

while in the other DB2 it fails:

[giautm]

Hello @AnielaN994, I was unable to reproduce this issue, can you share more detail about DB2, like what version of it?

CREATE TABLE [ERR_FNR](
  [Key] [int] NULL,
  [ColumnName] [sysname] NOT NULL
) ON [PRIMARY];

atlas schema apply --to=file://schema.sql --url=docker://sqlserver/2022-latest --dev-url=docker://sqlserver/2022-latest --auto-approve