Re: dbexport with smallfloat - v7.22 on AIX 4.2

On Fri, 4 Sep 1998, Fred Prose wrote: > Database definition looks like: > > create table "informix".r_roman_nums > ( > roman_numeral char(10) not null , > number_equivalent smallfloat not null , > description char(40) not null ,... > > A row has the value of numeric zero (0) for number_equivalent. > > Dbexport produces the following: > > 0|-1e|Zero| > > When attempting dbimport, the following error occurs: > > *** put loadcur > 1223 - Value will not fit in a FLOAT. > > Am I doing something wrong or do I have a (gasp!) bug? Because -1e is not a valid floating point number (there would have to be a digit after the e for it to be valid, or no e at all), you almost certainly have a bug. As so often with potential bug reports, you have not given us any information about the platform or product versions, so I can't do much in the way of checking about whether is is a known bug or not. Of course, it is debatable whether any roman numeral (I, V, X, L, C, D, M) has a zero number equivalent, but that doesn't stop the exported format from being invalid. Yours, Jonathan Leffler (jleffler@informix.com) #include <witticism.h> Guardian of DBD::Informix v0.60 -- http://www.perl.com/CPAN Informix IDN for D4GL & Linux -- http://www.informix.com/idn PS: Fred got an earlier copy of this email (DNS config errors prevented it going to c.d.i), and has responded that it is version 7.22 on AIX 4.2. A quick scan of PTS suggests that this is known bug B75159 (this report mentions -le -- letters l and e rather than digit one, letter e as reported by Fred, but the one pixel difference is easy to overlook), and B75159 is a DUP of B64885, which is known to be fixed in version 7.24.UC1. There are a couple of other bugs in the family; they are all AIX specific.