Lines Matching refs:t1
23 execsql {CREATE TABLE tbl1(t1 text)}
27 execsql {SELECT t1 FROM tbl1 ORDER BY t1}
44 execsql {SELECT length(t1) FROM tbl1 ORDER BY t1}
47 set r [catch {execsql {SELECT length(*) FROM tbl1 ORDER BY t1}} msg]
51 set r [catch {execsql {SELECT length(t1,5) FROM tbl1 ORDER BY t1}} msg]
55 execsql {SELECT length(t1), count(*) FROM tbl1 GROUP BY length(t1)
56 ORDER BY length(t1)}
65 execsql {SELECT substr(t1,1,2) FROM tbl1 ORDER BY t1}
68 execsql {SELECT substr(t1,2,1) FROM tbl1 ORDER BY t1}
71 execsql {SELECT substr(t1,3,3) FROM tbl1 ORDER BY t1}
74 execsql {SELECT substr(t1,-1,1) FROM tbl1 ORDER BY t1}
77 execsql {SELECT substr(t1,-1,2) FROM tbl1 ORDER BY t1}
80 execsql {SELECT substr(t1,-2,1) FROM tbl1 ORDER BY t1}
83 execsql {SELECT substr(t1,-2,2) FROM tbl1 ORDER BY t1}
86 execsql {SELECT substr(t1,-4,2) FROM tbl1 ORDER BY t1}
89 execsql {SELECT t1 FROM tbl1 ORDER BY substr(t1,2,20)}
110 execsql {SELECT t1 FROM tbl1 ORDER BY t1}
113 execsql {SELECT length(t1) FROM tbl1 ORDER BY t1}
116 execsql {SELECT substr(t1,1,2) FROM tbl1 ORDER BY t1}
119 execsql {SELECT substr(t1,1,3) FROM tbl1 ORDER BY t1}
122 execsql {SELECT substr(t1,2,2) FROM tbl1 ORDER BY t1}
125 execsql {SELECT substr(t1,2,3) FROM tbl1 ORDER BY t1}
128 execsql {SELECT substr(t1,3,2) FROM tbl1 ORDER BY t1}
131 execsql {SELECT substr(t1,4,2) FROM tbl1 ORDER BY t1}
134 execsql {SELECT substr(t1,-1,1) FROM tbl1 ORDER BY t1}
137 execsql {SELECT substr(t1,-3,2) FROM tbl1 ORDER BY t1}
140 execsql {SELECT substr(t1,-4,3) FROM tbl1 ORDER BY t1}
147 execsql {SELECT t1 FROM tbl1}
156 CREATE TABLE t1(a,b,c);
157 INSERT INTO t1 VALUES(1,2,3);
158 INSERT INTO t1 VALUES(2,1.2345678901234,-12345.67890);
159 INSERT INTO t1 VALUES(3,-2,-5);
161 catchsql {SELECT abs(a,b) FROM t1}
164 catchsql {SELECT abs() FROM t1}
167 catchsql {SELECT abs(b) FROM t1 ORDER BY a}
170 catchsql {SELECT abs(c) FROM t1 ORDER BY a}
176 execsql {SELECT abs(t1) FROM tbl1}
180 catchsql {SELECT round(a,b,c) FROM t1}
183 catchsql {SELECT round(b,2) FROM t1 ORDER BY b}
186 catchsql {SELECT round(b,0) FROM t1 ORDER BY a}
189 catchsql {SELECT round(c) FROM t1 ORDER BY a}
192 catchsql {SELECT round(c,a) FROM t1 ORDER BY a}
195 catchsql {SELECT 'x' || round(c,a) || 'y' FROM t1 ORDER BY a}
198 catchsql {SELECT round() FROM t1 ORDER BY a}
204 execsql {SELECT round(t1,2) FROM tbl1}
210 execsql {SELECT upper(t1) FROM tbl1}
213 execsql {SELECT lower(upper(t1)) FROM tbl1}