Lines Matching refs:t1
36 CREATE TABLE t1(a text, b text, c text);
41 } {t1}
45 set sql "INSERT INTO t1 VALUES('abc',"
48 execsql {SELECT a, c FROM t1}
51 execsql {SELECT b FROM t1}
55 set sql "INSERT INTO t1 VALUES('abc2',"
61 execsql {SELECT b FROM t1 ORDER BY c}
64 execsql {SELECT c FROM t1 ORDER BY c}
67 execsql {DELETE FROM t1 WHERE a='abc2'}
68 execsql {SELECT c FROM t1}
73 UPDATE t1 SET a=b, b=a;
74 SELECT b,c FROM t1
79 SELECT * FROM t1
84 INSERT INTO t1 VALUES('1','2','3');
85 INSERT INTO t1 VALUES('A','B','C');
86 SELECT b FROM t1 WHERE a=='1';
90 execsql "SELECT b FROM t1 WHERE a=='$::big1'"
93 execsql "SELECT b FROM t1 WHERE a!='$::big1' ORDER BY a"
100 CREATE INDEX i1 ON t1(a)
102 execsql "SELECT b FROM t1 WHERE a=='$::big1'"
106 UPDATE t1 SET a=b, b=a
108 execsql "SELECT b FROM t1 WHERE a=='abc'"
112 UPDATE t1 SET a=b, b=a
114 execsql "SELECT b FROM t1 WHERE a=='$::big1'"
129 DELETE FROM t1;
130 INSERT INTO t1(a,b,c) VALUES('one','abcdefghijklmnopqrstuvwxyz0123','hi');
132 execsql {SELECT a,length(b),c FROM t1}
136 UPDATE t1 SET b=b||b;
137 UPDATE t1 SET b=b||b;
138 UPDATE t1 SET b=b||b;
140 execsql {SELECT a,length(b),c FROM t1}
144 execsql "UPDATE t1 SET b=b||'$i'"
145 execsql {SELECT a,length(b),c FROM t1}
153 DELETE FROM t1;
154 INSERT INTO t1(a,b,c) VALUES('one','abcdefghijklmnopqrstuvwxyz0123','hi');
156 execsql {SELECT a,length(b),c FROM t1}
160 UPDATE t1 SET b=b||b;
161 UPDATE t1 SET b=b||b;
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;
173 execsql {SELECT a,length(b),c FROM t1}
177 UPDATE t1 SET b=substr(b,1,65515)
179 execsql {SELECT a,length(b),c FROM t1}
183 execsql "UPDATE t1 SET b=b||'$i'"
184 execsql {SELECT a,length(b),c FROM t1}
193 DELETE FROM t1;
194 INSERT INTO t1(a,b,c) VALUES('one','abcdefghijklmnopqrstuvwxyz0123','hi');
196 execsql {SELECT a,length(b),c FROM t1}
202 UPDATE t1 SET b=b||b;
203 SELECT a,length(b),c FROM t1;
209 set r [catch {execsql {UPDATE t1 SET b=b||b}} msg]
213 execsql {DROP TABLE t1}