Path: utzoo!mnetor!uunet!mcvax!unido!iraun1!Chicago!rader From: rader@Chicago.ira.uka.de (Klaus Radermacher) Newsgroups: comp.databases Subject: Problems with data-type FLOATING in VAXDBMS Message-ID: <482@iraun1.ira.uka.de> Date: 3 Mar 88 12:20:52 GMT Sender: news@iraun1.ira.uka.de Reply-To: rader@ira.uka.de (Klaus Radermacher) Organization: University of Karlsruhe, W.-Germany Lines: 35 Setting up a database with VAXDBMS database system on a VAX8700 I encountered the following problem: Having a record with only one single item of type FLOATING I could not fetch an record of this type using the following DML-Statement: fetch first where eq 8.05 The system's answer was END-OF-COLLECTION, although the record definitely existed in the database. The following statement did find the record: fetch first where ge 8.05 and le 8.0505 The system gave out the correct record. I understand that the problem arises due to the internal representation of the type FLOATING, the stored value must be a little bit larger than 8.05. However, DEC claims in the manuals, that FLOATING has a precision of about 7 digits, and the stored value was exactly 8.05! Has anyone encountered similar problems yet? How did you get around the problem? I'm glad to hear from you. Klaus Radermacher Institut fuer Programmstrukturen und Datenorganisation University of Karlsruhe FRG e-mail: rader@ira.uka.de