public function testFiltersOnFK()
{
$query = new SQLSelect();
$query->setWhere("ID = 5");
$this->assertFalse($query->filtersOnFK(), "filtersOnFK() is true with simple unquoted column name");
$query = new SQLSelect();
$query->setWhere("Identifier = 5");
$this->assertFalse($query->filtersOnFK(), "filtersOnFK() is false with custom column name (starting with 'id')");
$query = new SQLSelect();
$query->setWhere("MyTable.ParentID = 5");
$this->assertTrue($query->filtersOnFK(), "filtersOnFK() is true with table and column name");
$query = new SQLSelect();
$query->setWhere("MyTable.`ParentID`= 5");
$this->assertTrue($query->filtersOnFK(), "filtersOnFK() is true with table and quoted column name ");
}
