public function testFiltersWithoutWhere()
{
$baseCommand = new AdHocCommand("SELECT *\n\t\t\t\t\t\tFROM users\n\t\t\t\t\t\tGROUP BY 1, 2 ORDER BY 3, 4");
$filter = new SqlFilterLike("fname", 'firstname');
$filter->_And(new SqlFilterEquals("lname", 'last'));
$filterCommand = new FilterCommand($baseCommand, $filter);
$constraint = $this->stringContains("WHERE fname LIKE @fname AND ( lname = @lname ) GROUP BY 1, 2 ORDER BY 3, 4");
$query = $filterCommand->GetQuery();
$this->assertThat($query, $constraint, $query);
}
