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 "); }