public function testAddAndDistinctColumns() { $table1 = "myTable1"; $column1 = "myColumn1"; $value1 = "myValue1"; $key1 = "{$table1}.{$column1}"; $table2 = "myTable2"; $column2 = "myColumn2"; $value2 = "myValue2"; $key2 = "{$table2}.{$column2}"; $this->c->add($key1, $value1, Criteria::EQUAL); $this->c->addAnd($key2, $value2, Criteria::EQUAL); $expect = "SELECT FROM myTable1, myTable2 WHERE myTable1.myColumn1=:p1 AND myTable2.myColumn2=:p2"; $params = array(); $result = BasePeer::createSelectSql($this->c, $params); $expect_params = array(array('table' => 'myTable1', 'column' => 'myColumn1', 'value' => 'myValue1'), array('table' => 'myTable2', 'column' => 'myColumn2', 'value' => 'myValue2')); $this->assertEquals($expect, $result, 'addAnd() called on a distinct column adds a criterion to the criteria'); $this->assertEquals($expect_params, $params, 'addAnd() called on a distinct column adds a criterion to the criteria'); }