InstantDB Project
About InstantDB
Project Mail Lists
Short History
Reporting Bugs
Screen Shots
3rd Party Examples
FAQs

Software
Downloads
Documentation
CVS Repositories
Roadmap
License

About Enhydra.org
Who We Are
News, Articles & Events
Getting Involved
Contact Us

Community
Demos
Contributions
Resources
Case Studies
On The Edge! -NEW-
Commercial Vendors

Andrus

Thanks for reporting this. You're quite right, InstantDB is 
interpreting 37.314 as the number of seconds, but it does so as a 
floating point number and so is susceptible to rounding errors.

I'm going to replace this with integer arithmetic for the next version. 
If it's causing you problems right now then I could probably get a fix 
to you a bit quicker.

Regards

Pete

--

Peter Hearty              peter.hearty@lutris.com
Lutris Technologies (UK)  http://www.lutris.com/

----- Original Message -----
From: Andrus Suitsu <andrus.suitsu@proekspert.ee>
Date: Tuesday, November 28, 2000 11:32 am
Subject: iDB 3.24b2 bug report

> Hello!
> 
> 1) Problem description:
> Probable timestamp insert/display/select rounding error in idb3_24b2.
> I use String to insert timestamp values. I use full format ('2000-
> 11-28 
> 10:45:37.312') including milliseconds. The datetime column 
> sometimes displays 
> different value from the actually inserted value. Search using the 
> diplayed 
> value will fail. A program which first queries all timestamp 
> values from a 
> table and then tries to retrieve the rows based on these values, 
> will fail to 
> find all rows.
> 
> 2) Sample script:
> d org.enhydra.instantdb.jdbc.idbDriver;
> o jdbc:idb:host.prp;
> e set export "trace.log" trace 2 console;
> e drop table test;
> e create table test(systime datetime);
> e insert into test values('2000-11-28 10:45:37.314');
> q select * from test;
> q select * from test where systime='2000-11-28 10:45:37.313';
> c close;
> 
> The results of this script (trace.log):
> sample.txt drop table test
> sample.txt create table test(systime datetime)
> sample.txt insert into test values('2000-11-28 10:45:37.314')
> sample.txt select * from test
> 2000-11-28 10:45:37.313
> sample.txt select * from test where systime='2000-11-28 
> 10:45:37.313' 
> 
> 3) Database .prp file is attached.
> 
> 4) Script is self-contained.
> 
> 5) Operating system is RedHat Linux 7.0
> 
> 6) java -version displayed:
> java version "1.3.0"
> Java(TM) 2 Runtime Environment, Standard Edition (build 1.3.0)
> Classic VM (build 1.3.0, J2RE 1.3.0 IBM build cx130-20000815 (JIT 
> enabled: 
> jitc)) 
> 
> 7) Development environment used:
> Inprise JBuilder 4 Foundation.
> 
> 
> -- 
> Andrus Suitsu
> AS Proekspert
> e-mail: andrus.suitsu@proekspert.ee
> PGP: EF0A CA35 0850 DA10  E4E1 68D0 EFB9 8E3D
> phone: +372 651 8700
> direct: +372 651 8704
> mobile: +372 50 26126
> fax: +372 651 8701

-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.