1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
|
# name: test/sql/function/numeric/test_is_nan.test
# description: isnan test
# group: [numeric]
statement ok
SET default_null_order='nulls_first';
foreach type FLOAT DOUBLE
query III
SELECT isnan(3::${type}), isnan('nan'::${type}), isnan(NULL::${type})
----
false true NULL
statement ok
CREATE TABLE floats(f ${type})
statement ok
INSERT INTO floats VALUES (3), ('nan'), ('inf'), ('-inf'), (NULL)
query IIII
SELECT f, isnan(f), isinf(f), isfinite(f) FROM floats ORDER BY f
----
NULL NULL NULL NULL
-inf False True False
3 False False True
inf False True False
nan True False False
statement ok
DROP TABLE floats
endloop
|
