Lines Matching full:coalesce
107 test_expr expr-1.58 {i1=NULL, i2=1} {coalesce(i1+i2,99)} 99
108 test_expr expr-1.59 {i1=1, i2=NULL} {coalesce(i1+i2,99)} 99
109 test_expr expr-1.60 {i1=NULL, i2=NULL} {coalesce(i1+i2,99)} 99
110 test_expr expr-1.61 {i1=NULL, i2=1} {coalesce(i1-i2,99)} 99
111 test_expr expr-1.62 {i1=1, i2=NULL} {coalesce(i1-i2,99)} 99
112 test_expr expr-1.63 {i1=NULL, i2=NULL} {coalesce(i1-i2,99)} 99
113 test_expr expr-1.64 {i1=NULL, i2=1} {coalesce(i1*i2,99)} 99
114 test_expr expr-1.65 {i1=1, i2=NULL} {coalesce(i1*i2,99)} 99
115 test_expr expr-1.66 {i1=NULL, i2=NULL} {coalesce(i1*i2,99)} 99
116 test_expr expr-1.67 {i1=NULL, i2=1} {coalesce(i1/i2,99)} 99
117 test_expr expr-1.68 {i1=1, i2=NULL} {coalesce(i1/i2,99)} 99
118 test_expr expr-1.69 {i1=NULL, i2=NULL} {coalesce(i1/i2,99)} 99
119 test_expr expr-1.70 {i1=NULL, i2=1} {coalesce(i1<i2,99)} 99
120 test_expr expr-1.71 {i1=1, i2=NULL} {coalesce(i1>i2,99)} 99
121 test_expr expr-1.72 {i1=NULL, i2=NULL} {coalesce(i1<=i2,99)} 99
122 test_expr expr-1.73 {i1=NULL, i2=1} {coalesce(i1>=i2,99)} 99
123 test_expr expr-1.74 {i1=1, i2=NULL} {coalesce(i1!=i2,99)} 99
124 test_expr expr-1.75 {i1=NULL, i2=NULL} {coalesce(i1==i2,99)} 99
125 test_expr expr-1.76 {i1=NULL, i2=NULL} {coalesce(not i1,99)} 99
126 test_expr expr-1.77 {i1=NULL, i2=NULL} {coalesce(-i1,99)} 99
127 test_expr expr-1.78 {i1=NULL, i2=NULL} {coalesce(i1 IS NULL AND i2=5,99)} 99
128 test_expr expr-1.79 {i1=NULL, i2=NULL} {coalesce(i1 IS NULL OR i2=5,99)} 1
129 test_expr expr-1.80 {i1=NULL, i2=NULL} {coalesce(i1=5 AND i2 IS NULL,99)} 99
130 test_expr expr-1.81 {i1=NULL, i2=NULL} {coalesce(i1=5 OR i2 IS NULL,99)} 1
131 test_expr expr-1.82 {i1=NULL, i2=3} {coalesce(min(i1,i2,1),99)} 99
132 test_expr expr-1.83 {i1=NULL, i2=3} {coalesce(max(i1,i2,1),99)} 99
133 test_expr expr-1.84 {i1=3, i2=NULL} {coalesce(min(i1,i2,1),99)} 99
134 test_expr expr-1.85 {i1=3, i2=NULL} {coalesce(max(i1,i2,1),99)} 99
147 test_expr expr-1.96 {i1=NULL, i2=3} {coalesce(i1<<i2,99)} 99
148 test_expr expr-1.97 {i1=32, i2=NULL} {coalesce(i1>>i2,99)} 99
149 test_expr expr-1.98 {i1=NULL, i2=NULL} {coalesce(i1|i2,99)} 99
150 test_expr expr-1.99 {i1=32, i2=NULL} {coalesce(i1&i2,99)} 99
332 test_expr expr-2.25 {r1=1.23, r2=NULL} {coalesce(r1+r2,99.0)} 99.0
333 test_expr expr-2.26 {r1=1e300, r2=1e300} {coalesce((r1*r2)*0.0,99.0)} 99.0
334 test_expr expr-2.26b {r1=1e300, r2=-1e300} {coalesce((r1*r2)*0.0,99.0)} 99.0
373 test_expr epxr-3.33 {t1='abc', t2=NULL} {coalesce(t1<t2,99)} 99
374 test_expr epxr-3.34 {t1='abc', t2=NULL} {coalesce(t2<t1,99)} 99
375 test_expr epxr-3.35 {t1='abc', t2=NULL} {coalesce(t1>t2,99)} 99
376 test_expr epxr-3.36 {t1='abc', t2=NULL} {coalesce(t2>t1,99)} 99
377 test_expr epxr-3.37 {t1='abc', t2=NULL} {coalesce(t1<=t2,99)} 99
378 test_expr epxr-3.38 {t1='abc', t2=NULL} {coalesce(t2<=t1,99)} 99
379 test_expr epxr-3.39 {t1='abc', t2=NULL} {coalesce(t1>=t2,99)} 99
380 test_expr epxr-3.40 {t1='abc', t2=NULL} {coalesce(t2>=t1,99)} 99
381 test_expr epxr-3.41 {t1='abc', t2=NULL} {coalesce(t1==t2,99)} 99
382 test_expr epxr-3.42 {t1='abc', t2=NULL} {coalesce(t2==t1,99)} 99
383 test_expr epxr-3.43 {t1='abc', t2=NULL} {coalesce(t1!=t2,99)} 99
384 test_expr epxr-3.44 {t1='abc', t2=NULL} {coalesce(t2!=t1,99)} 99
