close Warning: Can't synchronize with repository "(default)" (/var/svn/tolp does not appear to be a Subversion repository.). Look in the Trac log for more information.

Opened 15 years ago

Closed 15 years ago

#1169 closed defect (fixed)

SqlEngine::SqlMicFormatReal

Reported by: Javier Gallardo Owned by: Víctor de Buen Remiro
Priority: lowest Milestone: Mantainance
Component: Kernel Version: head
Severity: trivial Keywords:
Cc:

Description

A partir de los cambios de If(?, ..., ...) se produce el Warning:

[If] la función de condición no puede devolver valores desconocidos.

que por un lado no perjudica el resultado, pero por otro resulta molesto.

Propongo que la función sea:


Text SqlMicFormatReal(Real rea)

{

Real isUnk = IsUnknown(rea);
Real isInf = IsInfinite(rea);

If(Or(isUnk, isInf),

"convert(float, null)",

{

Real filRea = If(LT(-SqlMicDefaultPrecision, rea, SqlMicDefaultPrecision),

rea,
Sign(rea)*SqlMicDefaultPrecision

);

FormatReal(filRea,SqlMicFormatRealTol2Sql)

})

};

Change History (2)

comment:1 Changed 15 years ago by Víctor de Buen Remiro

In change [3450] Fixed #1169

comment:2 Changed 15 years ago by Víctor de Buen Remiro

Resolution: → fixed
Status: new → closed
Note: See TracTickets for help on using tickets.