Scripts with CAST are treated like they should be CONVERT
As an example, I have this script:
<div>CREATE TABLE [dbo].[tblCastConvertTest]<br>(<br> [Id] INT NOT NULL IDENTITY(1,1)<br> ,[IsIncluded] BIT NOT NULL DEFAULT 1<br> ,[IsExcluded] AS CASE<br> WHEN [IsIncluded]=0 THEN CAST(1 AS BIT)<br> ELSE CAST(0 AS BIT)<br> END<br> ,CONSTRAINT [PK_tblCastConvertTest] PRIMARY KEY CLUSTERED ([Id])<br>)<br>GO<br></div>
After I execute it on the database and run a comparison, its showing a false positive difference:
Any ideas on why this is happening?
0 · Share on Twitter