Static data incorrectly identified as different

andrewjones

I create a table and commit both the table and static data using source control 4.1.81.41 standard.

After commit, source control continues to inform me one row is different between source control and my database.

To re-produce: -

SET ANSI_NULLS ON;
SET QUOTED_IDENTIFIER ON;
SET ANSI_PADDING ON;
SET NOCOUNT ON;

IF EXISTS ( SELECT  1
            FROM    sys.tables
            WHERE   [object_id] = OBJECT_ID(N'dbo.ThisIsATestTable') )
    BEGIN;
        DROP TABLE dbo.ThisIsATestTable;
    END;

CREATE TABLE dbo.ThisIsATestTable
    (
      [Category] [NVARCHAR](64) COLLATE SQL_Latin1_General_CP1_CI_AS
                                NOT NULL ,
      Age TINYINT NOT NULL ,
      CONSTRAINT PK_ThisIsATestTable PRIMARY KEY ( [Category] )
    );

INSERT  INTO dbo.ThisIsATestTable
VALUES  ( N'X – Y', 3 ), -- note the delimiter here is ascii code 150 "En dash"
        ( N'X - Y Z', 7 ); -- note the delimiter here is ascii code 45 "Hyphen"

Post commit, the row where Category = N'X - Y Z' will always be identified as different so my source control always appears out of date. After clicking the commit button, I get an error saying there is nothing to commit.

How do I fix this please?

Many thanks, Andy Jones.

Sergio R

Hi Andrew,

I am afraid that this appears to be caused by a bug, which we are investigating at the moment.

We have opened a support ticket for this issue and I will get back to you on that ticket soon.

Thank you,