Lines Matching refs:b
38 CREATE TABLE t1(a text, b text, c text);
53 execsql {SELECT b FROM t1}
63 execsql {SELECT b FROM t1 ORDER BY c}
75 UPDATE t1 SET a=b, b=a;
76 SELECT b,c FROM t1
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"
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'"
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}
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}
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]