Hi Noel,

They are strings at first but then converted to the correct data type (it 
is this way since I am gathering the data from JSON)

After some debugging of my code and H2 code I have understood and fixed the 
problem.

I had to implement the getCreateSQL() on my extending index returning null 
because if not the index in some situations can be used
to sort and then not triggering the Collections.sort() in the SortOrder 
class

@Override
public String getCreateSQL() {
    return null;
}


Thank you very much for your time.

Happy Holidays.

Pedro



On Saturday, 24 December 2016 05:24:24 UTC, Noel Grandin wrote:
>
> Hmmm, I notice in your code that you are declaring the column as type 
> date, but then filling it with strings?
> On Sat, 24 Dec 2016 at 00:24, Pedro Almeida <[email protected] 
> <javascript:>> wrote:
>
>> The unit test you added I can see that the sort test is being applied to 
>> a INT column.
>>
>> The problem I detect is only happening with columns of data type DATE 
>> and only when sorting with asc
>>
>> On Thursday, 22 December 2016 07:37:30 UTC, Noel Grandin wrote:
>>
>>> I just pushed an updated unit test to GitHub. 
>>>
>>> Sorry, I can see anything obviously wrong with your code. 
>>>
>>> -- 
>> You received this message because you are subscribed to the Google Groups 
>> "H2 Database" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to [email protected] <javascript:>.
>> To post to this group, send email to [email protected] 
>> <javascript:>.
>> Visit this group at https://groups.google.com/group/h2-database.
>> For more options, visit https://groups.google.com/d/optout.
>>
>

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.

Reply via email to