Lines Matching refs:coalesce

90 test_expr expr-1.58 {i1=NULL, i2=1} {coalesce(i1+i2,99)} 99
91 test_expr expr-1.59 {i1=1, i2=NULL} {coalesce(i1+i2,99)} 99
92 test_expr expr-1.60 {i1=NULL, i2=NULL} {coalesce(i1+i2,99)} 99
93 test_expr expr-1.61 {i1=NULL, i2=1} {coalesce(i1-i2,99)} 99
94 test_expr expr-1.62 {i1=1, i2=NULL} {coalesce(i1-i2,99)} 99
95 test_expr expr-1.63 {i1=NULL, i2=NULL} {coalesce(i1-i2,99)} 99
96 test_expr expr-1.64 {i1=NULL, i2=1} {coalesce(i1*i2,99)} 99
97 test_expr expr-1.65 {i1=1, i2=NULL} {coalesce(i1*i2,99)} 99
98 test_expr expr-1.66 {i1=NULL, i2=NULL} {coalesce(i1*i2,99)} 99
99 test_expr expr-1.67 {i1=NULL, i2=1} {coalesce(i1/i2,99)} 99
100 test_expr expr-1.68 {i1=1, i2=NULL} {coalesce(i1/i2,99)} 99
101 test_expr expr-1.69 {i1=NULL, i2=NULL} {coalesce(i1/i2,99)} 99
102 test_expr expr-1.70 {i1=NULL, i2=1} {coalesce(i1<i2,99)} 99
103 test_expr expr-1.71 {i1=1, i2=NULL} {coalesce(i1>i2,99)} 99
104 test_expr expr-1.72 {i1=NULL, i2=NULL} {coalesce(i1<=i2,99)} 99
105 test_expr expr-1.73 {i1=NULL, i2=1} {coalesce(i1>=i2,99)} 99
106 test_expr expr-1.74 {i1=1, i2=NULL} {coalesce(i1!=i2,99)} 99
107 test_expr expr-1.75 {i1=NULL, i2=NULL} {coalesce(i1==i2,99)} 99
108 test_expr expr-1.76 {i1=NULL, i2=NULL} {coalesce(not i1,99)} 99
109 test_expr expr-1.77 {i1=NULL, i2=NULL} {coalesce(-i1,99)} 99
110 test_expr expr-1.78 {i1=NULL, i2=NULL} {coalesce(i1 IS NULL AND i2=5,99)} 99
111 test_expr expr-1.79 {i1=NULL, i2=NULL} {coalesce(i1 IS NULL OR i2=5,99)} 1
112 test_expr expr-1.80 {i1=NULL, i2=NULL} {coalesce(i1=5 AND i2 IS NULL,99)} 99
113 test_expr expr-1.81 {i1=NULL, i2=NULL} {coalesce(i1=5 OR i2 IS NULL,99)} 1
114 test_expr expr-1.82 {i1=NULL, i2=3} {coalesce(min(i1,i2,1),99)} 99
115 test_expr expr-1.83 {i1=NULL, i2=3} {coalesce(max(i1,i2,1),99)} 99
116 test_expr expr-1.84 {i1=3, i2=NULL} {coalesce(min(i1,i2,1),99)} 99
117 test_expr expr-1.85 {i1=3, i2=NULL} {coalesce(max(i1,i2,1),99)} 99
130 test_expr expr-1.96 {i1=NULL, i2=3} {coalesce(i1<<i2,99)} 99
131 test_expr expr-1.97 {i1=32, i2=NULL} {coalesce(i1>>i2,99)} 99
132 test_expr expr-1.98 {i1=NULL, i2=NULL} {coalesce(i1|i2,99)} 99
133 test_expr expr-1.99 {i1=32, i2=NULL} {coalesce(i1&i2,99)} 99
161 test_expr expr-2.25 {r1=1.23, r2=NULL} {coalesce(r1+r2,99.0)} 99.0
197 test_expr epxr-3.33 {t1='abc', t2=NULL} {coalesce(t1<t2,99)} 99
198 test_expr epxr-3.34 {t1='abc', t2=NULL} {coalesce(t2<t1,99)} 99
199 test_expr epxr-3.35 {t1='abc', t2=NULL} {coalesce(t1>t2,99)} 99
200 test_expr epxr-3.36 {t1='abc', t2=NULL} {coalesce(t2>t1,99)} 99
201 test_expr epxr-3.37 {t1='abc', t2=NULL} {coalesce(t1<=t2,99)} 99
202 test_expr epxr-3.38 {t1='abc', t2=NULL} {coalesce(t2<=t1,99)} 99
203 test_expr epxr-3.39 {t1='abc', t2=NULL} {coalesce(t1>=t2,99)} 99
204 test_expr epxr-3.40 {t1='abc', t2=NULL} {coalesce(t2>=t1,99)} 99
205 test_expr epxr-3.41 {t1='abc', t2=NULL} {coalesce(t1==t2,99)} 99
206 test_expr epxr-3.42 {t1='abc', t2=NULL} {coalesce(t2==t1,99)} 99
207 test_expr epxr-3.43 {t1='abc', t2=NULL} {coalesce(t1!=t2,99)} 99
208 test_expr epxr-3.44 {t1='abc', t2=NULL} {coalesce(t2!=t1,99)} 99