Lines Matching refs:file2

182   execsql {ATTACH 'test2.db' as file2}
183 execsql {ATTACH 'test2.db' as file2} db2
186 lock_status 4.1.1 db {main unlocked temp closed file2 unlocked}
187 lock_status 4.1.2 db2 {main unlocked temp closed file2 unlocked}
198 lock_status 4.2.1 db {main shared temp closed file2 unlocked}
199 lock_status 4.2.2 db2 {main unlocked temp closed file2 unlocked}
206 lock_status 4.3.1 db {main shared temp closed file2 unlocked}
207 lock_status 4.3.2 db2 {main unlocked temp closed file2 unlocked}
217 lock_status 4.4.1 db {main shared temp closed file2 unlocked}
218 lock_status 4.4.2 db2 {main unlocked temp closed file2 unlocked}
230 # Handle 'db2' reserves file2.
232 execsql {INSERT INTO file2.t1 VALUES(1, 2)} db2
235 # db2 - reserved(file2)
238 lock_status 4.5.1 db {main shared temp closed file2 unlocked}
239 lock_status 4.5.2 db2 {main unlocked temp closed file2 reserved}
244 SELECT * FROM file2.t1;
247 # db - shared(main), shared(file2)
248 # db2 - reserved(file2)
251 lock_status 4.6.1.1 db {main shared temp closed file2 shared}
252 lock_status 4.6.1.2 db2 {main unlocked temp closed file2 reserved}
257 UPDATE file2.t1 SET a=0;
261 lock_status 4.6.2.1 db {main shared temp closed file2 shared}
262 lock_status 4.6.2.2 db2 {main unlocked temp closed file2 reserved}
266 # failing to obtain a write-lock on file2.
272 lock_status 4.7.1 db {main shared temp closed file2 shared}
273 lock_status 4.7.2 db2 {main reserved temp closed file2 reserved}
280 lock_status 4.8.1 db {main shared temp closed file2 shared}
281 lock_status 4.8.2 db2 {main reserved temp closed file2 reserved}
290 lock_status 4.9.1 db {main shared temp closed file2 shared}
291 lock_status 4.9.2 db2 {main reserved temp closed file2 reserved}
298 lock_status 4.10.1 db {main shared temp closed file2 shared}
299 lock_status 4.10.2 db2 {main pending temp closed file2 reserved}
307 lock_status 4.11.1 db {main unlocked temp closed file2 unlocked}
308 lock_status 4.11.2 db2 {main pending temp closed file2 reserved}
315 lock_status 4.12.1 db {main unlocked temp closed file2 unlocked}
316 lock_status 4.12.2 db2 {main unlocked temp closed file2 unlocked}
319 execsql {SELECT * FROM file2.t1}