HomeSort by relevance Sort by last modified time
    Searched full:coalesce (Results 1 - 25 of 248) sorted by null

1 2 3 4 5 6 7 8 910

  /external/chromium_org/third_party/sqlite/src/test/
coalesce.test 11 # Additional test cases for the COALESCE() and IFNULL() functions.
18 do_test coalesce-1.0 {
30 SELECT coalesce(b,c,d) FROM t1 ORDER BY a;
33 do_test coalesce-1.1 {
35 SELECT coalesce(d+c+b,d+c,d) FROM t1 ORDER BY a;
38 do_test coalesce-1.2 {
43 do_test coalesce-1.3 {
48 do_test coalesce-1.4 {
53 do_test coalesce-1.5 {
58 do_test coalesce-1.6
    [all...]
randexpr1.test 36 db eval {SELECT coalesce((select 11 from t1 where 19 in (t1.b,+11,coalesce((select max((abs(17)/abs(t1.f))) from t1 where ((abs(t1.f)/abs(t1.b)) in (select case (min(t1.a | d*d)+(abs(count(*)-count(*)+ -count(*)*max( -t1.c))-max(f))) when -count(distinct 19) then ((count(*))) else max(13) end from t1 union select count(distinct b) from t1)) or 19 in (t1.a,t1.c,17)),17) | 17)),13) FROM t1 WHERE not not c=a-+(select case ~case -~+count(distinct (select count(distinct t1.a)*max(13) from t1))+max( -19*f)*max(f)*max(f)* -count(distinct d)-(count(distinct 11)) | max(t1.f)*count(*) when count(distinct b) then count(distinct t1.b) else -min(t1.f) end*cast(avg(11) AS integer) when max(t1.f) then max(c) else count(*) end from t1)+d}
39 db eval {SELECT coalesce((select 11 from t1 where 19 in (t1.b,+11,coalesce((select max((abs(17)/abs(t1.f))) from t1 where ((abs(t1.f)/abs(t1.b)) in (select case (min(t1.a | d*d)+(abs(count(*)-count(*)+ -count(*)*max( -t1.c))-max(f))) when -count(distinct 19) then ((count(*))) else max(13) end from t1 union select count(distinct b) from t1)) or 19 in (t1.a,t1.c,17)),17) | 17)),13) FROM t1 WHERE NOT (not not c=a-+(select case ~case -~+count(distinct (select count(distinct t1.a)*max(13) from t1))+max( -19*f)*max(f)*max(f)* -count(distinct d)-(count(distinct 11)) | max(t1.f)*count(*) when count(distinct b) then count(distinct t1.b) else -min(t1.f) end*cast(avg(11) AS integer) when max(t1.f) then max(c) else count(*) end from t1)+d)}
42 db eval {SELECT coalesce((select 11 from t1 where 19 in (t1.b,+11,coalesce((select max((abs(17)/abs(t1.f))) from t1 where ((abs(t1.f)/abs(t1.b)) in (select case (min(t1.a & d*d)+(abs(count(*)-count(*)+ -count(*)*max( -t1.c))-max(f))) when -count(distinct 19) then ((count(*))) else max(13) end from t1 union select count(distinct b) from t1)) or 19 in (t1.a,t1.c,17)),17) & 17)),13) FROM t1 WHERE NOT (not not c=a-+(select case ~case -~+count(distinct (select count(distinct t1.a)*max(13) from t1))+max( -19*f)*max(f)*max(f)* -count(distinct d)-(count(distinct 11)) | max(t1.f)*count(*) when count(distinct b) then count(distinct t1.b) else -min(t1.f) end*cast(avg(11) AS integer) when max(t1.f) then max(c) else count(*) end from t1)+d)}
45 db eval {SELECT t1.c*19-t1.f*19+coalesce((select 17 from t1 where e in (f,case (select cast(avg(t1.a) AS integer) from t1)-t1.d when coalesce((select +case when not exists(select 1 from t1 where 17<>t1.f and ((a))<t1.b) then t1.c when c not between b and 11 then case when t1.c<f then t1.b when e in (t1.d,t1.d, -e) then d else t1.b end else f end+11 from t1 where exists(select 1 from t1 where t1.f in (select (count(distinct f)) from t1 union select max(11) from t1))),e) then 11 else t1.a end,t1.d)),13)*b+b FROM t1 WHERE ~t1.b<case when t1.b+t1.c in (select -count(distinct 17+coalesce((select max( -f+t1.c-d) from t1 where (19>=a) and t1.b between f and 13),t1.a))+case abs(+(max(19))) | count(distinct t1.e) | count(distinct 19) when count(*) then (max(a)) else count(distinct d) end from t1 union select (count(*)) from t1) and t1.b>=19 then d when t1.b in (select d from t1 union select c from t1) then t1.e else a end}
48 db eval {SELECT t1.c*19-t1.f*19+coalesce((select 17 from t1 where e in (f,case (select cast(avg(t1.a) AS integer) from t1)-t1.d when coales (…)
    [all...]
tkt-b351d95f9.test 35 INSERT INTO t2 SELECT a, coalesce(b,a) FROM t1;
42 INSERT INTO t2 SELECT a, coalesce(b,a) FROM t1;
auth2.test 62 catchsql {SELECT coalesce(min(a,b,c),999) FROM t1}
66 } {coalesce min}
69 catchsql {SELECT coalesce(a,b,c) FROM t1}
73 } coalesce
minmax2.test 143 SELECT coalesce(min(x+0),-1), coalesce(max(x+0),-1) FROM
149 SELECT y, coalesce(sum(x),0) FROM
169 SELECT coalesce(min(x),999) FROM t3;
174 SELECT coalesce(min(rowid),999) FROM t3;
179 SELECT coalesce(max(x),999) FROM t3;
184 SELECT coalesce(max(rowid),999) FROM t3;
189 SELECT coalesce(max(rowid),999) FROM t3 WHERE rowid<25;
311 SELECT coalesce(min(x),-1) FROM t6;
322 SELECT coalesce(min(x),-1) FROM t6
    [all...]
trigger2.test 99 INSERT INTO rlog VALUES ( (SELECT coalesce(max(idx),0) + 1 FROM rlog),
101 (SELECT coalesce(sum(a),0) FROM tbl),
102 (SELECT coalesce(sum(b),0) FROM tbl),
108 INSERT INTO rlog VALUES ( (SELECT coalesce(max(idx),0) + 1 FROM rlog),
110 (SELECT coalesce(sum(a),0) FROM tbl),
111 (SELECT coalesce(sum(b),0) FROM tbl),
118 INSERT INTO clog VALUES ( (SELECT coalesce(max(idx),0) + 1 FROM clog),
120 (SELECT coalesce(sum(a),0) FROM tbl),
121 (SELECT coalesce(sum(b),0) FROM tbl),
149 INSERT INTO rlog VALUES ( (SELECT coalesce(max(idx),0) + 1 FROM rlog),
    [all...]
expr.test 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)} 9
    [all...]
trigger5.test 34 || coalesce(old.a,'NULL') || ',' || quote(old.b) || ',' || old.c || ');';
  /external/llvm/test/CodeGen/X86/
subreg-to-reg-3.ll 5 ; Don't eliminate or coalesce away the explicit zero-extension!
subreg-to-reg-1.ll 6 ; Don't eliminate or coalesce away the explicit zero-extension!
overlap-shift.ll 2 ;; cannot coalesce it with Y. Because of this, a copy needs to be
cse-add-with-overflow.ll 5 ; MachineCSE should coalesce trivial subregister copies.
  /external/chromium_org/content/common/input/
web_input_event_traits_unittest.cc 57 // Non touch-moves won't coalesce.
60 // Touches of different types won't coalesce.
63 // Touch moves with idential touch lengths and touch ids should coalesce.
66 // Touch moves with different touch ids should not coalesce.
77 // Touch moves with different touch lengths should not coalesce.
82 // Touch moves with identical touch ids in different orders should coalesce.
91 // Pointers with the same ID's should coalesce.
96 WebInputEventTraits::Coalesce(touch0, &touch1);
108 WebInputEventTraits::Coalesce(touch0, &touch1);
121 // Only GesturePinchUpdate's coalesce
    [all...]
web_input_event_traits.h 23 static void Coalesce(const blink::WebInputEvent& event_to_coalesce,
  /external/chromium_org/base/message_loop/
timer_slack.h 11 // allows the OS to coalesce timers more effectively.
  /external/chromium_org/media/base/
text_ranges_unittest.cc 47 // Coalesce first two ranges: [2, 5].
51 // Coalesce first two ranges: [2, 8].
108 // Coalesce first and second ranges.
133 // Coalesce middle and last ranges.
142 // Coalesce first and last ranges.
  /external/chromium_org/third_party/libvpx/source/libvpx/vpx_mem/memory_manager/
hmm_base.c 166 /* Flags if coalesce with adjacent block. */
167 int coalesce; variable
192 /* Coalesce with backward block if possible. */
204 coalesce = 1;
206 coalesce = 0;
209 coalesce = 1;
212 if (coalesce) {
230 /* Coalesce with forward block if possible. */
238 coalesce = 1;
240 coalesce = 0
    [all...]
hmm_grow.c 42 /* Simply free the new block, allowing it to coalesce with any
  /external/libvpx/libvpx/vpx_mem/memory_manager/
hmm_base.c 166 /* Flags if coalesce with adjacent block. */
167 int coalesce; variable
192 /* Coalesce with backward block if possible. */
204 coalesce = 1;
206 coalesce = 0;
209 coalesce = 1;
212 if (coalesce) {
230 /* Coalesce with forward block if possible. */
238 coalesce = 1;
240 coalesce = 0
    [all...]
hmm_grow.c 42 /* Simply free the new block, allowing it to coalesce with any
  /hardware/intel/common/omx-components/videocodec/libvpx_internal/libvpx/vpx_mem/memory_manager/
hmm_base.c 166 /* Flags if coalesce with adjacent block. */
167 int coalesce; variable
192 /* Coalesce with backward block if possible. */
204 coalesce = 1;
206 coalesce = 0;
209 coalesce = 1;
212 if (coalesce) {
230 /* Coalesce with forward block if possible. */
238 coalesce = 1;
240 coalesce = 0
    [all...]
hmm_grow.c 42 /* Simply free the new block, allowing it to coalesce with any
  /external/llvm/test/CodeGen/ARM/
2012-10-04-AAPCS-byval-align8.ll 29 ; ldm is not formed when the coalescer failed to coalesce everything.
56 ; ldm is not formed when the coalescer failed to coalesce everything.
  /external/chromium_org/components/policy/core/common/
policy_loader_ios.h 41 // Used to coalesce repeated notifications into a single Load() call.
  /external/chromium_org/content/browser/renderer_host/
event_with_latency_info.h 38 WebInputEventTraits::Coalesce(other.event, &event);

Completed in 1024 milliseconds

1 2 3 4 5 6 7 8 910