February 24, 2006

hsqldb + dates suck :(, but fixed in latest version :)

Writing about web page http://www.hsqldb.org/

So I was using a fairly old version of hsqldb and was doing some unit tests of my DAO which was selecting some rows based on a date column <= someDate.

Unforunately it behaved in the exact opposite way I was expecting :( If someDate was later than the value in the database column then you would expect dateColumn <= someDate to evaluate to true. But no, it didn't. It evaluated to false. Changing the condition to dateDolumn >= someDate evaluated to true!

And yes, timezones etc. were the same :)

Oh well, at least it was consistently wrong.

Upgrading to the latest hsqldb fixed it, and it was fun while it lasted :)

- No comments Not publicly viewable

Add a comment

You are not allowed to comment on this entry as it has restricted commenting permissions.

February 2006

Mo Tu We Th Fr Sa Su
Jan |  Today  | Mar
      1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28               

Search this blog



Most recent comments

  • Interesting… While I'm not completely convinced in such microbenchmarks, I'm pretty sure that 1ms … by Alexander Snaps on this entry
  • Hello. I bought the book yesterday. I was trying to find the source code for chapter 11 and chapter … by Suleman on this entry
  • http://woosight.net/account/login?username=demo by live mashup demo on this entry
  • Thanks mate ….. This blog was really helpful. by Maaz Hurzuk on this entry
  • Ty. Not directly helpful for my problem, but pointed me in the right direction. You will also get th… by Mike E. on this entry

Blog archive

Not signed in
Sign in

Powered by BlogBuilder