Hi, Now I understand the problem. The timezones are actually the same (at least during the date used in the test case), but they are one day apart... I can't apply your patch, because the calendar 'regular' _must_ be the current system calendar. However I changed the loop that looks for a different timezone. Now it gets Etc/GMT+11 in your timezone. By the way changing the current system timezone during the test is also not an option, because H2 caches when loading (calendar operations are really slow otherwise).
Regards, Thomas On Wed, Dec 9, 2009 at 7:21 PM, Thomas Mueller <[email protected]> wrote: > Hi, > > Thanks for the patch. But, now the test doesn't work any more for me. > It looks like a bug, but I'm not sure if it's in H2 or in > java.util.Calendar... > > Regards, > Thomas > > On Sun, Dec 6, 2009 at 10:52 PM, Kerry Sainsbury <[email protected]> wrote: >> Hi Thomas, >> >> There is a problem with running the "TestResultSet.testDatetimeWithCalendar" >> test in New Zealand. >> >> The code gets a "regular" Calendar, and an "other" calendar, via the time >> zone's "raw offset", which in New Zealand evaluates to: >> >> - Regular = Pacific/Auckland timezone with a "raw offset" of 43200000 >> - Other = the Etc/GMT+12 timezone with a "raw offset" of -43200000 >> >> Given that Auckland is also GMT+12 I'm confused as to why "Etc/GMT+12" ends >> up with a negative "raw offset", but that's not your fault! >> >> Anyway, you might like to adjust the test to use specific timezones, so that >> it always works, where-ever in the world you are. Sample patch attached. >> >> Cheers >> Kerry >> >> -- >> >> You received this message because you are subscribed to the Google Groups >> "H2 Database" group. >> To post to this group, send email to [email protected]. >> To unsubscribe from this group, send email to >> [email protected]. >> For more options, visit this group at >> http://groups.google.com/group/h2-database?hl=en. >> > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
