ZF-5680: Zend_Db_Select problem with 2 order by and limit

Description

I'm using a MSSQL database.

When I use 2 or more order() method and set a limit (see example below) that resultset does not respect choosed orders

    $oSelect = new Zend_Db_Select($db);
    $oSelect
    ->from('Table_Name')
    ->where('condition')
    ->order('field_1 any_order')
    ->order('field_2 any_order')
    ->limit(int_value)
    ;
    $aResult = $db->fetchAll($oSelect);

P.S.: Sorry my bad english!!

Comments

That's same bug, but a little bit diferent construction

That's same bug, but with a little bit diferent construction

It duplicates ZF-4099.