Home
last modified time | relevance | path

Searched refs:coalesce (Results 1 – 12 of 12) sorted by relevance

/titanic_50/usr/src/lib/libsqlite/test/
H A Dexpr.test90 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
[all …]
H A Dminmax.test130 SELECT coalesce(min(x+0),-1), coalesce(max(x+0),-1) FROM
155 SELECT coalesce(min(x),999) FROM t3;
160 SELECT coalesce(min(rowid),999) FROM t3;
165 SELECT coalesce(max(x),999) FROM t3;
170 SELECT coalesce(max(rowid),999) FROM t3;
175 SELECT coalesce(max(rowid),999) FROM t3 WHERE rowid<25;
291 SELECT coalesce(min(x),-1) FROM t6;
302 SELECT coalesce(min(x),-1) FROM t6;
H A Dfunc.test61 execsql {SELECT coalesce(length(a),-1) FROM t2}
203 execsql {SELECT coalesce(round(a,2),'nil') FROM t2}
227 # Test the coalesce() and nullif() functions
230 execsql {SELECT coalesce(a,'xyz') FROM t2}
233 execsql {SELECT coalesce(upper(a),'nil') FROM t2}
236 execsql {SELECT coalesce(nullif(1,1),'nil')}
239 execsql {SELECT coalesce(nullif(1,2),'nil')}
242 execsql {SELECT coalesce(nullif(1,NULL),'nil')}
H A Dtrigger2.test87 INSERT INTO rlog VALUES ( (SELECT coalesce(max(idx),0) + 1 FROM rlog),
95 INSERT INTO rlog VALUES ( (SELECT coalesce(max(idx),0) + 1 FROM rlog),
104 INSERT INTO clog VALUES ( (SELECT coalesce(max(idx),0) + 1 FROM clog),
130 INSERT INTO rlog VALUES ( (SELECT coalesce(max(idx),0) + 1 FROM rlog),
138 INSERT INTO rlog VALUES ( (SELECT coalesce(max(idx),0) + 1 FROM rlog),
158 INSERT INTO rlog VALUES ( (SELECT coalesce(max(idx),0) + 1 FROM rlog),
166 INSERT INTO rlog VALUES ( (SELECT coalesce(max(idx),0) + 1 FROM rlog),
H A Dselect1.test164 execsql {SELECT coalesce(min(a),'xyzzy') FROM t3}
167 execsql {SELECT min(coalesce(a,'xyzzy')) FROM t3}
193 execsql {SELECT coalesce(max(a),'xyzzy') FROM t3}
196 execsql {SELECT max(coalesce(a,'xyzzy')) FROM t3}
519 SELECT coalesce(f1/(f1-11),'x'),
520 coalesce(min(f1/(f1-11),5),'y'),
521 coalesce(max(f1/(f1-33),6),'z')
H A Dsubselect.test61 execsql {SELECT b from t1 where a = coalesce((SELECT a FROM t1 WHERE b=5),1)}
H A Ddate.test24 execsql "SELECT coalesce($expr,'NULL')"
H A Djoin.test327 SELECT coalesce(t8.a,999) from t7 LEFT JOIN t8 on y=a;
/titanic_50/usr/src/cmd/lockstat/
H A Dlockstat.c481 coalesce(int (*cmp)(lsrec_t *, lsrec_t *), lsrec_t **lock, int n) in coalesce() function
1525 coalesce(lockcmp, sort_buf, g_nrecs_used); in main()
1545 coalesce(lockcmp, sort_buf, g_nrecs_used); in main()
1554 coalesce(lockcmp_anywhere, sort_buf, g_nrecs_used); in main()
1563 coalesce(sitecmp_anylock, sort_buf, g_nrecs_used); in main()
/titanic_50/usr/src/uts/common/avs/ns/sdbc/
H A Dsd_io.c882 int coalesce; /* convenience boolean */ in _sd_async_flclist() local
890 coalesce = (!sdbc_do_page && sdbc_coalesce_backend); in _sd_async_flclist()
936 if (coalesce && (anon_mem = sdbc_alloc_io_mem(cc_ent, first_dirty, in _sd_async_flclist()
945 if (!coalesce) in _sd_async_flclist()
974 if (!coalesce) in _sd_async_flclist()
/titanic_50/usr/src/cmd/look/
H A Dwords4622 coalesce
/titanic_50/usr/src/cmd/spell/
H A Dlist4621 coalesce