public function testIncludeExcludeMixedDataSet()
{
$constraint = new PHPUnit_Extensions_Database_Constraint_DataSetIsEqual($this->expectedDataSet);
$dataSet = new PHPUnit_Extensions_Database_DataSet_FlatXmlDataSet(dirname(__FILE__) . '/../_files/XmlDataSets/FilteredTestComparison.xml');
$filteredDataSet = new PHPUnit_Extensions_Database_DataSet_DataSetFilter($dataSet);
$filteredDataSet->addIncludeTables(array('table1', 'table3'));
$filteredDataSet->setExcludeColumnsForTable('table1', array('table1_id'));
$filteredDataSet->setIncludeColumnsForTable('table3', array('column9', 'column10', 'column11', 'column12'));
self::assertThat($filteredDataSet, $constraint);
}