public void CheckFunctionInSelectStatementIsNotSuspected() { const string sql = @"select sum(f1) from tbl1"; var visitor = new FunctionCallsInWhereClauseVisitor(); RunTSqlFragmentVisitor.AnalyzeFragmentVisitorBase(sql, sql.ComputeHash(), visitor); Assert.IsFalse(visitor.IsSuspected); }
public void CheckHasUpperFunction() { const string sql = @"select sum(f1) from tbl1 where upper(f2)='TEST'"; var visitor = new FunctionCallsInWhereClauseVisitor(); RunTSqlFragmentVisitor.AnalyzeFragmentVisitorBase(sql, sql.ComputeHash(), visitor); Assert.IsTrue(visitor.IsSuspected); }
public void CheckFunctionAsValueIsNotSuspected() { const string sql = @"SELECT [Id] FROM [dbo].[Products] WHERE @@ROWCOUNT > 0 AND [Id] = scope_identity()"; var visitor = new FunctionCallsInWhereClauseVisitor(); RunTSqlFragmentVisitor.AnalyzeFragmentVisitorBase(sql, sql.ComputeHash(), visitor); Assert.IsFalse(visitor.IsSuspected); }
public void CheckHasUpperFunctionWithParenthesis() { const string sql = @"SELECT TOP (1) [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name], [Extent1].[Price] AS [Price], [Extent1].[CategoryId] AS [CategoryId] FROM [dbo].[Products] AS [Extent1] WHERE ((UPPER([Extent1].[Name])) = (UPPER('Test'))) OR ((UPPER([Extent1].[Name]) IS NULL) AND (UPPER('Test') IS NULL))"; var visitor = new FunctionCallsInWhereClauseVisitor(); RunTSqlFragmentVisitor.AnalyzeFragmentVisitorBase(sql, sql.ComputeHash(), visitor); Assert.IsTrue(visitor.IsSuspected); }