Lines Matching refs:b

35     CREATE TABLE t1(a text, b text, c text);
50   execsql {SELECT b FROM t1}
60   execsql {SELECT b FROM t1 ORDER BY c}
72     UPDATE t1 SET a=b, b=a;
73     SELECT b,c FROM t1
85     SELECT b FROM t1 WHERE a=='1';
89   execsql "SELECT b FROM t1 WHERE a=='$::big1'"
92   execsql "SELECT b FROM t1 WHERE a!='$::big1' ORDER BY a"
101   execsql "SELECT b FROM t1 WHERE a=='$::big1'"
105     UPDATE t1 SET a=b, b=a
107   execsql "SELECT b FROM t1 WHERE a=='abc'"
111     UPDATE t1 SET a=b, b=a
113   execsql "SELECT b FROM t1 WHERE a=='$::big1'"
129     INSERT INTO t1(a,b,c) VALUES('one','abcdefghijklmnopqrstuvwxyz0123','hi');
131   execsql {SELECT a,length(b),c FROM t1}
135     UPDATE t1 SET b=b||b;
136     UPDATE t1 SET b=b||b;
137     UPDATE t1 SET b=b||b;
139   execsql {SELECT a,length(b),c FROM t1}
143     execsql "UPDATE t1 SET b=b||'$i'"
144     execsql {SELECT a,length(b),c FROM t1}
153     INSERT INTO t1(a,b,c) VALUES('one','abcdefghijklmnopqrstuvwxyz0123','hi');
155   execsql {SELECT a,length(b),c FROM t1}
159     UPDATE t1 SET b=b||b;
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;
172   execsql {SELECT a,length(b),c FROM t1}
176     UPDATE t1 SET b=substr(b,1,65515)
178   execsql {SELECT a,length(b),c FROM t1}
182     execsql "UPDATE t1 SET b=b||'$i'"
183     execsql {SELECT a,length(b),c FROM t1}
193     INSERT INTO t1(a,b,c) VALUES('one','abcdefghijklmnopqrstuvwxyz0123','hi');
195   execsql {SELECT a,length(b),c FROM t1}
201       UPDATE t1 SET b=b||b;
202       SELECT a,length(b),c FROM t1;
208   catchsql {UPDATE t1 SET b=b||b}
211   execsql {SELECT length(b) FROM t1}
214   catchsql {UPDATE t1 SET b=b||b}
217   execsql {SELECT length(b) FROM t1}