Lines Matching refs:t1
38 CREATE TABLE t1(a text, b text, c text);
43 } {t1}
47 set sql "INSERT INTO t1 VALUES('abc',"
50 execsql {SELECT a, c FROM t1}
53 execsql {SELECT b FROM t1}
57 set sql "INSERT INTO t1 VALUES('abc2',"
63 execsql {SELECT b FROM t1 ORDER BY c}
66 execsql {SELECT c FROM t1 ORDER BY c}
69 execsql {DELETE FROM t1 WHERE a='abc2'}
70 execsql {SELECT c FROM t1}
75 UPDATE t1 SET a=b, b=a;
76 SELECT b,c FROM t1
81 SELECT * FROM t1
86 INSERT INTO t1 VALUES('1','2','3');
87 INSERT INTO t1 VALUES('A','B','C');
88 SELECT b FROM t1 WHERE a=='1';
92 execsql "SELECT b FROM t1 WHERE a=='$::big1'"
95 execsql "SELECT b FROM t1 WHERE a!='$::big1' ORDER BY a"
102 CREATE INDEX i1 ON t1(a)
104 execsql "SELECT b FROM t1 WHERE a=='$::big1'"
108 UPDATE t1 SET a=b, b=a
110 execsql "SELECT b FROM t1 WHERE a=='abc'"
114 UPDATE t1 SET a=b, b=a
116 execsql "SELECT b FROM t1 WHERE a=='$::big1'"
131 DELETE FROM t1;
132 INSERT INTO t1(a,b,c) VALUES('one','abcdefghijklmnopqrstuvwxyz0123','hi');
134 execsql {SELECT a,length(b),c FROM t1}
138 UPDATE t1 SET b=b||b;
139 UPDATE t1 SET b=b||b;
140 UPDATE t1 SET b=b||b;
142 execsql {SELECT a,length(b),c FROM t1}
146 execsql "UPDATE t1 SET b=b||'$i'"
147 execsql {SELECT a,length(b),c FROM t1}
155 DELETE FROM t1;
156 INSERT INTO t1(a,b,c) VALUES('one','abcdefghijklmnopqrstuvwxyz0123','hi');
158 execsql {SELECT a,length(b),c FROM t1}
162 UPDATE t1 SET b=b||b;
163 UPDATE t1 SET b=b||b;
164 UPDATE t1 SET b=b||b;
165 UPDATE t1 SET b=b||b;
166 UPDATE t1 SET b=b||b;
167 UPDATE t1 SET b=b||b;
168 UPDATE t1 SET b=b||b;
169 UPDATE t1 SET b=b||b;
170 UPDATE t1 SET b=b||b;
171 UPDATE t1 SET b=b||b;
172 UPDATE t1 SET b=b||b;
173 UPDATE t1 SET b=b||b;
175 execsql {SELECT a,length(b),c FROM t1}
179 UPDATE t1 SET b=substr(b,1,65515)
181 execsql {SELECT a,length(b),c FROM t1}
185 execsql "UPDATE t1 SET b=b||'$i'"
186 execsql {SELECT a,length(b),c FROM t1}
195 DELETE FROM t1;
196 INSERT INTO t1(a,b,c) VALUES('one','abcdefghijklmnopqrstuvwxyz0123','hi');
198 execsql {SELECT a,length(b),c FROM t1}
204 UPDATE t1 SET b=b||b;
205 SELECT a,length(b),c FROM t1;
211 set r [catch {execsql {UPDATE t1 SET b=b||b}} msg]
215 execsql {DROP TABLE t1}