Lines Matching full:coalesce
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 {
60 SELECT coalesce(b,NOT b,-b,abs(b),lower(b),length(b),min(b,5),b*123,c)
64 do_test coalesce-1.7 {
70 do_test coalesce-1.8 {
73 SELECT coalesce(
