Lines Matching refs:length

40 # Check out the length() function
43   execsql {SELECT length(t1) FROM tbl1 ORDER BY t1}
46   set r [catch {execsql {SELECT length(*) FROM tbl1 ORDER BY t1}} msg]
48 } {1 {wrong number of arguments to function length()}}
50   set r [catch {execsql {SELECT length(t1,5) FROM tbl1 ORDER BY t1}} msg]
52 } {1 {wrong number of arguments to function length()}}
54   execsql {SELECT length(t1), count(*) FROM tbl1 GROUP BY length(t1)
55            ORDER BY length(t1)}
58   execsql {SELECT coalesce(length(a),-1) FROM t2}
111   execsql {SELECT length(t1) FROM tbl1 ORDER BY t1}
477     SELECT length(randomblob(32)), length(randomblob(-5)),
478            length(randomblob(2000))
521     sum(length(replace(printf('abc%.*cxyz',x,'m'),'m','nnnn'))-(6+x*4))
1310 # Verify that the length() and typeof() functions do not actually load
1323   db eval {SELECT typeof(x), length(x), typeof(y) FROM t29 ORDER BY id}
1349   db eval {SELECT sum(length(x)) FROM t29}
1358 # for fields with content-length=0 when the content offset is on an overflow
1369   SELECT length(f), length(g), length(h), length(i) FROM t29b;
1402   SELECT char(), length(char()), typeof(char())