IEEE special values in stream query expressions
The following information about IEEE special values applies to the following expressions:
![*](chapterTOC_bullet.png)
The key expression in a
with unique clause
![*](chapterTOC_bullet.png)
A
partition by expression
![*](chapterTOC_bullet.png)
The expressions that define the conditions in a
join clause
![*](chapterTOC_bullet.png)
A
group by expression
If one of these expressions is a decimal or float value, or a container that involves a decimal or float value, and the decimal or float value is an IEEE special value, then the following applies:
![*](chapterTOC_bullet.png)
NaN — This value is illegal as all or part of an expression and terminates the monitor instance.
![*](chapterTOC_bullet.png)
Positive/negative infinity — These values are legal and all positive infinities are treated as equal as are all negative infinities.