/**
* @group ZF-5146
*/
public function testAdapterReadClobFetchOneLobAsString()
{
$this->_db->setLobAsString(true);
parent::testAdapterReadClobFetchOne();
}
/**
* @group ZF-9252
* @see zf-trunk/tests/Zend/Db/Adapter/Zend_Db_Adapter_TestCommon#testAdapterLimitOffset()
*/
public function testAdapterLimitOffset()
{
parent::testAdapterLimitOffset();
$products = $this->_db->quoteIdentifier('zfproducts');
$product_id = $this->_db->quoteIdentifier('product_id');
$sql = $this->_db->limit("SELECT * FROM $products ORDER BY $products.$product_id", 1, 1);
$stmt = $this->_db->query($sql);
$result = $stmt->fetchAll();
$this->assertEquals(1, count($result),
'Expecting row count to be 1');
$this->assertEquals(2, $result[0]['product_id'],
'Expecting to get product_id 2');
}