l3pp4rd/DoctrineExtensions — Issue #282: Incorrect results while using Translatable + 'order by'
Author: dinamic
Created: 2012-03-09 10:25:26+00:00
State: open

The incorrect result seem to come from the fact that all the values are stored in plain text and sorting text column is entirely different world than sorting integer column.

Example:
id | title | sort_order
1 | a | 5
2 | a | 28

Query: select.. order by sort_order DESC, title ASC

While checking the results you will notice that the item 1 is before item 2, which would mean that the sort_order is higher, which is not the case.