public function testSelectGroupByAutoExpr()
{
$server = $this->_util->getServer();
if ($server == 'IDS') {
$this->markTestIncomplete('IDS does not support this SQL syntax');
} else {
parent::testSelectGroupByAutoExpr();
}
}
/**
* Mysqli does not support named binds
* ZF-2017: Test bind use of the Zend_Db_Select class.
* @group ZF-2017
* @expectedException Zend_Db_Statement_Exception
*/
public function testSelectQueryWithBinds()
{
parent::testSelectQueryWithBinds();
}
public function testSelectHavingOrWithParameter()
{
//SQLite doesn't need different test from 5.3
if (version_compare(PHP_VERSION, '5.3.0', '>=')) {
return parent::testSelectHavingOrWithParameter();
}
$select = $this->_selectHavingOrWithParameter();
$stmt = $this->_db->query($select);
$result = $stmt->fetchAll();
$bugs_products = $this->_db->quoteIdentifier('zfbugs_products');
$bug_id = $this->_db->quoteIdentifier('bug_id');
$key = "{$bugs_products}.{$bug_id}";
$this->assertEquals(3, count($result));
$this->assertEquals(1, $result[0][$key]);
$this->assertEquals(3, $result[0]['thecount']);
$this->assertEquals(2, $result[1][$key]);
$this->assertEquals(1, $result[1]['thecount']);
}
