'''Problem: '''While debugging some test units unit tests (testRead, testUpdate) I have noticed that the error message is the following:''"Doesn't match the serialized representation"''.<br/> '''Investigation:'''

I run ran the same tests in MySQL: I 've got the same dataas in PostgreSQL. The only difference is the order of rawsrows, so I figured it has something to do with default ordering in PostgreSQL:<br/> The null value sorts higher than any other value. In other words, with '''ascending ''' sort order, <br>'''null values ''' sort at the '''end''', and with descending sort order, null values sort at the beginning.<br/> If not specified, '''<tt>ASC</tt>''' is assumed by '''default'''.<br/>And in the MySQL:<br/> When doing an ORDER BY, '''NULL values''' are presented '''first''' if you do ORDER BY ... ASC ('''default''') <br>and last if you do ORDER BY ... DESC. <br/>This explains why testUpdates gives the specified message, and I guess we have the same issue when we are trying to read '''without order by''' clause. '''Solution:''' Every time we have ORDER BY we specify '''nulls first''' (this option is supported in PostgreSQL 8.3 and later).