public void CheckSelectSumWithParenthesisIsSuspectedToArithmeticOverflow() { const string sql = @"select (sum((f1))) from tbl1;"; var visitor = new ArithmeticOverflowVisitor(); RunTSqlFragmentVisitor.AnalyzeFragmentVisitorBase(sql, sql.ComputeHash(), visitor); Assert.IsTrue(visitor.IsSuspected); }
public void CheckSelectCountIsNotSuspectedToArithmeticOverflow() { const string sql = @"SELECT [GroupBy1].[A1] AS [C1] FROM (SELECT COUNT(1) AS [A1] FROM [dbo].[__MigrationHistory] AS [Extent1] WHERE [Extent1].[ContextKey] = @p__linq__0) AS [GroupBy1];"; var visitor = new ArithmeticOverflowVisitor(); RunTSqlFragmentVisitor.AnalyzeFragmentVisitorBase(sql, sql.ComputeHash(), visitor); Assert.IsFalse(visitor.IsSuspected); }
public void CheckSelectSumCastAsBigIntIsNotSuspectedToArithmeticOverflow() { const string sql = @"SELECT [GroupBy1].[A1] AS [C1] FROM ( SELECT SUM( CAST( [Extent1].[Amount] AS bigint)) AS [A1] FROM [dbo].[Transactions] AS [Extent1] ) AS [GroupBy1]"; var visitor = new ArithmeticOverflowVisitor(); RunTSqlFragmentVisitor.AnalyzeFragmentVisitorBase(sql, sql.ComputeHash(), visitor); Assert.IsFalse(visitor.IsSuspected); }