ZF-5263: fetchCol() and limit() with Oracle

Issue Type: Bug Created: 2008-12-15T05:25:08.000+0000 Last Updated: 2009-01-22T12:31:18.000+0000 Status: Resolved Fix version(s): - 1.8.0 (30/Apr/09)

Reporter: Mickael Perraud (mikaelkael) Assignee: Mickael Perraud (mikaelkael) Tags: - Zend_Db_Adapter_Oracle

Related issues: Attachments:


Method limit() of Oracle add an extra field "zend_db_rownum". This field is positioned at the beginning of the result.

In case of using fetchCol(), we return the value of "zend_db_rownum" instead of the desired field.

We can reverse in Zend_Db_Adapter_Oracle::limit():

<pre class="highlight">
SELECT ROWNUM AS zend_db_rownum, z1.*

should be

<pre class="highlight">
SELECT z1.*, ROWNUM AS zend_db_rownum


Posted by Mickael Perraud (mikaelkael) on 2009-01-22T11:52:30.000+0000

Fixed with SVN13754

Posted by Mickael Perraud (mikaelkael) on 2009-01-22T12:31:18.000+0000

Also fixed for Pdo_Oci with SVN13757

Have you found an issue?

See the Overview section for more details.


© 2006-2018 by Zend, a Rogue Wave Company. Made with by awesome contributors.

This website is built using zend-expressive and it runs on PHP 7.