Skip to content

tSQLt.AssertEqualsTableSchema does not work with #temp tables #119

Open
@lizbaron

Description

@lizbaron

If you try the following, it will always pass.

CREATE TABLE #Actual(
    Id INT PRIMARY KEY,
    NoKey INT NULL
  );
  CREATE TABLE #Expected(
    Id BIT PRIMARY KEY,
    NoKey NVARCHAR(MAX) NULL
  );
  EXEC tSQLt.AssertEqualsTableSchema @Expected = '#Expected'. @Actual = '#Actual';

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions