public void CheckQueryWithoutWhereClauses() { const string sql = @"SELECT BusinessEntityID, FirstName, LastName FROM Testoffset"; var visitor = new UnboundedResultSetVisitor(); RunTSqlFragmentVisitor.AnalyzeFragmentVisitorBase(sql, sql.ComputeHash(), visitor); Assert.IsTrue(visitor.IsSuspected); }
public void CheckQueryHasTopKeyword() { const string sql = @"SELECT Top 3 BusinessEntityID, FirstName, LastName FROM Testoffset"; var visitor = new UnboundedResultSetVisitor(); RunTSqlFragmentVisitor.AnalyzeFragmentVisitorBase(sql, sql.ComputeHash(), visitor); Assert.IsFalse(visitor.IsSuspected); }
public void CheckQueryHasOffsetFetch() { const string sql = @"SELECT BusinessEntityID, FirstName, LastName FROM Testoffset ORDER BY BusinessEntityID OFFSET 3 ROWS FETCH First 3 ROWS only"; var visitor = new UnboundedResultSetVisitor(); RunTSqlFragmentVisitor.AnalyzeFragmentVisitorBase(sql, sql.ComputeHash(), visitor); Assert.IsFalse(visitor.IsSuspected); }