Zend Framework

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.6.0, 1.6.1, 1.6.2, 1.7.0, 1.7.1
• Fix Version/s: 1.8.0
• Component/s: Zend_Db_Adapter_Oracle
• Labels:

  None

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

• Assignee:

  Mickael Perraud

  Reporter:

  Mickael Perraud

• Created:

  15/Dec/08 5:25 AM

  Updated:

  22/Jan/09 12:31 PM

  Resolved:

  22/Jan/09 11:52 AM