firebird-automations

Commented by: Paul Faid (pfaid) I've attached a db backup that helps illustrate the problem\.

Modified by: Paul Faid (pfaid) Attachment: maxnantest\.fbk \[ 11141 \]

Commented by: Sean Leyne (seanleyne) If you mean by "NAN" that the value is "NULL" \(which is the correct SQL term\), then what you are seeing is functionality which explicitly...

Modified by: Sean Leyne (seanleyne) status: Open \[ 1 \] =\> Resolved \[ 5 \] resolution: Won't Fix \[ 2 \]

Commented by: @asfernandes Sean, NaN == Not a Number \(floating point term\)\.

Commented by: Philip Williams (unordained) a\) this report was for max\(\), not sum\(\) b\) please refer to the Firebird NULL Guide, as it explicitly states that aggregates such as min,...

Commented by: @asfernandes The report is valid, see my comment\. Depending on the order, NaNs are considered as MAX or not\.

Modified by: @asfernandes status: Resolved \[ 5 \] =\> Reopened \[ 4 \] resolution: Won't Fix \[ 2 \] =\>

Commented by: Smirnoff Serg (wildsery) I realized that Firebird knows nothing about NaN, and try process it like common float, that's why such artefacts appears\. Author may use NULL instead...

Commented by: Paul Faid (pfaid) Further to this report, when I'm using the Firebird embedded server, any sql which tries to interpret the NAN values causes an exception in my...