Lines Matching refs:val

54   CREATE TABLE t1(seq INTEGER PRIMARY KEY, val TEXT);
71      AND decimal_cmp(a.val,b.val)>=0;
77      AND decimal_cmp(a.val,b.val)==0;
83      AND decimal_cmp(a.val,b.val)<=0;
86   SELECT seq FROM t1 ORDER BY val COLLATE decimal;
89   SELECT seq FROM t1 ORDER BY val COLLATE decimal DESC;
93   CREATE TABLE t3(seq INTEGER PRIMARY KEY, val TEXT);
95     INSERT INTO t3(seq, val) SELECT x, x FROM c;
97     INSERT INTO t3(seq, val) SELECT x+10, x*1000 FROM c;
98   SELECT decimal(val) FROM t3 ORDER BY seq;
101   SELECT decimal_add(val,'0.5') FROM t3 WHERE seq>5 ORDER BY seq
104   SELECT decimal_add(val,'-10') FROM t3 ORDER BY seq;
108   SELECT decimal_sum(val) FROM t3;
111   SELECT decimal_sum(decimal_add(val,val||'e+10')) FROM t3;
114   SELECT decimal_sum(decimal_add(val||'e+20',decimal_add(val,val||'e-20')))