It's looking like it's my bad. The dates that were returning zero had
somehow been deleted from the test database (which is what my
development platform's app server was pointing to) but DBW (where I was
testing the queries) was pointing at the production database.

Sorry for the confusion.

-----Original Message-----
From: Roman Rokytskyy [mailto:rrokytskyy@...]
Sent: Thursday, October 07, 2004 6:38 PM
To: Firebird-Java@yahoogroups.com
Subject: Re: [Firebird-Java] Query returns invalid result

> Is there a debug version of Jaybird?

JayBird is compiled with debug information. Sources are also available
for
download, also you can get them from CVS.

> I could send you the DDL for the table, but much of the data is
> sensitive.

DDL does not help. I would need data, even dummy ones (important are IDs
and
dates, rest is more or less garbage from my POV).

> And since this only fails sometimes, given my luck you
> wouldn't be able to reproduce it.

That is bad... If this is not reproducable, then it can also happen that
in
Database Workbench you're just lucky...

Try asking about such SQL construct in Firebird-Support, maybe you get
more
information there.

Roman





Yahoo! Groups Links