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:

Description

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():


SELECT ROWNUM AS zend_db_rownum, z1.*

should be


SELECT z1.*, ROWNUM AS zend_db_rownum

Comments

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