Back to home page

OSCL-LXR

 
 

    


0001 -- This file tests special values such as NaN, Infinity and NULL.
0002 
0003 SELECT udf(x) FROM (VALUES (1), (2), (NULL)) v(x);
0004 SELECT udf(x) FROM (VALUES ('A'), ('B'), (NULL)) v(x);
0005 SELECT udf(x) FROM (VALUES ('NaN'), ('1'), ('2')) v(x);
0006 SELECT udf(x) FROM (VALUES ('Infinity'), ('1'), ('2')) v(x);
0007 SELECT udf(x) FROM (VALUES ('-Infinity'), ('1'), ('2')) v(x);
0008 SELECT udf(x) FROM (VALUES 0.00000001, 0.00000002, 0.00000003) v(x);