/**
  * @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');
 }
Exemple #2
0
 /**
  * @group ZF-5146
  */
 public function testAdapterReadClobFetchOneLobAsString()
 {
     $this->_db->setLobAsString(true);
     parent::testAdapterReadClobFetchOne();
 }