public function testFiltersOnID()
{
$query = new SQLSelect();
$query->setWhere("ID = 5");
$this->assertTrue($query->filtersOnID(), "filtersOnID() is true with simple unquoted column name");
$query = new SQLSelect();
$query->setWhere('"ID" = 5');
$this->assertTrue($query->filtersOnID(), "filtersOnID() is true with simple quoted column name");
$query = new SQLSelect();
$query->setWhere(array('"ID"' => 4));
$this->assertTrue($query->filtersOnID(), "filtersOnID() is true with parameterised quoted column name");
$query = new SQLSelect();
$query->setWhere(array('"ID" = ?' => 4));
$this->assertTrue($query->filtersOnID(), "filtersOnID() is true with parameterised quoted column name");
$query = new SQLSelect();
$query->setWhere('"ID" IN (5,4)');
$this->assertTrue($query->filtersOnID(), "filtersOnID() is true with WHERE ID IN");
$query = new SQLSelect();
$query->setWhere(array('"ID" IN ?' => array(1, 2)));
$this->assertTrue($query->filtersOnID(), "filtersOnID() is true with parameterised WHERE ID IN");
$query = new SQLSelect();
$query->setWhere("ID=5");
$this->assertTrue($query->filtersOnID(), "filtersOnID() is true with simple unquoted column name and no spaces in equals sign");
$query = new SQLSelect();
$query->setWhere("Identifier = 5");
$this->assertFalse($query->filtersOnID(), "filtersOnID() is false with custom column name (starting with 'id')");
$query = new SQLSelect();
$query->setWhere("ParentID = 5");
$this->assertFalse($query->filtersOnID(), "filtersOnID() is false with column name ending in 'ID'");
$query = new SQLSelect();
$query->setWhere("MyTable.ID = 5");
$this->assertTrue($query->filtersOnID(), "filtersOnID() is true with table and column name");
$query = new SQLSelect();
$query->setWhere("MyTable.ID = 5");
$this->assertTrue($query->filtersOnID(), "filtersOnID() is true with table and quoted column name ");
}
