Bug 104894 - Firebird/HSQLDB: Firebird throws error where HSQLDB reports NaN
Summary: Firebird/HSQLDB: Firebird throws error where HSQLDB reports NaN
Status: RESOLVED NOTOURBUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
5.4.0.0.alpha0+
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-12-23 19:28 UTC by Robert Großkopf
Modified: 2016-12-31 21:32 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Robert Großkopf 2016-12-23 19:28:43 UTC 
While testing Firebird with LO 5.4.0.0 alpha0 I get the following:

SELECT ACOS(1.1) FROM "Table"

firebird sdbc-error
...
*Argument for ACOS must be in the range [-1,1]

Same in HSQLDB doesn't throw an error. Writes only down 'NaN' instead of any value.

The behavior of both is correct. But wouldn't it be better Firebird ignores wrong values and gives 'NaN' as HSQLDB does?
Comment 1 Lionel Elie Mamane 2016-12-31 21:32:48 UTC 
That's a Firebird question, not LibreOffice.