Lines Matching refs:t1

25   execsql {CREATE TABLE tbl1(t1 text)}
29   execsql {SELECT t1 FROM tbl1 ORDER BY t1}
46   execsql {SELECT length(t1) FROM tbl1 ORDER BY t1}
49   set r [catch {execsql {SELECT length(*) FROM tbl1 ORDER BY t1}} msg]
53   set r [catch {execsql {SELECT length(t1,5) FROM tbl1 ORDER BY t1}} msg]
57   execsql {SELECT length(t1), count(*) FROM tbl1 GROUP BY length(t1)
58            ORDER BY length(t1)}
67   execsql {SELECT substr(t1,1,2) FROM tbl1 ORDER BY t1}
70   execsql {SELECT substr(t1,2,1) FROM tbl1 ORDER BY t1}
73   execsql {SELECT substr(t1,3,3) FROM tbl1 ORDER BY t1}
76   execsql {SELECT substr(t1,-1,1) FROM tbl1 ORDER BY t1}
79   execsql {SELECT substr(t1,-1,2) FROM tbl1 ORDER BY t1}
82   execsql {SELECT substr(t1,-2,1) FROM tbl1 ORDER BY t1}
85   execsql {SELECT substr(t1,-2,2) FROM tbl1 ORDER BY t1}
88   execsql {SELECT substr(t1,-4,2) FROM tbl1 ORDER BY t1}
91   execsql {SELECT t1 FROM tbl1 ORDER BY substr(t1,2,20)}
112   execsql {SELECT t1 FROM tbl1 ORDER BY t1}
115   execsql {SELECT length(t1) FROM tbl1 ORDER BY t1}
118   execsql {SELECT substr(t1,1,2) FROM tbl1 ORDER BY t1}
121   execsql {SELECT substr(t1,1,3) FROM tbl1 ORDER BY t1}
124   execsql {SELECT substr(t1,2,2) FROM tbl1 ORDER BY t1}
127   execsql {SELECT substr(t1,2,3) FROM tbl1 ORDER BY t1}
130   execsql {SELECT substr(t1,3,2) FROM tbl1 ORDER BY t1}
133   execsql {SELECT substr(t1,4,2) FROM tbl1 ORDER BY t1}
136   execsql {SELECT substr(t1,-1,1) FROM tbl1 ORDER BY t1}
139   execsql {SELECT substr(t1,-3,2) FROM tbl1 ORDER BY t1}
142   execsql {SELECT substr(t1,-4,3) FROM tbl1 ORDER BY t1}
149   execsql {SELECT t1 FROM tbl1}
158     CREATE TABLE t1(a,b,c);
159     INSERT INTO t1 VALUES(1,2,3);
160     INSERT INTO t1 VALUES(2,1.2345678901234,-12345.67890);
161     INSERT INTO t1 VALUES(3,-2,-5);
163   catchsql {SELECT abs(a,b) FROM t1}
166   catchsql {SELECT abs() FROM t1}
169   catchsql {SELECT abs(b) FROM t1 ORDER BY a}
172   catchsql {SELECT abs(c) FROM t1 ORDER BY a}
178   execsql {SELECT abs(t1) FROM tbl1}
182   catchsql {SELECT round(a,b,c) FROM t1}
185   catchsql {SELECT round(b,2) FROM t1 ORDER BY b}
188   catchsql {SELECT round(b,0) FROM t1 ORDER BY a}
191   catchsql {SELECT round(c) FROM t1 ORDER BY a}
194   catchsql {SELECT round(c,a) FROM t1 ORDER BY a}
197   catchsql {SELECT 'x' || round(c,a) || 'y' FROM t1 ORDER BY a}
200   catchsql {SELECT round() FROM t1 ORDER BY a}
206   execsql {SELECT round(t1,2) FROM tbl1}
212   execsql {SELECT upper(t1) FROM tbl1}
215   execsql {SELECT lower(upper(t1)) FROM tbl1}