Select distinct returns wrong data

[Osimbo]

Hello:

I'm using your sqlite-jdbc wrapper and when i do a 'select distinct'
in table i get gat the same results that i get when doing a 'select'.

Doing the same with postgres and h2 i get the correct ones.

TIA

[cbare]

One way to help isolate the problem would be to try the same query
using sqlite's command line tool. See if you get the correct results
there. If you get different results through the JDBC driver, then
that's pretty suspicious.

-chris